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

Question 161

You need to perform a block media recovery on the tools01.dbfdata file in your database by using
Recovery Manager (RMAN).
Which two are prerequisites for performing this operation? (Choose two.)

A.You must configure a block change tracking file.

B.You must use an incremental level-1 backup to restore blocks.

C.You must ensure that the database is mounted or open.

D.You must have full or level-0 backups to restore blocks.

E.You must take the tools01.dbfdata file offline.

Question 162

Examine the command to duplicate a database:
RMAN> DUPLICATE TARGET DATABASE TO cdb
PLUGGABLE DATABASE pdb1, pdb5;
Which two statements are true about the DUPLICATEcommand? (Choose two.)

A.The root and the seed database in the container database (CDB) are also duplicated.

B.An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

C.The SPFILE is copied along with the data files of the pluggable databases (PDBs).

D.A backup of pdb1and pdb5must exist before executing the command.

E.The DUPLICATEcommand first creates a backup, and then duplicates the PDBs by using the backup.

Question 163

Users report this error message when inserting rows into the orders table:
ERROR at line1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES
You determine that the indexes tablespace is out of space and there is no free space on the filesystem
used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries? (Choose two.)

A.coalesce the order.ind index

B.drop and re-create the index

C.rebuild the index online moving it to another tablespace that has enough free space for the index

D.coalesce the indexes tablespace

E.perform an on line table rebuild using dbms_redefinition

Question 164

Which three statements are true about Oracle Secure Backup (OSB)?

A.It can be used to perform file system backups at the file, directory, file system, or raw partition level.

B.It can be used to manage tape backup and restore operations for multiple databases.

C.It can encrypt client data written to tape.

D.It can be used to take image copy backups to tape.

E.It can be used along with an RMAN recovery catalog for maintaining records of backups
in a tape library.

Question 165

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?

A.by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host

B.by using the RMAN switch command to set the new location for the data files

C.by creating a new database in the new host, and then using the RMAN recover command

D.by using the RMAN duplicate command with dbid and set nekname for tablespace to recover the database to the new host

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

Latest Upload: 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; 156TheSecOpsGroup.CNSP.v2025-09-08.q20; 208CFAInstitute.ESG-Investing.v2025-09-08.q173; 155PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 145Salesforce.Data-Architect.v2025-09-05.q216; 139Adobe.AD0-E605.v2025-09-05.q50; 182Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 161

Question 162

Question 163

Question 164

Question 165

Download PDF File