QUESTION 45
Choose the best answer. SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL statements?

QUESTION 46
Which three are true about requirements for various FLASHBACK operations? (Choose three.)

QUESTION 47
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

QUESTION 48
Which two are true about flashback features in Oracle Database 19c and later releases?

QUESTION 49
Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1was created.
You want to recover PDB1 to Restore Point R1.
How do you achieve this?

QUESTION 50
A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLEDdatabase property is set to FALSEin the CDB.
Data file 24 of PDB2was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASEcommand while connected to CDB$ROOT.
Which three are true? (Choose three.)

QUESTION 51
Which three methods can be used for heap table data migration after upgrading a database?

QUESTION 52
Which three are true? (Choose three.)

QUESTION 53
choose three Which three RMAN persistent settings can be set explicitly?

QUESTION 54
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

QUESTION 55
Which two are true about instance recovery?

QUESTION 56
A user complains about poor database performance.
You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

QUESTION 57
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

QUESTION 58
You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?

QUESTION 59
Choose three. Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?

QUESTION 60
Choose two. In which two situations can you use Database Upgrade Assistant?

QUESTION 61
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_time); Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

QUESTION 62
Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

QUESTION 63
Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1.
How do you achieve this?

QUESTION 64
Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully: Which two are true? (Choose two.)

QUESTION 65
Choose two. Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup?

QUESTION 66
A database is configured in archivelog mode.
A full RMAN backup exists but no control file backup to trace has been taken.
A media failure has occurred.
In which two scenarios is incomplete recovery required?

QUESTION 67
Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c? (Choose two.)

QUESTION 68
Choose two. Which two are true about backup set compression using RMAN default compression?