What are the Memory Structures subdivided as? – McqOptions

MCQOPTIONS

1.	What are the Memory Structures subdivided as?
A.	SGA
B.	PGA
C.	Sort Area
D.	All mentioned above
Answer» E.

Discussion

No Comment Found

Related MCQs

What are the Memory Structures subdivided as?
You want to protect your database from single point of failure by multiplexing the control file. Your database is started using SPFILE. You have to perform the following tasks, Give the correct order in which these tasks to be performed.1. Shut down the database instance.2. Copy the control file to new location.3. Configure the CONTROL_FILES parameter.4. Restart the instance.
You specified extent management as local for a tablespace. How will it affect space management in the tablespace?
Which initialization parameter Defines the location of the default file system directory for redo log files and control file creation when no file specification is given in the creation operation?
In the Oracle Database which file contain the information needed to maintain and verify database integrity, and include the names of all the Data Files and the online and archived log files?
What is the default size of an Oracle-managed redo log file?