2 EB - 1-30

Which are the three steps in the SQL tuning process for Oracle Database environments? (Choose three). Tune individual SQL statements using the SQL Tuning Advisor. Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor. Test the application as a whole using tuned SQL statements. Test tuned SQL statements one at a time for all statements in the application. Identify poorly tuned SQL statements using the SQL Tuning Advisor. Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.

Which three statements are true about Automatic Workload Repository (AWR)?. All AWR tables belong to the SYSTEM schema. The AWR data is stored in memory and in the database. The snapshots collected by AWR are used by the self-tuning components in the database. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views. AWR contains system wide tracing and logging information.

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB. In a PDB plan, subplans may be used with up to eight consumer groups. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Some archived log backups have been accidentally deleted from storage. Which two commands should be used to update the status of backups in the recovery catalog to display only the missing backups? (Choose two). RESYNC CATALOG. CROSSCHECK BACKUP OF ARCHIVELOG ALL. LIST ARCHIVELOG ALL. LIST EXPIRED. LIST ARCHIVELOG. REPORT OBSOLETE.

The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;. BACKUP SPFILE SECTION SIZE 1M;. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;.

Which three are true about Transparent Data Encryption (TDE)? (Choose three). It uses a single master key for a database. It replaces secure application roles. It encrypts only data on the client. It stores the current and all past master keys in the keystore. Master encryption keys are managed by Oracle Database Vault. It can encrypt data at the column level.

Which two are true about PDB archive files? (Choose two). DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive. They contain a PDB manifest file and all the data files in uncompressed form for a PDB. They contain all the data files only in uncompressed form for a PDB. They must be created using the DBMS_PDB package. They contain a PDB manifest file and all the data files in compressed form for a PDB. They contain all the data files only in compressed form for a PDB.

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?. It will create a multitenant container database (CDB) with only the root opened. It will create a CDB with root opened and seed read only. It will create a CDB with root and seed opened and one PDB mounted. It will create a CDB that must be plugged into an existing CDB. It will create a CDB with root opened and seed mounted.

Which three are true about Data Pump in an Oracle multitenant environment? (Choose three). It can be used to transport data from a non-CDB to a PDB. It can be used to clone a CDB. It can be used to transport data between PDBs. It can be used to transport data from a PDB to a non-CDB. It can be used to create a new PDB.

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? (Choose two). 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 SPFILE is copied along with the data files of the pluggable databases (PDBs). An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE. The DUPLICATE command first creates a backup, and then duplicates the PDBs by using the backup.

You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command: RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE; What is a prerequisite for the successful execution of this command?. RMAN must be connected to the target database instance and the auxiliary instance. A most recent backup set of the PROD database must exist. Flashback must be enabled for the PROD database. The target database must be in MOUNT state.

In which three situations can you use threshold server-generated alerts to help diagnose and fix problems? (Choose three). when free space in a dictionary managed tablespace falls below a specified percentage. when free space in a locally managed tablespace falls below a specified percentage. when the total number of locked user accounts exceeds a specific value. when the number of logons per second exceeds a specific value. when a resumable statement is suspended. when the total number of logons exceeds a specific value.

Examine this command: rhpctl move database -sourcehome Oracle_home_path -destinationhome Oracle_home_path. For which two purposes can you use this command? (Choose two). to switch to a patched Oracle Database home. to upgrade an Oracle Database on the centralized Rapid Home Provisioning server. to move an Oracle Database to the centralized Rapid Home Provisioning server. to switch back to the previous Oracle home as part of a rollback operation. to switch to a read-only Oracle home.

Examine these RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which statement is true about the DUPLICATE command?. It succeeds. It fails because no parallel channels are allocated for the auxiliary database. It fails because connection to the AUXILIARY instance must be as SYSDBA. It succeeds only if the target database is greater than 400M. No catalogued backup of the TARGET is used to duplicate the database.

You are administering a multitenant container database (CDB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. The statistics_level parameter is PDB modifiable. As the user sys, execute the following command on pdb2: SQL> ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = '*' SCOPE = SPFILE; Which statement is true about the result of this command?. The statistics_level parameter is set to all when any of the PDBs is reopened. The statistics_level parameter is set to all only for PDB2 when it is reopened. The statistics_level parameter is set to all when the root database is restarted. The statement is ignored because there is no SPFILE for a PDB.

Which two are true about various Oracle security and auditing capabilities? (Choose two). Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed. Application-common TSDP policies are always container specific. Application-common OLS policies can be created only if all the PDBs in the application container are closed. Unified auditing can be automatically synchronized to all application PDBs in an application container. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.

Which two are true about creating pluggable databases (PDBs) in Oracle 19c and later releases?. A PDB snapshot depends on an existing storage snapshot of the source PDB. A PDB snapshot can be a full copy of a source PDB. A PDB snapshot can be a sparse copy of a source PDB. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems. A snapshot copy PDB can be created from a stand-alone clone PDB.

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?. Tables or table partitions can be recovered by using an auxiliary instance only. Tables or table partitions with a foreign key cannot be recovered. Tables or table partitions can be recovered only when the database is in mount state. Tables or table partitions from the system and sysaux tablespaces cannot be recovered. Tables with not null constraints cannot be recovered.

For which two tasks can you use the DBMS_PDB.DESCRIBE procedure? (Choose two). to generate an XML metadata file that describes a non-CDB Oracle 12c database so that it can be plugged in as a PDB. to generate an XML metadata file from any unplugged PDB. to determine whether an XML file describes a PDB that can be plugged into the CDB in which you run the procedure. to generate a .pdb archive file for any PDB in the current CDB. to generate an XML metadata file that describes the current plugged-in PDB.

Examine the RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which statement is true about the DUPLICATE command?. It succeeds and creates multisection backup sets that are used for active database duplication. It fails because there is no connection to a recovery catalog. It succeeds only if the target database is in MOUNT state. It fails because no parallel channels are allocated for the auxiliary database.

Which two are benefits of unified auditing in full mode? (Choose two). All audit data is written to both the traditional locations and to the unified location. The audit trail is in a single format. Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the unified location. The audit trail is read-only. The audit trail uses less space.

Examine this configuration: 1. CDB1 is a container database. 2. APP1_ROOT is an application container contained in CDB1. 3. APP1_ROOT$SEED is the application seed contained in APP1_ROOT and synchronized with APP1_ROOT. 4. APP1_PDB1 and APP1_PDB2 are application PDBs contained in APP1_ROOT. 5. APP1_USER_APP is an application installed in APP1_ROOT at version 1.0. 6. USER1 is a common user in APP1_ROOT and all its application PDBs, created when version 1.0 of APP1_USER_APP was installed. You execute these commands: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> ALTER SESSION SET CONTAINER = app1_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user_app BEGIN UPGRADE '1.0' TO '2.0'; Pluggable database altered. SQL> GRANT CREATE SESSION TO USER1; Grant succeeded. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user_app END UPGRADE TO '2.0'; Pluggable database altered SQL> ALTER SESSION SET CONTAINER=app1_pdb1; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user_app SYNC; Which two are true? (Choose two). APP1_USER1 can be created in PDB1. USER1 can connect to APP1_ROOT and APP1_PDB1. USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1. USER1 is defined in APP1_PDB2. USER1 can connect only to APP1_PDB1. C##_APP_USER1 can be created in CDB1.

You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI). There is no existing Oracle installation on the server. Which two are prerequisites? (Choose two). an operating system user to own this installation. the Oracle Inventory group oinstall. an operating system account called grid. a group called dba. the installation of Oracle ASMLIB.

In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT? (Choose three). redo logs. control files. all data dictionary metadata. user-defined PL/SQL packages. temporary tablespaces. mandatory Oracle-supplied PL/SQL packages. undo tablespaces.

Which two statements are true when row-archival management is enabled? (Choose two). The ORA_ARCHIVE_STATE column may only be queried by users with the DBA role set. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only. The ORA_ARCHIVE_STATE column may only be updated by users with the DBA role set. The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job based on activity tracking.

Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice and got different values for HIREDATE. Which is guaranteed to be true concerning the redaction policy?. FULL redaction is active on the SAL column. RANDOM redaction is active on the MGR column. RANDOM redaction is active on the HIREDATE column. PARTIAL redaction is active on the MGR column. PARTIAL redaction is active on the HIREDATE column.

Examine this output of an export from the current release of an Oracle multitenant database: SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: expdp system/oracle full=y What is the outcome?. It fails because Data Pump cannot be used while connected to the root container. It creates a full export of the root container and PDB1. It creates a full export of the root container and all PDBs. It creates a full export of only the root container. It creates a full export of only the open PDBs.

Which three are true in Oracle 19c and later releases? (Choose three). If the password file location changes, then the new location is used automatically by the Oracle Server. Schema Only accounts can be granted administrator privileges. All the Oracle-supplied accounts are Schema Only accounts. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user. Unified Auditing can be configured to audit only events that are issued directly by an audited user.

You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command. Which two statements are true about the dependent objects of the CUSTOMERS table?. All the triggers associated with the table are flashed back but are disabled. Materialized views that use the CUSTOMERS table are flashed back. LOB segments associated with the CUSTOMERS table are flashed back. All the constraints defined on the table, except the referential integrity constraints, are flashed back. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.