2 - 61-90

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.). A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version. An existing Oracle base can be used. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure. Existing Oracle Database instances must be shut down before starting the upgrade. Only the grid user can perform the upgrade.

A database is configured in ARCHIVELOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery required? (Choose two.). after losing a SYSAUX tablespace data file. after losing all members of an INACTIVE online redo log group. after losing all members of the CURRENT online redo log group. after losing all copies of the control file. after losing an UNDO tablespace that is in use.

Which two are true about instance recovery? (Choose two.). It is not possible if an archived log is missing. It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered. Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery. It is performed by the Recovery Writer (RVWR) background process. Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing the log writer to write more frequently, thereby reducing the number of I/Os needed during instance recovery. It is performed automatically while the database remains in MOUNT state. Then the database is opened.

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.). The number of table rows is considered when evaluating the cost of accessing a table using an index. Index balanced B*Tree height is considered when evaluating the cost of using an index. The Statistics Advisor can help recommend the best way to gather statistics. Statistics collected using DBMS_STATS always yield the best optimizer result. The Statistics Advisor generates actions for all recommendations.

A container database (CDB) contains two pluggable databases PDB1 and PDB2. The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it. The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT. Which three are true? (Choose three.). Data file 24 can be recovered only while connected to PDB2. Data file 24 can be restored and recovered while connected to CDB$ROOT. Data file 24 can be restored only while connected to CDB$ROOT. Data file 24 can be restored only while connected to PDB2. Data file 24 can be recovered while connected to PDB2. Data file 24 can be recovered while connected to CDB$ROOT.

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.). Tablespaces are automatically created as needed while importing full exports in either a non-CDB or a PDB. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB. A new PDB is automatically created when importing a non-CDB into a CDB. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

Which three methods can be used for heap table data migration after upgrading a database? (Choose three.). using Database Replay. using SQL Developer. using Oracle Data Pump. using operating system file copy utilities. using Database Upgrade Assistant. using the CREATE TABLE AS SELECT SQL statement.

Which two are true about Oracle instance recovery? (Choose two.). Recovery begins from the beginning of the CURRENT redo log group. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the database is opened. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT). Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

Examine this configuration: 1. The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA. 2. ORCL uses disk group +FRA for the Fast Recovery Area. 3. LISTENER is the listener for ORCL. 4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart. 5. All components are currently shut down. You execute this command: $ srvctl start database -d ORCL What is the outcome?. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started. Only the ORCL database instance is started. Only the ORCL database and the ASM instances are started. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started. Only the ORCL database instance and the +DATA and +FRA disk groups are started.

Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.). The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

Which three are true? (Choose three.). Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container. Application-common TSDP policies are always container specific. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block. Unified auditing can be automatically synchronized to all application PDBs in an application container.

Which three are true about Automatic Workload Repository (AWR)? (Choose three.). By default, AWR snapshots are taken every 60 minutes. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter. By default, AWR snapshots are retained for 7 days. The taking of AWR snapshots can be disabled. AWR data is stored in the SYSTEM tablespace.

Which two are true about automatic block repair? (Choose two.). Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases. It is not possible for media corrupt blocks. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed: CREATE PLUGGABLE DATABASE app1 AS APPLICATION CONTAINER ADMIN USER admin1 IDENTIFIED BY app_123 ROLES = (CONNECT); Which three are true? (Choose three.). Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED. An application seed PDB is created for APP1. An application root PDB is created for APP1. A default service is created for the application root APP1. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED. APP1 can never be unplugged.

Which two are true about RMAN encryption? (Choose two.). RMAN encryption keys are stored in a database keystore. RMAN can encrypt the Oracle Database password file. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available. The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command. Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.

Which three are true about performing an Oracle Database install on Linux? (Choose three.). The runfixup.sh script can install missing RPMs. The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group. It allows you to select the languages supported by the Oracle database server. It can be done before installing Grid Infrastructure for a Standalone Server. The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group. It can be done after installing Grid Infrastructure for a Standalone Server. The Oracle database administrator must be granted access to the root operating system account to run root privileged scripts.

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.). It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used. It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used. A Virtual Private Catalog used to register a container database must be created in a pluggable database. A Virtual Private Catalog used to register a container database can be created in a pluggable database. It is always possible for RMAN to connect to a pluggable database as a target. A Virtual Private Catalog used to register a container database can be created in a non-container database.

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 have configured RMAN SBT channels to write backups to media. You then take an RMAN backup by using this command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE KEEP UNTIL TIME 'SYSDATE + 730' RESTORE POINT 'OLD_CONFIGURATION'; Which three are true? (Choose three.). The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy. All archive logs created after this backup are kept for two years. The SPFILE is included in the self-contained archival backup. The control file is included in the self-contained archival backup. The restore point is a label for the system change number (SCN) before the archival backup was taken.

The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database backup of this tablespace? (Choose two.). Backups must be done incrementally. Backups must be contained in backup sets. Backups can be taken only if the database is in ARCHIVELOG mode. Backups can be done incrementally. The database must be registered in an RMAN catalog. Only consistent backups can be created.

Which four are true about RMAN backup sets? (Choose four.). A backup piece can belong to only one backup set. A data file can be split into multiple sections stored in different backup sets. A data file can be split into multiple sections stored in different backup pieces in the same backup set. Blocks from multiple data files can be contained in one backup piece. A backup set can contain only one backup piece. A backup set must be written to media. A backup set must be written to disk. Blocks from multiple data files can be contained in one backup set.

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.). Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB. SPFILE backups can be created while connected to an application root PDB. The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.). cloning a remote container database in interactive mode. cloning a remote pluggable database in silent mode. relocating a remote pluggable database in interactive mode. relocating a remote container database in silent mode. cloning a remote container database in silent mode. relocating a remote pluggable database in silent mode. relocating a remote container database in interactive mode.

Examine these queries and their output: SQL> select pdb_name, name, pdb_restore_point, clean_pdb_restore_point from v$restore_point natural join dba_pdbs; PDB_NAME NAME PDB_RESTORE_POINT CLEAN_PDB_RESTORE_POINT PDB1 R1 YES NO SQL> select property_name, property_value from database_properties where property_name like 'UNDO'; PROPERTY_NAME PROPERTY_VALUE LOCAL_UNDO_ENABLED FALSE An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1. How do you achieve this?. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT. This cannot be done due to the lack of a clean restore point.

Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.). Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state. A failure can be closed only when it has been repaired. Data Recovery Advisor can be used if a database is closed. The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities. Data Recovery Advisor can proactively check for failures.

Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)? (Choose four.). It can be performed using an auxiliary instance managed by a DBA. It can be used to recover a truncated table. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained. RMAN always includes tablespaces containing undo segments in the recovery set. It can be performed repeatedly until the correct time is found without using an RMAN catalog. flashback database must be enabled for it to work. It can be used to recover a dropped tablespace. It can be performed using an auxiliary instance managed by RMAN.

Which two are true about unplugging an application container from a container database and plugging it into a different container database? (Choose two.). It requires local undo mode in both container databases. It requires only local undo mode in the database where the application container will be unplugged. Plugging the application root into a different CDB plugs in all its application PDBs. Application PDBs in the application container must be unplugged before the application root is unplugged. Unplugging the application root from a CDB unplugs all its application PDBs. The application root of an application container should be plugged into the other CDB before its application PDBs are plugged in.

Which three are true in Oracle 19c and later releases? (Choose three.). Tablespaces always remain in read/write mode during transportable tablespace operations. Simultaneous data pump jobs can be limited at the pluggable database (PDB) level. Tablespaces never remain in read/write mode during transportable tablespace operations. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported. A transportable data pump import can leave a plugged-in tablespace in read-only mode. A transportable data pump import can leave a plugged-in tablespace in read/write mode.

Which three are true about Audit policies in container databases (CDBs)? (Choose three.). All audit records are written to the audit trail in CDB$ROOT. A common unified audit policy can be created at the application root level. A common unified audit policy can be created at the CDB level. An application PDB cannot have a local audit policy. Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root. Application-common unified audit policies defined in an application root must be manually synchronized by each application PDB contained in the application root.

Which three are true about Oracle Grid Infrastructure for a Standalone Server? (Choose three.). It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software. It creates one disk group during installation. It requires the operating system oracle_base environment variable to be predefined before installation. It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks. 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.