Storage Structure in Databases Multiple Choice Questions (MCQ) PDF - 276

MCQ 1376: Any changes made by the aborted transaction to the database, must be

1. Completed
2. Done
3. Undone
4. Displayed

MCQ 1377: The database designer reviews the schema for the confirmation of

1. Models
2. Data requirements
3. Framework
4. Systematic fashion

MCQ 1378: Create table department (dept name varchar (20), building varchar (15), budget numeric (12,2), primary key (dept name)); the commands shows

1. Retrieval of relation
2. Executing the relation
3. Creating a relation
4. Inserting in a relation

MCQ 1379: The result of Boolean expression 'false or unknown' is

1. Null
2. Unknown
3. True
4. False

MCQ 1380: Taking the instructor's relation into account, the integrity constraint ensures that no two instructors have the

1. Same Instructor Name
2. Same Instructor course
3. Same instructor ID
4. No multiple transaction