2 EB - 61-90

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?. The SPFILE is copied along with the datafiles of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also duplicated. A backup of pdb1 and pdb5 must exist before executing the command. The root and the seed database in the container database (CDB) are also duplicated. A backup of CDB and pdb1 and pdb5 must exist before executing the command. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

Which three are true about a container database (CDB)? (Choose three). A PDB snapshot can be a sparse copy of a source PDB. A PDB snapshot depends on an existing storage snapshot of the source PDB. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication. A PDB snapshot can be a full copy of a source PDB. A snapshot copy PDB can be a full copy of a source PDB. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

In one of your databases, unified auditing is enabled and an SH.SALES table exists. You successfully execute these commands: SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales; SQL> AUDIT POLICY sales_pol; Which statement is true about SALES_POL?. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN and OE_ADMIN roles. It fails because system privileges cannot be granted with roles in the same audit policy. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them. It fails because the command does not specify when the unified audit policy should be enforced.

Which three are true about RMAN duplexed backup sets or image copies? (Choose three). A backup set may be duplexed with both copies written to disk. An image copy on disk can be copied to disk. A backup set may be duplexed with both copies written to sbt. A backup set may be duplexed so that one copy is written to sbt and the other to disk. An image copy on disk can be copied to sbt. An image copy on sbt can be copied to disk.

Which three are true about Oracle pluggable databases (PDBs)? (Choose three). A PDB can be plugged into a CDB only if both are of the same Oracle Database release. An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files. A PDB unplugged from a container database (CDB) can be plugged into a different CDB without altering any of its schemas. A non-CDB can be converted into a PDB. A PDB in a remote CDB can be accessed transparently by aggregating results from local and remote PDBs. A PDB created from PDB$SEED must be set to READ WRITE after loading data. A PDB created from PDB$SEED must be set to READ ONLY after loading data.

Which two statements are true about RMAN duplexed backups?. It is not supported for image copies. It is only supported for backups to tape via the media management interface. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously. Duplex backups can contain only data files and control files. For performing duplexed backups, the parallelism for the device must be set equal to the number copies.

Which three are true about unified auditing in full mode? (Choose three). The unified audit trail is written to a read-only table. The unified audit trail is written to a read-only external file. Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements. Audit records are created for SYS. Audit records are created for non-sys users.

Examine the RMAN command: 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?. The RMAN multiplexing level is 4. It is the use of asynchronous I/O by RMAN. It is a case of parallelization of the backup set. It is an implementation of a multisection backup.

Examine this configuration: 1. CDB1 is a container database. 2. DEFAULT_SHARING is METADATA. 3. APP_ROOT is an application root contained in CDB1. 4. APP_PDB1 is an application PDB contained in APP_ROOT. 5. COMPANYAPP is an application contained in APP_ROOT. 6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed. You execute these commands: SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA; SQL> ALTER SESSION SET CONTAINER=app_root; SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE '1.0' TO '2.0'; SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL); SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO '2.0'; SQL> ALTER SESSION SET CONTAINER=app_pdb1; SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC; What will be the outcome and why?. SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows. SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows. It will return an error because the SYNC operation is not allowed when constraints are added to common objects. It will return an error because EMP is not empty in APP_ROOT. It will return an error because EMP.SAL is empty in APP_ROOT.

Identify three benefits of Unified Auditing. Decreased use of storage to store audit trail rows in the database. It improves overall auditing performance. It guarantees zero-loss auditing. The audit trail cannot be easily modified because it is read-only. It automatically audits Recovery Manager (RMAN) events.

Which three are true about Recovery Manager (RMAN) active database duplication? (Choose three). Pre-existing backups of the database to be duplicated are required for the "push" method of duplication. Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication. Pre-existing backups of the database to be duplicated are always used if they exist. Image copies can be used to duplicate the active database. The active database must be duplicated while in OPEN state. No connection to the recovery catalog is required for active database duplication. Backup sets can be used to duplicate the active database.

You want to duplicate one of your databases when connected to the target database and to the recovery catalog. Which three are true about this type of database duplication? (Choose three). The target database must be open. The duplication process can use existing backup sets or image copies. The duplication process can use existing backup sets or image copies. The target database must be in mount state. The duplication process pushes backup sets to the auxiliary instance. The duplication process pushes image copies to the auxiliary instance.

Which three are true about cloning databases into an existing CDB with RMAN? (Choose three). A non-CDB can be cloned into a PDB. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB. Only one PDB can be cloned at a time. Two or more PDBs can be cloned with the same command. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB. The target and auxiliary instance passwords must be the same.

A redaction policy was added to the SAL column of the SCOTT.EMP table. All users have their default set of system privileges. For which three situations will data not be redacted? (Choose three.). SYS sessions, regardless of the roles that are set in the session. SYSTEM sessions, regardless of the roles that are set in the session. SCOTT sessions, only if the MGR role is set in the session. SCOTT sessions, only if the MGR role is granted to SCOTT. SCOTT sessions, because he is the owner of the table. SYSTEM session, only if the MGR role is set in the session.

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?. Database Replay. Automatic Database Diagnostic Monitor (ADDM) Compare Period report. Active Session History (ASH) report. SQL Performance Analyzer.

You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB. User-defined objects are stored in several tablespaces in the non-CDB. Which three methods can you use? (Choose three). Data Pump full database export and import. cloning the non-CDB as a PDB. replication using GoldenGate. Data Pump transportable tablespaces. Data Pump full transportable database. the DBMS_PDB package.

Which three actions are mandatory post database upgrade? (Choose three). Updating client scripts with the new Oracle home. Resetting passwords to enforce case-sensitivity. Run OPatch commands from the new Oracle home. Setting threshold values for tablespace alerts. Migration to unified auditing. Upgrading user tables that depend on Oracle-maintained abstract data types.

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?. Enable Memory Access Mode, which reads performance data from SGA. Use emergency monitoring to fetch data directly from SGA for analysis. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots. Use Active Session History (ASH) data and hang analysis in regular performance monitoring. Run ADDM in diagnostic mode.

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type. 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?. Re-enable redaction policies that use FULL data redaction. Re-create redaction policies that use FULL data redaction. Re-connect the sessions that access objects with redaction policies defined on them. Flush the shared pool. Restart the database instance.

Which three are true about backing up the control file? (Choose three). It cannot be backed up manually as a binary copy. It gets backed up automatically by RMAN as a trace file containing SQL statements for control file recreation when a database backup occurs. It can be backed up manually as a binary copy. It can get backed up automatically as a binary copy. It gets backed up automatically by RMAN when the BACKUP SPFILE command is used. It can be backed up manually as a trace file containing SQL statements for control file recreation.

RMAN is connected to the target database prod1 and an auxiliary instance in nonmount state. Examine the command: RMAN> DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE NOFILENAMECHECK PASSWORD FILE SPFILE; Which two statements are true about the execution of the duplicate command?. All archive redo log files are automatically copied to the duplicate database. The duplicate database has the same directory structure as the source database. The duplicate database is created by using the backups created during the execution of the duplicate command. The password file and SPFILE for the duplicate database dup1 are created in their respective default locations. The duplicate database is created without using RMAN backups and prod is allowed to remain open during duplication.

Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)? (Choose two). A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified. A PDB Lockdown profile can be created in an application root. A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified. A PDB Lockdown profile can be created in a regular PDB. A PDB Lockdown profile can be created in CDB$ROOT.

Which three are true about corrupted data blocks and their recovery in an Oracle Database? (Choose three). If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt. DB_BLOCK_CHECKING = TRUE causes a checksum to be added to each data block to help detect physical or media corruption. A media corrupt block is one where the block is not formatted correctly. The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it. If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt. DB_LOST_WRITE_PROTECT = TYPICAL causes extra logging overhead on the standby database.

Which three statements are true about the keystore storage framework for transparent data encryption?. It facilitates and helps to enforce keystore backup requirements. It handles encrypted data without modifying applications. It enables a keystore to be stored only in a file on a file system. It enables separation of duties between the database administrator and the security administrator. It transparently decrypts data for the database users and applications that access this data. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

Which two statements are true when row archival management is enabled?. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to indicate that a row is no longer considered active.

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?. Reduced logical I/O. Reduced virtual memory utilization. Improved Serial Execution performance. Reduced physical I/O. Reduced CPU utilization.

Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup? (Choose two). Backups can be taken only if a fast recovery area is configured. Backups can be written only to disk. Backups can be taken only for data files. Binary compression cannot be applied to the backup. Backups can be written only if checksums are stored for each block. Backups can be written only to media.

Which two statements are true about encrypted backups performed by using RMAN? (Choose two). Transparent encryption of backups uses an encryption wallet. Image copy backups can be created by using password encryption. Password encryption of backups uses the password while creating and restoring backups. Encrypted backups can only be written to disk. A database uses the same encryption key for every encrypted backup.

Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant? (Choose three). Any Recovery Manager (RMAN) recovery catalog must be upgraded manually. After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME. Time zone files must be upgraded manually using the DBMS_DST PL/SQL package. The new extended data type capability must be enabled by running the utlrp.sql script. The Oracle Application Express configuration should be updated after upgrading Oracle Database.

Which four are true about performance-related Oracle tools? (Choose four). The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two consecutive periods. SQL Performance Analyzer can suggest schema changes. SQL Performance Analyzer can identify regressed SQL statements. Database Replay always uses one replay client for all the original database sessions. Database Replay always uses one replay client for each original database session. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two non-consecutive periods. The Active Session History (ASH) report is based on wait event samples.