Correct Answer: PGA
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Oracle 9i Administration Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Oracle 9i Administration MCQ Questions
Which of the following becomes available when an Oracle instance is started?
You have two undo tablespaces defined for your database. The instance is currently using the undo tablespace named UNDO_TBS1. You issue the following command to switch to UNDO_TBS2, while there are still transactions using UNDO_TBS1: ALTER SYSTEM SET UNDO_TABLESPACE = undo_tbs2 What will be the result?
Which of the following types of files is a part of the Oracle database?
You need to create an index on the ITEM table, which is 10 GB in size. You want your index to be spread across many tablespaces, decrease contention for index lookup, and increase scalability and manageability. Which of the following types of indexes would be the best for this table?
Which of the following tables help build scalable applications and also proves to be useful for large tables that can be queried or manipulated using several processes concurrently?
Which of the following options enables you to increase the size of online redo log groups?
Which of the following statements is correct with regard to an Oracle instance?
Which of the following statements should you use to obtain information about the names, status of the control files?
When does the Log Writer (LGWR) process write the redo entries from the redo log buffer to the current online redo log group?
What provides for recovery of data that has not been written to the data files prior to a failure?