Correct Answer: There is one PGA for each User process.
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Oracle 8 DBA Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Oracle 8 DBA MCQ Questions
Which command will you use to mount the database in parallel mode?
Which statement is true with regard to Clusters in Oracle?
Which files are used to configure SQL*Net or Net8 on an Oracle client machine?
If the Oracle Parallel Query Option is installed and configured, how do you specify that a SQL query should be parallelized?
Your database has a tablespace called Data which contains all tables and indexes. For performance reasons, you want to shift all the indexes into a new tablespace called Idx. Which technique will you adopt?
Which SQL script is executed to create the data dictionary?
Which SQL script is executed to set up the replication option?
What does TNS stand for?
If Oracle Parallel Query Option is installed, which Oracle background process handles Parallel queries?
In order to implement the Oracle Multi-Threaded Server(MTS), which files must you configure?