Advanced DBMS MCQs

Which of the following is NOT a type of database?

• Hierarchical

• Network

• Relational

• Sequential

Which command is used to remove all records from a table in SQL?

• REMOVE

• DELETE

• DROP

• TRUNCATE

Which key uniquely identifies a tuple in a relation?

• Super key

• Candidate key

• Primary key

• Foreign key

Which normal form removes partial dependency?

• 1NF

• 2NF

• 3NF

• BCNF

The language used to define database schema is:

• DDL

• DML

• DCL

• TCL

Which of the following is a DML command?

• CREATE

• SELECT

• GRANT

• COMMIT

In E-R model, the relationship between entities is represented by:

• Rectangle

• Ellipse

• Diamond

• Line

Which one of the following is a correct SQL syntax for creating a table?

• CREATE TABLE table_name;

• TABLE CREATE table_name;

• CREATE table_name TABLE;

• CREATE TABLE table_name (column1 datatype, column2 datatype);

Which of the following concurrency control protocols ensures conflict serializability?

• Two-phase locking

• Timestamp ordering

• Validation-based

• All of the above

Which schedule is always serializable and deadlock-free?

• 2PL

• Time-stamp ordering

• Cascadeless

• Strict