Schemas Statements in SQL Multiple Choice Questions with Answers – PDF Download

MCQ 1: In Standard Query Language, the types of DROP commands include:

1. RESTRICT command
2. FOREIGN key command
3. CASCADE command
4. both a and c

MCQ 2: When the schema is to be dropped in SQL which has no elements then the type of DROP Command used is called:

1. SCALE DROP command
2. PRECISION DROP command
3. RESTRICT DROP schema
4. CASCADE DROP command

MCQ 3: The command in SQL which is used when any of the schema is no longer needed in relation is classified as:

1. DROP SCHEMA command
2. PICK SCHEMA command
3. DELETE SCHEMA command
4. RESTRICT SCHEMA command

MCQ 4: The command used in SQL which deletes the table definition as well as all the records available in the table is called:

1. DELETE command
2. DROP TABLE command
3. PRIMARY KEY command
4. SECONDARY KEY command

MCQ 5: Considering the change in schema statement in SQL, the command which is used to delete records of table and leave the definition of table for later use is classified as:

1. DELETE command
2. DROP TABLE command
3. PRIMARY KEY command
4. SECONDARY KEY command