Aggregate Functions Multiple Choice Questions (MCQ) PDF - 68

MCQ 336: All aggregate operations, return a value of null when applied on an

1. Avg collection
2. Sum collection
3. Data collection
4. Empty collection

MCQ 337: To grant a privilege with the grantor set to the current role associated with a session, we can add the clause

1. granted by current-roll
2. define by current-role
3. select by current-role
4. set by current-role

MCQ 338: When a transaction is rolled back and entered at the aborted stage, the available system's options are of

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

MCQ 339: For each attribute, the JDBC retrieve its

1. Name
2. Address
3. Data type
4. Both A and C

MCQ 340: The authorization types can be assigned to users as

1. All
2. None
3. Combinations
4. All of the Above