Interview question based on skill :
Take as many assements as you can to improve your validate your skill rating
Total Questions: 5
1. ACID stands for
Correct Answer is : Atomicity, Consistency, Isolation, Durability
2. Prev LSN in database log is constructed using________ data structure
Correct Answer is : Link List
3. Each table in a database can have _______ primary key
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
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
Correct Answer is : Data Dictionary
