Database Management System Interview Questions

Database Management System interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. ACID stands for

A. Atomicity, Consistency, Isolation, Durability

B. Atomicity, Concurrency, Isolation, Duplicity

C. Aggregation, Consistency, Isolation, Durability

D. Atomicity, Consistency, Identity, Durability

Correct Answer is : Atomicity, Consistency, Isolation, Durability

2. Prev LSN in database log is constructed using________ data structure

A. Tree

B. Graph

C. Link List

D. Queue

Correct Answer is : Link List

3. Each table in a database can have _______ primary key

A. Only one

B. At least one

C. More than one

D. Any number of

Correct Answer is : Only one

4. To create a PRIMARY KEY constraint on existing table “EMPLOYEE” on "EMPID" column and currently column does not contain any value , which is the correct SQL syntax from the following

A. Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key, EMPID;

B. Update table EMPLOYEE Add Constraint PK-EMPID Primary Key (EMPID);

C. Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key (EMPID);

D. Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key, (EMPID);

Correct Answer is : Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key (EMPID);

5. _______stores metadata about the structure of the database, in particular the schema of the database

A. Indices

B. Data Dictionary

C. Data files

D. Database log

Correct Answer is : Data Dictionary

Database Management System interview questions