Functions and Procedures Quiz with Answers PDF Download – Test 29

MCQ 141: The SQL standard supports functions that can return tables as results, such functions are called:

1. Table functions
2. Standard functions
3. Result functions
4. Callable functions

MCQ 142: For understanding of operations, the clauses must be written in the order:

1. Select, where, from
2. From, select, where
3. Select, from, where
4. From, where, select

MCQ 143: SQL standard supports a limited form of recursion, using the clause:

1. recursive clause
2. declare recursive clause
3. with recursive clause
4. without recursive clause

MCQ 144: The state in which the transaction stays while it is executing is termed as:

1. Active
2. Partially committed
3. Initial
4. Both A and C

MCQ 145: A collection of conceptual tools for describing data, data relationships, data semantics, and data constraints, is known as:

1. Data system
2. Data management
3. Data flow control
4. Data model