CREATE KEYSPACE keyspace_name
WITH replication = { 'class' : 'SimpleStrategy', 'replication_factor' : 3 }
AND durable_writes = true;
Cassandra all programs
1 question -Here's how you can perform these tasks in SQL: ### 1. Create the `Student_info` Table ```sql CREATE TABLE Student_info ( rollno INT PRIMARY KEY, studname VARCHAR(50), age INT, department VARCHAR(50), lastexampercent DECIMAL(5, 2) ); ``` ### 2. Insert Records ```sql INSERT INTO Student_info (rollno, studname, age, department, lastexampercent) VALUES (1, 'John', 20, 'Computer Science', 85.5), (2, 'Alice', 22, 'Mathematics', 90.0), (3, 'Bob', 21, 'Physics', 78.5); ``` ### 3. View Records of Students with Roll Numbers 1, 2, and 3 ```sql SELECT * FROM Student_info WHERE rollno IN (1, 2, 3); ``` ### 4. Create an Index on the `studname` Column ```sql CREATE INDEX idx_studname ON Student_info (studname); ``` ### 5. Display the Records with a Limit of 2 Results ```sql SELECT * FROM Student_info LIMIT 2; ``` ### 6. Add a New Column `address` to the `Student_info` Table ```sql ALTER TABLE Student_info ADD addre...
Comments
Post a Comment