Embedded SQL Quiz with Answers PDF Download – Test 105

MCQ 521: The preprocessor replaces embedded SQL requests with host-language declarations and procedure calls that allow:

1. Compilation
2. Retrieval
3. Function calls
4. Runtime execution

MCQ 522: The Query processor have different components of type:

1. 2 types
2. 3 types
3. 4 types
4. 5 types

MCQ 523: The most widely used structure for index structures, is known to be:

1. B+- trees structure
2. Balanced tree structure
3. Unbalanced tree structure
4. Sequential tree structure

MCQ 524: The operation that works like assignment in a programming language, is said to be:

1. Union operator
2. Assignment operator
3. Natural join operator
4. Set difference operator

MCQ 525: The authorization on a relation allows a user to update any tuple in the relation, is known to be:

1. select authorization
2. grant authorization
3. define authorization
4. update authorization