Embedded SQL Quiz with Answers PDF Download – Test 157

MCQ 781: To obtain the result tuples, the program must use the:

1. Open command
2. Insert command
3. Fetch command
4. Both A and C

MCQ 782: When the changes made by the aborted transaction has been undone, the transaction is said to be:

1. Committed
2. Derived
3. Rolled back
4. Depicted

MCQ 783: An interactive system that allows analysts to view contrasting summaries of multi dimensional data, is known to be:

1. Offline Analytical Processing
2. On-demand Analytical Processing
3. Online Analytical Processing
4. Object Analytical Processing

MCQ 784: The fourth normal form is the:

1. Optimized Normal form
2. Weaker than BCNF
3. Weaker than 3NF
4. Ultimate normal form

MCQ 785: When comparing values of corresponding attributes from two tuples, the values are treated as/ in:

1. Identical
2. Union
3. Unity
4. Pairs