Relational Databases Notes Questions with Answers PDF Download – Test 95

MCQ 471: The relational model hides low-level implementation details from:

1. Users
2. Developers
3. Both A and B
4. System itself

MCQ 472: The degree of durability in which transaction commits as soon as its written at the primary and the backup site is known to be:

1. One-safe
2. Two-very-safe
3. Two-safe
4. Three-safe

MCQ 473: For testing whether a subquery has duplicate tuples in its result, SQL includes a:

1. Comparison function
2. Boolean Function
3. Aggregate Function
4. Induced function

MCQ 474: File scans are algorithms for searching that is used to locate and retrieve records, fulfilling a:

1. Projection condition
2. Selection condition
3. Hashing condition
4. Evaluation plan condition

MCQ 475: At the logical level a record can be described as a:

1. Block
2. Type definition
3. Segments
4. Sequences