11.) What does the DISTINCT keyword do?
A) Selects unique records
B) Deletes duplicate records
C) Sorts records
D) Filters records
12.) Which command is used to create a new table in a database?
A) INSERT
B) CREATE TABLE
C) ADD TABLE
D) NEW TABLE
13.) What is normalization in databases?
A) Increasing database size
B) Adding redundancy
C) Removing redundant data
D) Simplifying queries
14.) What does the JOIN clause do in SQL?
A) Combines data from multiple tables
B) Creates a new table
C) Deletes records
D) Updates records
15.) Which of the following is not a type of SQL join?
A) INNER JOIN
B) OUTER JOIN
C) CROSS JOIN
D) FULL JOIN
16.) What is a composite key?
A) A single unique key
B) A combination of two or more columns as a key
C) A duplicate key
D) None of the above
17.) Which command is used to modify existing rows in a table?
A) INSERT
B) MODIFY
C) UPDATE
D) ALTER
18.) What does ACID stand for in database transactions?
A) Atomicity, Consistency, Isolation, Durability
B) Accuracy, Connectivity, Integration, Durability
C) Atomicity, Clarity, Integrity, Dependability
D) None of the above
19.) What is a view in SQL?
A) A physical table
B) A virtual table based on a query
C) A key linking tables
D) None of the above
20.) What is the default sorting order in SQL?
A) Ascending
B) Descending
C) Random
D) None
Related
