2 EB - 91-124

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.

Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three). to report on the database schema at an earlier point in time. to store backups that would cause the controlfile to become too large. to allow database duplication without a connection to the target instance. to allow database duplication without a connection to the auxiliary instance. to store backup metadata that would cause the controlfile to become too large.

A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2. You want to relocate PDB1 from CDB1 to CDB2 with near-zero downtime. Which three are required?. CDB2 must be in shared UNDO mode only. CDB2 must be in archivelog mode. CDB1 must be in archivelog mode. CDB1 and CDB2 must both be in local UNDO mode. CDB1 must be in shared UNDO mode only. CDB1 and CDB2 must be in shared UNDO mode.

Which two are prerequisites for creating a backup-based duplicate database?. connecting to the target database and a recovery catalog to execute the duplicate command. creating a password file for an auxiliary instance. connecting to an auxiliary instance. matching the database identifier (DBID) of the source database and the duplicate database. creating an SPFILE for the target database.

Examine this configuration: 1. CDB1 is a container database. 2. There are several pluggable databases (PDBs) in CDB1. 3. Each PDB has several tables with referential integrity constraints. 4. FLASHBACK DATABASE is ON. 5. 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?. restore and recover database. flashback transaction. flashback database. flashback table and transaction. flashback table.

Examine this configuration: 1. CDB1 is an Oracle container database from an older release. 2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1. A priority list UpgrdList has these entries: 1, pdb2 2, pdb1, pdb3. You execute this command: /u01/app/oracle/product/18.1.0/db_1/rdbms/admin/dbupgrade -L UpgrdList. In which order will the upgrade occur?. CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4. CDB$ROOT, PDB2, PDB1, and PDB3. CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3. CDB$ROOT, PDB1, PDB2, PDB3, and PDB4. CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4.

Which two are prerequisites for performing Flashback Transaction?. Flashback Database must be enabled. Undo retention guarantee for the database must be configured. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction. Supplemental logging must be enabled. Recycle bin must be enabled for the database. Block change tracking must be enabled for the database.

You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute: SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENTION 2 YEAR; What is the outcome?. All historical data older than two years, if any, is purged from the flashback archive FDA1. An error is returned because the retention period cannot be reduced. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.

Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN? (Choose three). The control file is backed up whenever a new tablespace is created. The server parameter file (SPFILE) is automatically backed up each time the control file is backed up. The control file is backed up whenever a new table is created. The control file is backed up whenever an RMAN backup is successfully recorded in the catalog. It requires the use of fast recovery area (FRA). The control file is backed up automatically each time the SPFILE is backed up manually.

Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned. creating a new empty PDB in the local database from PDB$SEED. creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database. automatically dropping the database link to the remote database if it already exists. creating a database link from CDB$ROOT in the remote database to the PDB in the local database. opening the cloned PDB.

Which three RMAN persistent settings can be set for a database?. backup retention policy. default backup device type. default section size for backups. default destinations for backups. multiple backup device types for a single backup.

Which three statements are true about Flashback Database?. Flashback logs are written sequentially, and are archived. Flashback Database uses a restored control file to recover a database. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area. Flashback Database can recover a database to the state that it was in before a reset logs operation. Flashback Database can recover a data file that was dropped during the span of time of the flashback. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

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?. Create SQL plan directives for each of the regressed statements. Use the SQL Tuning Advisor for each of the regressed statements. Create an adaptive execution plan for each of the regressed statements. Use the SQL Access Advisor for each of the regressed statements.

Which three statements are true about Flashback Data Archive?. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.

You plan to create a database by using DBCA with specifications: high concurrent user connections, mixed workload, complex BI queries at night. Which DBCA option must you choose to create the database?. a General Purpose database template with default memory allocation. a Data Warehouse database template, with dedicated server mode and AMM enabled. a General Purpose database template, with shared server mode and Automatic Memory Management (AMM) enabled. a default database configuration.

In which two situations can you use threshold server-generated alerts to help diagnose and fix problems? (Choose two). when free space in a locally managed tablespace falls below a specified percentage. when the number of logons per second exceeds a specific value. when a database instance has been running for a period greater than a threshold value. when the total number of locked user accounts exceeds a specific value. when a database instance has been running for a period greater than a threshold value.

Examine the RMAN command: CONFIGURE ENCRYPTION FOR DATABASE ON; BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?. The password for the encryption must be set up. Oracle wallet for the encryption must be set up. All the tablespaces in the database must be encrypted. Oracle Database Vault must be enabled.

Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose three.). All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database. The SPFILE is included in the archival backup. They are never considered obsolete by RMAN. Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored. The ARCHIVAL attribute for a backup overrides the RMAN retention policy. They can optionally be written to a fast recovery area (FRA). Use of a recovery catalog is always required to support the creation and use of archival backups.

Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES=(CONNECT) CREATE_FILE_DEST=/u01/app/oracle/oradata/cdb1/pdb1; Which three are true about PDB1? (Choose three.). Service PDB1 is created for remote logins to PDB1. It is in mount state after creation. It has no local users. It has the same number of roles as CDB1. It has the same common users defined as does CDB1. It has only local roles.

CDB1 and CDB2 are two container databases. PDB1 is a pluggable database in CDB1. PDB1_C1_SRV is a service for PDB1. CDB1_LINK is a database link in CDB2 referring to PDB1. CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service. You execute: SQL> CREATE PLUGGABLE DATABASE PDB1 FROM PDB1@CDB1_LINK SERVICE_NAME_CONVERT = ('PDB1_C1_SRV','PDB1_C2_SRV'); Which two are true? (Choose two.). PDB1 will be created in CDB2 and automatically opened. PDB1 will be created in CDB2 and left in MOUNT state. PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV. PDB1_C2_SRV will be created and started automatically. PDB1_C2_SRV will be created but not started.

Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT. You execute: SQL> CREATE ROLE role1 CONTAINER = CURRENT; What is true?. It will return an error because creation of a local role is not allowed in CDB$ROOT. ROLE1 will be created only in CDB$ROOT and APP1_ROOT. ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1. ROLE1 will be created only in CDB$ROOT. It will return an error because common roles must start with C##.

Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?. It is a set of recommendations by the optimizer to create new indexes. It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans. It is auxiliary information collected by the optimizer for a SQL statement to help use better join orders. It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error. It is a set of recommendations by the optimizer to change the access methods used.

Which three are true about the FLASHBACK DATABASE feature? (Choose three.). FLASHBACK LOGS are archived after a log switch. A database can be flashed back using SQL*PLUS. Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database. FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time. It always generates REDO and UNDO. It requires that the target database be in ARCHIVELOG mode.

Which three are true about patches? (Choose three.). They can be applied in a rolling fashion for Clusterware and the databases. They can introduce new features. They are installed via OPatch or OPatchAuto. Installing a patchset is considered an "upgrade". They are only released quarterly. A base release is not needed to install patches.

Which two are true about backup set compression using RMAN default compression? (Choose two.). Compressed backups can be written only to media. Binary compression adds CPU overhead to backup operations. Unused blocks below the high water mark are backed up. Compressed backups cannot have a section size defined. Compression can be done only for locally managed tablespaces.

Which two are true about memory advisors? (Choose two.). If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available. If Automatic Memory Management is enabled, no memory advisors are available. All memory advisors use data from Automatic Workload Repository. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available. If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.

PDB1 and PDB2 are pluggable databases in CDB1. You execute: ALTER PLUGGABLE DATABASE pdb1 OPEN; ALTER PLUGGABLE DATABASE pdb1 SAVE STATE; ALTER PLUGGABLE DATABASE PDB1 CLOSE; ALTER PLUGGABLE DATABASE pdb2 OPEN; CDB1 is then restarted. Which three are true? (Choose three.). PDB2 will be MOUNTED. PDB1 will be MOUNTED. PDB$SEED will be opened READ ONLY. PDB2 will be opened READ WRITE. PDB1 will be opened READ WRITE. PDB$SEED will be MOUNTED.

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.). ADDM can run in a nonroot container. AWR snapshots can be created in CDB$ROOT. AWR reports can be generated while connected to any container. All AWR data is stored in the CDB$ROOT SYSAUX tablespace. AWR snapshots can be created in a PDB. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Which two are true about Optimizer Statistics? (Choose two.). They can be gathered by the DBMS_STATS package. They are gathered by the SQL Tuning Advisor. They provide real-time data about schema objects. They are ignored by Optimizer if they are stale. By default, they are automatically gathered by a maintenance job.

Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)? (Choose three.). the data dictionary in CDB$ROOT. temporary tablespaces. the Process Monitor Process (PMON). SYSAUX tablespaces. the log writer process (LGWR). undo tablespaces.

Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c? (Choose three.). creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned. creating a new empty PDB in the local database from PDB$SEED. creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database. automatically dropping the database link to the remote database if it already exists. creating a database link from CDB$ROOT in the remote database to the PDB in the local database. opening the cloned PDB.

A schema owner truncated a table in error and must recover the data. Which Oracle Flashback feature could be used to recover the data?. FLASHBACK TRANSACTION. FLASHBACK VERSION QUERY. FLASHBACK DATA ARCHIVE. FLASHBACK TABLE. FLASHBACK DATABASE.

Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Choose three.). The Pre-Upgrade Information Tool script is executed by DBUA. DBUA must be launched from the target Oracle Home. All pluggable databases are automatically upgraded as part of a container database upgrade. A whole database backup must exist before upgrade. The database must be opened in read-only mode. Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.

Which three are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c? (Choose three.). It is an Oracle Database service. It can be used to deploy Oracle Database homes. It cannot be used to provision applications. It can be used to deploy Grid Infrastructure homes, including Oracle Restart. It cannot be used to provision middleware. It is an Oracle Grid Infrastructure service.