1z0-062 Exam Question 146
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)
1z0-062 Exam Question 147
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA
privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?
privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?
1z0-062 Exam Question 148
You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform? (Choose two.)
SQL > @utlrp.sql
Which two actions does the script perform? (Choose two.)
1z0-062 Exam Question 149
Your database is in ARCHIVELOG mode.
You want to disable archiving for the database.
Examine these steps:
1. Execute the ALTER DATABASE NOARCHIVELOG command
2. Execute SHUTDOWN IMMEDIATE
3. Execute STARTUP MOUNT
4. Set the DB_RECOVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/
5. Execute STARTUP NOMOUNT
6. Open the database
7. Execute SHUTDOWN TRANSACTIONAL
Identify the required steps in the correct sequence.
You want to disable archiving for the database.
Examine these steps:
1. Execute the ALTER DATABASE NOARCHIVELOG command
2. Execute SHUTDOWN IMMEDIATE
3. Execute STARTUP MOUNT
4. Set the DB_RECOVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/
5. Execute STARTUP NOMOUNT
6. Open the database
7. Execute SHUTDOWN TRANSACTIONAL
Identify the required steps in the correct sequence.
1z0-062 Exam Question 150
Which three statements are true about the purpose of checkpoints? (Choose three.)