DBMS Interview Questions Quiz (Multiple Choice)

What is the primary function of a database management system

Which of the following is a type of database model

Which language is used to define the structure of a database

Which key uniquely identifies a record in a table

Which operation combines rows from two or more tables

Which command is used to remove all records from a table

Which command is used to delete a table from the database

Which clause is used to filter records in SQL

What is the purpose of normalization

Which normal form eliminates transitive dependency

Which SQL function is used to count records

Which of these is a DML command

What is a foreign key used for

Which index is automatically created with the primary key

Which of these is not a type of join

Which command is used to change data in a table

What does ACID stand for in DBMS

Which isolation level offers the highest consistency

Which of the following prevents dirty reads

Which command is used to add a column to a table