1z0-063 Exam Question 96
You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database:
CONNECT /AS SYSDBA
ALTER SYSTEM SET THREADED_EXECUTION=TRUE SCOPE=SPFILE;
SHUTDOWN IMMEDIATE
You then restart the instance and get an error:
STARTUP
ORA-01031: insufficient privileges
Why does the startup command return the error shown?
CONNECT /AS SYSDBA
ALTER SYSTEM SET THREADED_EXECUTION=TRUE SCOPE=SPFILE;
SHUTDOWN IMMEDIATE
You then restart the instance and get an error:
STARTUP
ORA-01031: insufficient privileges
Why does the startup command return the error shown?
1z0-063 Exam Question 97
The environmental variable oracle_Base is set to /u01/app/oracleand oracle_home is set to /u01/app/oracle/product/12.1.0/db 1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.
NAMETYPEVALUE
audit_file_deststring/u01/app/oracle/admin/eml2rep/adump
background_dump_deststring
core_dump_deststring
db_create_file_deststring
db_recovery_file_deststring/u01/app/oracle/fast_recovery_area
diagnostic_deststring
What is the location of the ADR base?
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.
NAMETYPEVALUE
audit_file_deststring/u01/app/oracle/admin/eml2rep/adump
background_dump_deststring
core_dump_deststring
db_create_file_deststring
db_recovery_file_deststring/u01/app/oracle/fast_recovery_area
diagnostic_deststring
What is the location of the ADR base?
1z0-063 Exam Question 98
Yourdatabase is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set D3ID of the target database in RMAN.
2.Start the database instance by using the startup force nomount command in RMAN.
3.Restore the control files from the backup.
4.Mount the database.
5.Restore theSPFILE from the autobackup.
6.Create a PFILE from the recovered SPFILE.
7.Restart the instance in nomount state.
Identify the required steps in the correct order.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set D3ID of the target database in RMAN.
2.Start the database instance by using the startup force nomount command in RMAN.
3.Restore the control files from the backup.
4.Mount the database.
5.Restore theSPFILE from the autobackup.
6.Create a PFILE from the recovered SPFILE.
7.Restart the instance in nomount state.
Identify the required steps in the correct order.
1z0-063 Exam Question 99
In which three scenarios is media recovery required? (Choose three.)
1z0-063 Exam Question 100
Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)