Relational Databases Quiz with Answers PDF Download – Test 177

MCQ 881: Record-based models are so named because the database is structured in:

1. Variable-format records of several type
2. Fixed-format record of several type
3. Fixed format records of one type
4. Variable format records of one type

MCQ 882: A function that sorts the rows and assigns each row a unique number relative to its position, is known as:

1. row_sort
2. sequence_row
3. row_number
4. row_rank

MCQ 883: Multiple rank expressions are applicable within a single:

1. Select statement
2. Where statement
3. In statement
4. From statement

MCQ 884: The privilege that can be granted on a function or procedure, enabling a user to execute the function/procedure, is known to be:

1. Update privilege
2. Execute privilege
3. Select privilege
4. Insert privilege

MCQ 885: The term stating either all operations of the transaction to be displayed at the database, or none at all is known to be:

1. Atomicity
2. Inconsistency
3. Isolation
4. Durability