The command                                  such tables are available only within the transaction executing the query and are dropped when the transaction finishes.

Related MCQs

• A type of query that is placed within a WHERE or HAVING clause of another query is called
• A type of query that is placed within a WHERE or HAVING clause of another query is called
• An operation is said to be                      if executing it several times in a row gives the same result as executing it once.
• A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a
• Any recursive view must be defined as the union of two subqueries: a                query that is nonrecursive and a                      query.
• Relational Algebra is a                      query language that takes two relations as input and produces another relation as an output of the query.
• Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
• Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.
• A system is in a              state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.
• Once the lower-level lock is released, the operation cannot be undone by using the old values of updated data items, and must instead be undone by executing a compensating operation; such an operation is called