2 EB - 31-60

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file? (Choose two.). Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes. Re-create the password file in Oracle Database 12c format.

Examine the query and its output executed in an RDBMS Instance: SQL> SELECT * FROM v$pwfile_users; USERNAME SYSDBA SYSOPER SYSASM SYSBACK SYSDG SYSKM CON_ID SYS TRUE TRUE FALSE FALSE FALSE FALSE 0 C#B_ADMIN FALSE FALSE FALSE TRUE FALSE FALSE 0 C#C_ADMIN FALSE FALSE FALSE FALSE TRUE FALSE 0 C#A_ADMIN FALSE FALSE FALSE FALSE FALSE TRUE 0 C#D_ADMIN FALSE FALSE TRUE FALSE FALSE TRUE 0 Which three statements are true about the users (other than sys) in the output?. The C##B_ADMIN user can perform all backup and recovery operations using RMAN only. The C##C_ADMIN user can perform the data guard operation with Data Guard Broker. The C##A_ADMIN user can perform wallet operations. The C##D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM). The C##B_ADMIN user can perform all backup and recovery operations using RMAN or SQL*Plus.

You are working on an Oracle Database 19c database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.). Flashback logs are not archived. Flashback logs are maintained in redo log files. Flashback logs are maintained in the Flash Recovery Area. Flashback logs are used to maintain Flashback Database related errors. Flashback logs need to be cleared manually after you disable Flashback Database.

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command: SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin, oe_admin; Which statement is true?. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role. It fails because the command does not specify when the unified audit policy should be enforced. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them. It fails because system privileges cannot be granted with roles in the same audit policy.

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

Which three are true about OPatch? (Choose three). It requires installation of Oracle Universal Installer. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process. It must be invoked as the user that owns the software being patched. It is a Java-based utility for applying patches. It is platform independent. It can be used to apply interim patches to the Grid Infrastructure and Database Home combination.

Which three RMAN persistent settings can be set explicitly? (Choose three). SPFILE backup duplexing. control file auto backup formats. archive log deletion policy. image copy duplexing. redo log backup duplexing. archive log backup duplexing.

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. How would you achieve this?. by using the RMAN switch command to set the new location for the data files. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host. by using the RMAN duplicate command with dbid and set new name for tablespace to recover the database to the new host. by creating a new database in the new host, and then using the RMAN recover command.

RMAN is connected to a target database instance and an auxiliary instance. You execute the command: RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G; What is the outcome?. RMAN uses the pull method to restore files using image copies. RMAN uses the push method to transfer image copies. RMAN uses the push method to transfer backup sets. RMAN uses the pull method to restore files using backup sets.

You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?. Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location. Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs. How can you detect the cause of the degraded performance?. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots. by using Active Session History (ASH) data and performing hang analysis. by running ADDM in diagnostic mode.

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used. Setting the target tablespace to read-only after the segments are moved. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used. Taking the target tablespace offline after the segments are moved. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used.

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?. Compare Period ADDM report. AWR Compare Period report. Active Session History (ASH) report. Taking a new snapshot and comparing it with a preserved snapshot.

The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open. You execute the RMAN commands: RMAN> CONNECT CATALOG rc12c/pass12c@catdb12c RMAN> IMPORT CATALOG rc11/pwdcat11@ract11 Which two tasks are performed as part of the import? (Choose two.). Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name. Recovery catalog is resynchronized with the control files of the registered databases. Imported databases are unregistered from the RC11 catalog. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed. All databases registered in the RC11 catalog are registered in the RC12C catalog.

Which three are true about upgrading an application in an application container? (Choose three.). An application root clone gets created automatically. The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED. 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 statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.). It is used to change failure priority only for HIGH or LOW priorities. It is used to execute the advised repair script. It is used to change failure priority only for the CRITICAL priority. It is used to explicitly close the open failures. It is used to inform the database about the repair after the repair script executes.

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 no parallel channels are allocated for the auxiliary database. It succeeds only if the target database is in MOUNT state. It fails because there is no connection to a recovery catalog.

Which three are true about Oracle Restart? (Choose three). It can be configured to automatically attempt to restart various components after a hardware or software failure. While starting any components, it automatically attempts to start all dependencies first and in proper order. It runs from the Oracle Grid Infrastructure home. If you shut down a database instance with SQL*Plus, Oracle Restart interprets this as a database failure and attempts to restart the instance. The Server Control (SRVCTL) utility can be used to start and stop Oracle Restart. It runs periodic check operations to monitor the health of Oracle components.

Which two statements are true about the Database Configuration Assistant (DBCA)?. It can configure Automatic Storage Management (ASM) diskgroups. It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host. It can be used to add a new tablespace. It can be used to create a database template from an existing database. It can generate SQL database creation scripts.

You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?. It creates a binary backup of the control file. It updates the alert log with the location and contents of the control file. 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).

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)?. Tracking the most recent read time for a table segment in a user tablespace. Tracking the most recent write time for a table segment in a user tablespace. Tracking insert time by row for table rows. Tracking the most recent write time for each block in a table segment. Tracking the most recent read time for a table segment in the SYSTEM tablespace. Tracking the most recent write time for a table segment in the SYSAUX tablespace.

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?. Decreasing PCTUSED. Decreasing PCTFREE. Increasing the number of DBWR process. Using Automatic Segment Space Management (ASSM). Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation.

You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which two files are removed automatically if space is required in the FRA as per the retention policy? (Choose two). user-managed backups of data files and control files. flashback logs. RMAN backups that are obsolete. archived redo log files that have multiple copies in a different archive location.

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature. Examine the table definition: create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_time); Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?. The valid time columns employee_time_start and employee_time_end are automatically created. The same statement may filter on both transaction time and valid time by using the AS OF TIMESTAMP and PERIOD FOR clauses. The valid time columns are not populated by the Oracle Server automatically. The valid time columns are visible by default when the table is described. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE_ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?. A base recovery catalog should exist. The owner of VPC cannot own recovery catalog. At least one target database should be registered in the recovery catalog. The register database privilege should be granted to the virtual catalog owner. The recovery_catalog_owner role should be granted to the virtual catalog owner.

Which set of statements depends on the availability of relevant undo data in the undo tablespace? 1. FLASHBACK TABLE customers TO TIMESTAMP 2. SELECT * FROM customers AS OF SCN 123456; 3. FLASHBACK TABLE customers TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP; 5. SELECT * FROM customers VERSIONS BETWEEN SCN; 6. ALTER TABLE customer FLASHBACK ARCHIVE;. 1,3,6. 1,2,5. 3,4,5. 2,3,5,6.

Which two are true about RMAN image copies? (Choose two). They can only be written to disk. They can be encrypted using Transparent Data Encryption (TDE). They can be used as a level 0 incremental backup. They can be used as a level 1 incremental backup. They are the only backup option available for databases in NOARCHIVELOG mode.

Identify three scenarios in which RMAN will use backup sets to perform active database duplication. when the duplicate ... from active database command contains the section size clause. when you perform active database duplication on a database with flashback disabled. when you specify set encryption before the duplicate ... from active database command. when the number of auxiliary channels allocated is equal to or greater than the number of target channels. when you perform active database duplication on a database that has read-only tablespaces.

User SCOTT has been granted the CREATE SESSION privilege and the MGR role. Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set. Data is never redacted for the EMP_VW.SAL column. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?. The target database control file is synchronized from the recovery catalog with a partial resync at the next backup. The recovery catalog is synchronized from the target database control file with a full resync at the next backup. The target database control file is synchronized from the recovery catalog with a full resync at the next backup. The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.