The ____ is used as a temporary storage area for ORDER BY or GROUP BY – McqOptions

MCQOPTIONS

1.	The ____ is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions.
A.	sort cache
B.	SQL cache
C.	data cache
D.	optimizer mode
Answer» B. SQL cache

Discussion

No Comment Found

Related MCQs

If every non-key attribute is functionally dependent on the primary key, then the relation will be in:
The airline reservation system, the enables are date, flight number, place of departure, destination, type of plane & seats available. The primary key is
A distributed database has which of the following advantages over a centralized database?
The DBMS acts as an interface between what two components of an enterprise-class database system?
When creating a database, in order to optimize performance, put high-usage tables in their own ____.
Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
Association of unknown instances with known instances is a process of .technique
Which of the following clause specifies the table or tables from where the data has to be retrieved?
Which property ensures that each functional dependency is represented in some individual relations resulting after decomposition?
The ____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM.