Free Access Oracle.1z0-063.v2022-04-21.q171 Practice Test (Page 18)

Question 81

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.
Examine the command:
RMAN> LIST FAILURE;
Which statement is true about this command?

A.It lists failures only for the CDB root database.

B.It lists failures for a PDB only when RMAN is connected to a recovery catalog.

C.It lists failures for the CDB and all the PDBs in this CDB.

D.It lists failures only if RMAN is connected to a PDB.

Question 82

In CDB$ROOTof your multitenant container database (CDB), you create a common user, C##A_ADMIN,and then execute the command:

Which statement is true?

A.The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.

B.The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root database, as well as in the pluggable databases (PDBs).

C.The command fails because system privileges cannot be granted to a common user.

D.The command fails because the CONTAINERclause is not used.

Question 83

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?

A.because the threaded architecture requires authentication using a password file before issuing a startup command

B.because the threaded architecture requires issuing a new connect / as sysdba from within sql*plus before issuing a startup command

C.because the threaded architecture requires exiting from sql*plus and reconnecting with sql*Plus / as sysdba before issuing a startup command

D.because the threaded architecture requires restarting the listener before issuing a startup command

E.because the threaded architecture requires connecting to the instance via a listener before issuing a startup command

Question 84

As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?

A.Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.

B.Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.

C.Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.

D.Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.

Question 85

Which three RMAN persistent settings can be set for a database?

A.backup retention policy

B.default backup device type

C.default section size for backups

D.default destinations for backups

E.multiple backup device types for a single backup

Other Version: 2156Oracle.1z0-063.v2022-10-18.q151

Latest Upload: 101OCEG.GRCP.v2025-09-11.q211; 101HP.HPE0-V27.v2025-09-11.q78; 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 222CFAInstitute.ESG-Investing.v2025-09-08.q173; 156PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 146Salesforce.Data-Architect.v2025-09-05.q216; 140Adobe.AD0-E605.v2025-09-05.q50

Question 81

Question 82

Question 83

Question 84

Question 85

Download PDF File