DBMS_QUIZ

Which of the following is the property of transaction that protects data from system failure?

• Consistency
• Isolation
• Reliability
• Durability

Which of the following is preserved in execution of transaction in isolation?

• Availability
• Durability
• Consistency
• Atomicity

Which normalization form is based on the transitive dependency?

• First Normal Form (1NF)
• Third Normal Form (3NF)
• Second Normal Form (2NF)
• Fourth Normal Form (4NF)

Which is the lowest level of abstraction that describes how the data are actually stored?

• logical level
• physical level
• conceptual level
• external level

For performing tasks like creating the structure of the relations, deleting relation, which of the following is used?

• Database Management System (DBMS)
• Presentation software
• Word processing software
• Spreadsheet software

What is rows of a relation known as?

• columns
• arrays
• variables
• tuples

During transaction before commit which of the following statement is done automatically in case of shutdown?

• RELEASE
• ROLLBACK
• SAVEPOINT
• COMMIT

Which of the following is the full form of TCL?

• Total Control Language
• Textual Command Line
• TRANSACTION CONTROL LANGUAGE

• Technical Computing Language

Which of the following SQL command is used for removing (or deleting) a relation form the database?

• DROP TABLE
• ERASE TABLE
• DELETE TABLE
• REMOVE TABLE

What is DBMS?

• COLLECTION OF MANY PROGRAMS TO ACCESS DATA

• COLLECTION OF COMMANDS

• COLLECTION OF INTER_RELATED DATA

• ALL OF THESE