2 EC - 31-53

In performance management, which two factors might reduce the ability of an application to scale to a large number of users? (Choose two.). poorly written SQL. the number of tablespaces containing tables updated by a transaction. poorly trained users who do not commit transactions. the number of data files containing extents belonging to tables updated by a transaction. issuing multiple savepoints during a transaction.

You issued this command: RMAN> BACKUP RECOVERY AREA FORCE; Which three are true? (Choose three.). All files in the current FRA that have been backed up already, are backed up. All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up. All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up. All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up. All files in any previous FRA that have not yet been backed up, are backed up. All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up. All files in any previous FRA that have been backed up already, are backed up.

Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.). A lost SPFILE can be recovered from memory using SQL*PLUS. A lost password file can be re-created with SQL*PLUS. A lost TEMPFILE must always be re-created manually. A lost password file can be manually re-created with the orapwd utility. A lost PFILE can be re-created from alert.log using SQL*PLUS. A lost index tablespace can be re-created without performing any recovery.

Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK DATABASE is ON. You execute commands creating tables and then FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756; Which table or set of tables will exist after the Flashback operation has completed?. CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB. CDB1_TAB and APP_PDB1_TAB. none of the tables, because all three tables will be dropped. CDB1_TAB only. CDB1_TAB and APP_ROOT_TAB.

Which two are true about RMAN backups when using a media manager? (Choose two.). A media manager always writes RMAN requested backups to tape. By default, a request for a proxy copy may result in a backup set being created. A media manager is required to create RMAN proxy copies. A media manager is required to create RMAN image copies. The media manager layer (MML) routines provided by Oracle support any vendors' media management products.

Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output? (Choose three.). Some messages in the error stack are not errors. If an RMAN command fails, the output will only identify the command that failed. If an RMAN command fails, the output will identify the channel ID where the failure occurred. Media Management errors appear as a line with "sbtio" and a number. Media Management errors appear as a line with "sbtio". Media Management errors appear as a line with "Additional information" and a number.

Which three are true about block media recovery? (Choose three.). The data file containing the block being recovered remains online. To use it, Flashback Database must be enabled. A block being recovered is not accessible. It can be performed on noncorrupt blocks. The target database for which one or more blocks are to be recovered must be in the OPEN state. It cannot repair logical corruption.

In which two situations can you use Database Upgrade Assistant? (Choose two.). when the operating system (OS) needs to be changed as part of the upgrade. when a character set conversion is required during the upgrade. when multiple pluggable databases in a container database have to be upgraded in a specific sequence. when the target and source database are on the same platform. when the hardware platform needs to be changed as part of the upgrade.

Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.). The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers. PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session. The entire PGA is located in the System Global Area (SGA) when using shared servers. Sorts and Hash Joins use PGA memory. The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.). Online Redo Log backups can be created while connected to the root container. Control file backups can be created while connected to the root container. The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT. Archived Redo Log backups can be created while connected to an application root CDB. Control file backups can be created while connected to a nonroot container.

Which three are true about Automatic Workload Repository (AWR) snapshots? (Choose three.). They are generated if STATISTICS_LEVEL is set to TYPICAL. They are generated if STATISTICS_LEVEL is set to ALL. They are always created automatically. They are always created manually. They can be retained forever. They are generated if STATISTICS_LEVEL is set to BASIC.

Which three are true about using Database Resource Manager in an Oracle multitenant environment? (Choose three.). A PDB-level resource plan can limit session PGA memory. A CDB-level resource plan can limit PDB CPU utilization. A CDB-level resource plan can limit session CPU utilization. PDB-level resource plans can limit uncommitted UNDO per consumer group. A CDB-level resource plan can limit PDB UNDO use. A CDB-level resource plan is mandatory when using PDB-level resource plans.

Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases? (Choose three.). The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs. The base catalog must be enabled for Virtual Private Catalog use. The target PDB must be registered in a base catalog. The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog. The target PDB must be registered in a Virtual Private Catalog. The target PDB must be registered in both the base catalog and the Virtual Private Catalog.

Which three activities are possible for PDBs? (Choose three.). converting an application PDB to a regular PDB. converting an application PDB to an application root. converting an application seed to an application PDB. converting an application PDB to an application seed. converting a regular PDB to an application PDB. converting an application container into another application container in a different CDB. converting an application container into another application container in the same CDB.

Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege? (Choose three.). They can view data from any data dictionary view or dynamic performance view. They cannot create restore points. They cannot drop tablespaces. They can create any table. They can drop any tablespace. They can view data from any user-defined tables.

Which two are prerequisites for performing Flashback Transaction? (Choose two.). Fast Recovery Area must be enabled for the database. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package. Undo retention guarantee must be configured for the database. A supplemental log must be enabled for the primary key. A supplemental log must be enabled for the primary key.

Which three are true about a container database (CDB)? Choose three. It can be created from a non-CDB. It can contain only one PDB$SEED, which is created when the CDB is created. It can have local users with the same name in different PDBs. It can contain only one Application Container seed, which is created when the Application Container is created. It can be created by cloning an existing CDB. It can have any number of pluggable databases (PDBs) limited only by space availability. It contains predefined common roles in both the root and the seed.

You upgrade your database from pre-12c to a multitenant container database (CDB) that contains pluggable databases (PDBs). Examine the query and its output: SQL> SELECT * FROM v$PWFILE_users; USERNAME SYSDBA SYSOPER SYSASM SYSBACK SYSDG SYSKM CON_ID SYS TRUE TRUE FALSE FALSE FALSE FALSE 0 Which two tasks must you perform to add users with the SYSBACKUP, SYSDG, and SYSKM privileges to the password file? Choose two. Re-create or migrate the password file to the Oracle Database 12c format. Grant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users. Copy the password file from a sample file in the DBS directory. Assign appropriate operating system groups to SYSBACKUP, SYSDG, and SYSKM.

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 is enabled for all users having SELECT privilege on SH.SALES. Only successful queries of SH.SALES are written to the audit trail. It is only enabled for user SH. Audit records are always stored in an external audit file.

You take your database backups by using the RMAN media management interface (MMI). Which two are true about the use of the RMAN MMI? (Choose two.). You can use it to create image copies for entire file systems. You can use it to create image copies for database files. You can use it to create backup sets for database files. You can use it to create proxy copies for database files. You can use it to create proxy copies for entire file systems.

Which two are true about RMAN virtual private catalogs (VPCs)? (Choose two.). RMAN uses Oracle Virtual Private Database (VPD) to implement VPCs. Each VPC is owned by the recovery catalog schema owner. VPC functionality is enabled by default. The RMAN catalog owner can grant access for an already registered database to a new virtual catalog owner. Only one target database can be registered in a VPC.

Examine this extract from the show parameters command. How are System Global Area (SGA) and Program Global Area (PGA) memory managed by an instance using these parameter settings?. SGA and PGA memory are manually managed. SGA memory is manually managed and PGA memory is managed by using Automated SQL Execution Memory Management. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is manually managed. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory. SGA and PGA memory are managed by using Automatic Memory Management (AMM).

Which two are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.). When ADDM reports multiple findings, summing all their impacts can yield to more than 100% of DB time. It runs automatically after each AWR snapshot. By default it analyzes a period of time corresponding to the last 4 hours of activity. Results are written to the alert log. By default it analyzes a period of time corresponding to the last 24 hours of activity.