Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
Choose two. Which two statements are true when row-archival management is enabled?
You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance?
Which three are true about an application seed pluggable database (PDB)? (Choose three.)
Examine these actions: 1. Create a new database for a recovery catalog. 2. Create a tablespace with sufficient space in the catalog database for the recovery catalog. 3. Configure ARCHIVE LOG mode for the catalog database. 4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog. 5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner. 6. Grant the SYSBACKUP privilege to the recovery catalog schema owner. Which are the minimum actions that must be performed before executing the CREATE CATALOG command?
Choose three. Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
hoose two. Which two are true about Recovery Manager (RMAN) diagnostic message output?
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 container database called CDB1 is OMF-enabled. PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1: CREATE PLUGGABLE DATABASE pdb1 USING ‘/u01/app/oracle/oradata/pdb1.xml’ SOURCE_FILE_NAME_CONVERT = (‘/u01/app/oracle/oradata/’, ‘/u02/app/oracle/oradata/’);
Which two are true? (Choose two.)
Choose two. Which two are true about Oracle Grid Infrastructure for a Standalone Server?
Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?
Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
A database is configured in ARCHIVE LOG 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? (Choose two.)
Choose three. The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3. Which three are true?
choose two You take your database backups by using the RMAN media management interface (MMI). Which two are true about the use of the RMAN MMI?
Examine the RMAN command: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3); SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; } Which statement is true about the command?
You have configured RMAN SBT channels to write backups to media. You then take an RMAN backup by using this command: Which three are true? (Choose three.)
Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5; Which two statements are true about the DUPLICATE command?
Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)
Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)
Choose the best answer. Examine this configuration:
1. CDB1 is a container database.
2. There are several pluggable databases (PDBs) in CDB1.
5. Each PDB has several tables with referential integrity constraints.
6. FLASHBACK DATABASE is ON.
7. UNDO RETENTION GUARANTEE is enabled.
Multiple undesired multitable changes were made in all the PDBs.
Which method can be used to undo the changes using a single command?
Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)
Examine this configuration: While CDB1 is open, ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/ controlfile02.ctl’is accidentally deleted. To recover from this critical failure, you execute these commands:
What will be the outcome?
Choose two. Which two are true about RMAN Multisection backups when a very large data file is divided into four sections?
HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1, must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE ------------0 SQL> exec DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES(-1); SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE -------------1 After changing the value, you notice that FULL redaction continues to redact numeric data with zero.What must you do to activate the new default value for numeric full redaction?
choose three Which three are true about RMAN duplexed backup sets or image copies?
Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?
Choose two. Which two are true about the execution of operating system scripts starting from Oracle Database 19c?