0833

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 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 these commands: $ sqlplus sys/oracle_4U@localhost:1521/cdb1 SQL> SELECT current_scn FROM v$database; CURRENT_SCN ----------- 2074756 SQL> CREATE TABLE cdb1_tab(c1 NUMBER); Table created. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> CREATE TABLE app_root_tab(c1 NUMBER); Table created. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> CREATE TABLE app_pdb1_tab(c1 NUMBER); Table created. SQL> conn / as sysdba Connected. SQL> ALTER PLUGGABLE DATABASE app_root CLOSE; Pluggable database altered. SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756; Flashback complete. 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.

How do you configure a CDB for local undo mode?. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and create an UNDO tablespace in each PDB, then restart the CDB instance. Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance. Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode. Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.

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 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.

Examine this configuration: 1. CDB1 and CDB2 are two container databases. 2. PDB1 is a pluggable database in CDB1. 3. PDB1_C1_SRV is a service for PDB1. 4. CDB1_LINK is a database link in CDB2 referring to PDB1. 5. CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service. You execute these commands successfully: $ sqlplus sys/oracle_4U@cdb2 as sysdba 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 these commands: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba 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 joins 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.

Examine this configuration: 1. CDB1 is a container database running in ARCHIVELOG mode. 2. Multiple uncommitted transactions are running in CDB1. 3. Redo log groups 1 and 2 are INACTIVE. 4. Redo log group 3 is the CURRENT group. All members of redo log group 3 are lost before it is archived. Examine these possible steps: 1. SHUTDOWN ABORT 2. STARTUP NOMOUNT 3. STARTUP MOUNT 4. ALTER DATABASE MOUNT 5. RESTORE DATABSE 6. RECOVER DATABASE NOREDO 7. RECOVER DATABASE UNTIL AVAILABLE 8. RESTORE ARCHIVELOG ALL 9. ALTER DATABSE OPEN 10.ALTER DATABASE OPEB RESETLOGS Choose the minimum required steps in the correct order to recover the database. 1, 3, 5, 8, 6, 10. 1, 3, 5, 6, 10. 1, 3, 5, 7, 10. 1, 2, 5, 7, 4, 10. 1, 3, 5, 6, 9.

Which three are true about an application container? (Choose three.). It can contain a single application. It can contain multiple applications. It must have an application seed PDB. It must have an application root PDB. Two application containers can share an application seed PDB. An application PDB can belong to multiple application containers.

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 patchsets? (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 patchsets.

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 PBD2 are pluggable databases in CDB1. Examine these commands: $ export ORACLE_SID=CDB1 $ sqlplus / as sysdba .... Database opened. SQL> SHOW PDBS CON_ID CON_NAME OPEN MODE RESTRICTED ------ ---------- --------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 MOUNTED NO 4 PDB2 MOUNTED NO SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 SAVE STATE; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 CLOSE; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb2 OPEN; Pluggable database altered. 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 (PBD) 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.

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.). the DBMS_PDB package. Data Pump full database export and import. Data Pump transportable tablespaces. replication using GoldenGate. cloning the non-CDB as a PDB. Data Pump full transportable database.

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

Which two are true about PDB archive files? (Choose two.). They contain all the data files only in compressed form for a PDB. 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. DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.

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.). a group called dba. the Oracle Inventory group oinstall. an operating system user to own this installation. an operating system account called grid. the installation of Oracle ASMLIB.

You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?. It creates a file that contains SQL statements to re-create the control file. It creates a file that contains RMAN scripts to create a duplicate database. It creates a copy of the control file in the fast recovery area (FRA). It creates a binary backup of the control file. It updates the alert log with the location and contents of the control file.

Which three are true about upgrading an application in an application container? (Choose three.). The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED. An application root clone gets created automatically. After an application upgrade, the application container’s PDBs remain synchronized with the existing application root. The upgrade must be performed when connected to CDB$ROOT. An application name and version number must be specified to upgrade the application. After an application upgrade, the application container’s PDBs are automatically synchronized with the application root clone.

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.

Which two are true about backup encryption? (Choose two.). Keystore-based encryption is the default mode for RMAN backup encryption. Vendor-specific media management software can be used for making encrypted RMAN backups to media. Image copies can be encrypted. Backup encryption can be enabled selectively for specific tablespaces. The BACKUP BACKUPSET command can encrypt and decrypt backup sets. The Transparent Data Encryption (TDE) keystore is backed up using RMAN.

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: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA; System altered. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE '1.0' TO '2.0'; Pluggable database altered. SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL); Table altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO '2.0'; Pluggable database altered. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> DESC emp; Name Null? Type ------ ------- ---------- ENO NUMBER ENAME VARCHAR2(20) SQL> SELECT * FROM emp; ENO ENAME ---- ----- 100 Alan 200 Ben SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC; What will be the outcome and why?. It will return an error because EMP is not empty in APP_ROOT. It will return an error because the SYNC operation is not allowed when constraints are added to common objects. SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows. SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows. It will return an error because EMP.SAL is empty in APP_ROOT.

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. 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. Unified auditing can be automatically synchronized to all application PDBs in an application container.

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. flashback table and transaction.

Examine this extract from the show parameters command: NAME TYPE VALUE --------------------------- ----------- ----------- db_16k_cache_size big integer 0 db_2k_cache_size big integer 0 db_32k_cache_size big integer 0 db_4k_cache_size big integer 0 db_8k_cache_size big integer 0 db_cache_size big integer 0 java_pool_size big integer 0 large_pool_size big integer 0 memory_max_target big integer 800M memory_target big integer 800M pga_aggregate_limit big integer 2G pga_aggregate_target big integer 0 sga_max_size big integer 800M sga_min_size big integer 0 sga_target big integer 0 shared_pool_reserved_size big integer 7130316 shared_pool_size big integer 0 statistics_level string TYPICAL workarea_size_policy string AUTO 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 is managed by using Automated SQL Execution Memory Management. SGA and PGA memory are managed by using Automatic Memory Management (AMM).

Which are two of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c? (Choose two.). backing up the cloned PDB. opening the cloned PDB. 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 database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned. leaving the cloned PDB in mount state.

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.

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

Which three are true about Oracle Grid Infrastructure for a Standalone Server? (Choose three.). It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks. It requires the operating system ORACLE_BASE environment variable to be predefined before installation. It requires Oracle ASMLib to manage Automatic Storage Management (ASM) disks. Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installation owner. It creates one disk group during installation. It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.

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 CDB$ROOT. A PDB Lockdown profile can be created in a regular PDB.

Which two are true about a read-only Oracle home? (Choose two.). Its configuration data and log files reside in subdirectories under the Oracle home. It is enabled by performing an Oracle Database installation with database creation and then running the roohctl -enable script. It requires the Rapid Home Provisioning service. It contains an image that can be distributed across multiple servers. It is enabled by performing a software-only Oracle Database installation and then running the roohctl -enable script.

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. REPORT OBSOLETE. LIST ARCHIVELOG ALL. CROSSCHECK BACKUP OF ARCHIVELOG ALL. LIST ARCHIVELOG. LIST EXPIRED.

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

Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN? (Choose three.). The control file is backed up automatically each time the SPFILE is backed up manually. 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 whenever a new table is created. 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.

Which three are true about cloning databases into an existing CDB with RMAN? (Choose three.). A user with SYSDBA or SYSBKUP 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. Two or more PDBs can be cloned with the same command. A non-CDB can be cloned into a PDB. Only one PDB can be cloned at a time. A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.

Which two are true about creating pluggable databases (PDBs) in Oracle 19c and later releases? (Choose two.). A snapshot copy PDB 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 does not depend on an existing storage snapshot of the source PDB. 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.

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

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

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_user1_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_user1_app END UPGRADE TO '2.0'; Pluggable database altered. SQL> ALTER SESSION SET CONTAINER=app1_pdb1; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_userl_app SYNC; Pluggable database altered. Which two are true? (Choose two.). USER1 can connect to APP1_ROOT and APP1_PDB1. USER1 can connect only to APP1_ROOT. USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1. USER1 can connect only to APP1_PDB1. USER1 can connect to CDB1. USER1 is defined in APP1_PDB2.

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 down time. Which three are required? (Choose three.). CDB2 must be in archivelog mode. CDB1 and CDB2 must both be in local UNDO mode. CDB2 must be in shared UNDO mode only. CDB1 must be in shared UNDO mode only. CDB1 must be in archivelog mode. CDB1 and CDB2 must be in shared UNDO mode.

Which three are true about recovering tables using RMAN? (Choose three.). RMAN can recover tables owned by the SYS user. RMAN can recover tables in the SYSAUX tablespace. RMAN can recover tables owned by the SYSTEM user. RMAN can recover a table after a DDL operation has altered the table structure. RMAN can recover tables in the SYSTEM tablespace. RMAN can recover tables in a standby database. RMAN always uses an auxiliary instance.

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, PDB1, PDB2, PDB3, and PDB4. CDB$ROOT, PDB2, PDB1, and PDB3. CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4. CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4. CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3.