1z0-062 Exam Question 131
You configure your database Instance to support shared server connections.
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection? (Choose two.)
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection? (Choose two.)
1z0-062 Exam Question 132
What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?
1z0-062 Exam Question 133
What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?
1z0-062 Exam Question 134
In your database, USERS is the default permanent tablespace.
Examine the commands and their outcome:

You plan to execute the commands:

Which two statements are true? (Choose two.)
Examine the commands and their outcome:

You plan to execute the commands:

Which two statements are true? (Choose two.)
1z0-062 Exam Question 135
Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.
The steps to recover the tablespace are as follows:
1. Mount the CDB.
2. Close all the PDBs.
3. Open the database.
4. Apply the archive redo logs.
5. Restore the data file.
6. Take the SYSAUX tablespace offline.
7. Place the SYSAUX tablespace online.
8. Open all the PDBs with RESETLOGS.
9. Open the database with RESETLOGS.
10. Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?
The steps to recover the tablespace are as follows:
1. Mount the CDB.
2. Close all the PDBs.
3. Open the database.
4. Apply the archive redo logs.
5. Restore the data file.
6. Take the SYSAUX tablespace offline.
7. Place the SYSAUX tablespace online.
8. Open all the PDBs with RESETLOGS.
9. Open the database with RESETLOGS.
10. Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?