What is the reason that SORT_AREA SIZE and HASH_AREA_SIZE parameters a – McqOptions

MCQOPTIONS

1.	What is the reason that SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions?
A.	The User Global Area (UGA) is not configured
B.	The sessions were started using the login name SYS
C.	The sessions are running in the Automatic Shared Memory Management mode
D.	The sessions are running in the automatic Program Global Area (PGA) memory management mode
Answer» D. The sessions are running in the automatic Program Global Area (PGA) memory management mode

Discussion

No Comment Found

Related MCQs

Which view describes all clusters in the database?
You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?
Which command is used to drop HASH cluster?
What is the reason that SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions?
When creating a hash cluster, it is important to choose the cluster key correctly and set which of these parameters so that performance and space use are optimal?
In which of these situations hashing is not advantageous?
Which SYSTEM privilege must be used to create a cluster in another user's schema?
For maximum distribution of rows in a hash cluster, the database rounds the HASHKEYS value up to the nearest _________ .
You can create any cluster and associated cluster index in any tablespace that is _____ .
In a sorted hash cluster, the rows corresponding to each value of the hash function are sorted on a specified set of columns in which order and that can improve response time during subsequent operations on the clustered data?