Functions and Procedures Multiple Choice Questions (MCQ) PDF - 260

MCQ 1296: Variables are declared using the statement

1. Declare
2. Define
3. Create
4. Set

MCQ 1297: On top of any given set of actual relations, supporting a large number of views is

1. Possible
2. Impossible
3. Doesn't Exist
4. Complex

MCQ 1298: If an schedule doesn't include commit or abort operation, it is defined to be

1. Partial schedule
2. Dependent schedule
3. Serialized schedule
4. Unserialized schedule

MCQ 1299: The operation is what is performed when the operator is

1. Insertion
2. Overloaded
3. Invoked
4. Assigned

MCQ 1300: For the substitution of all, SQL uses the decode function, which conceptually is

1. Simple
2. Small
3. Complex
4. Large