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

Question 21

Which two are prerequisites for creating a backup-based duplicate database? (Choose two.)

A.connecting to the target database and a recovery catalog to execute the duplicate command

B.creating a password file for an auxiliary instance

C.connecting to an auxiliary instance

D.matching the database identifier (DBID) of the source database and the duplicate database

E.creating an SPFILE for the target database

Question 22

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded.
Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?

A.by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis

B.by running ADDM in diagnostic mode

C.by using Active Session History (ASH) data and performing hang analysis

D.by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots

Question 23

You are administering a database that supports data warehousing workload and is running in NOARCHIVELOG mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
You want to recover the data file.
Examine the steps involved in the recovery process:
1. Shut down the database instance.
2. Start up the database instance in NOMOUNT state.
3. Mount the database.
4. Take the data file offline.
5. Put the data file online.
6. Restore the control file.
7. Restore the database.
8. Restore the data file.
9. Open the database with the RESETLOGS option.
10. Recover the database with the NOREDO option.
11. Recover the data file with the NOREDO option.
Identify the required steps in the correct order.

A.1, 2, 6, 3, 7, 10, 9

B.4, 8, 11, 5

C.1, 2, 6, 3, 8, 11, 9

D.1, 3, 8, 11, 9

E.1, 3, 7, 10, 9

Question 24

Which two statements are true about tablespaces in multitenant container databases (CDBs)? (Choose two.)

A.Each PDB can have its own default temporary tablespace.

B.The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.

C.The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.

D.The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.

E.Default permanent tablespaces can be shared across pluggable databases (PDBs).

Question 25

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup? (Choose two.)

A.Tables or table partitions can be recovered only when the database is in MOUNT state.

B.Tables with NOT NULL constraints cannot be recovered.

C.Tables or table partitions can be recovered by using an auxiliary instance only.

D.Tables or table partitions with a foreign key cannot be recovered.

E.Tables or table partitions from the SYSTEM and SYSAUX tablespaces cannot be recovered.

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

Latest Upload: 107Oracle.1Z0-1057-23.v2025-09-10.q47; 146Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 155TheSecOpsGroup.CNSP.v2025-09-08.q20; 204CFAInstitute.ESG-Investing.v2025-09-08.q173; 152PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 140Salesforce.Data-Architect.v2025-09-05.q216; 136Adobe.AD0-E605.v2025-09-05.q50; 176Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 21

Question 22

Question 23

Question 24

Question 25

Download PDF File