JDBC and SQL Syntax MCQ with Answers PDF Download – Test 240

MCQ 1196: To fetch large objects, the ResultSet interface provides method:

1. getBlob()
2. getClob
3. getTlob()
4. Both A and B

MCQ 1197: No two tuples in a relation are allowed to have exactly the same value for:

1. Some attributes
2. All attributes
3. Some tuple
4. All tuples

MCQ 1198: In the A1 search, to satisfy the selection operation the system scans each file block and tests:

1. Secondary index
2. All records
3. Primary index
4. Equality on nonkey

MCQ 1199: Functions defined in a programming language and compiled outside the database system may be loaded and executed with the:

1. Database-system parameters
2. Database-system state
3. Database-system code
4. Database-system procedures

MCQ 1200: The abstraction level that describes the entire database in terms of a relatively simple structure than physical level, is:

1. Logical level
2. Physical level
3. View level
4. Virtual level