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

To fetch large objects, the ResultSet interface provides method

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

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

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

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

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