A user complains about poor database performance. You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?
Choose three. Which three are true about the tools for diagnosing Oracle Database failure situations?
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. 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?
Choose the best answer. Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle . SQL> col name for a10 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?
Choose three. Which three are true about Recovery Manager (RMAN) active database duplication?
Choose two. Which two are true about unplugging an application container from a container database and plugging it into a different container database?
Choose the best answer. 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?
Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database?
Choose three. Which three are true about upgrading an application in an application container?
Examine these queries and their output: After a system crash, an instance restart and an attempted opening of the PDBs result in: Which two are true? (Choose two.)
Choose three. Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?
A container database called CDB1 is OMF-enabled. PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1: CREATE PLUGGABLE DATABASE pdb1 USING ‘/u01/app/oracle/oradata/pdb1.xml’ SOURCE_FILE_NAME_CONVERT = (‘/u01/app/oracle/oradata/’, ‘/u02/app/oracle/oradata/’);
Which two are true? (Choose two.)
Choose three. Which three are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c?
Choose three. Which three are true about Rapid Home Provisioning of Oracle software?
Choose the best answer. 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: S sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; Which is true?
Choose two. 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 the best answer 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
Choose three. Which three are true about Oracle Grid Infrastructure for a Standalone Server?
Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)
choose one You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command to change the requirement: SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR; What is the outcome?
Choose the best answer. Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?
Choose three. Which three are true about SGA memory management in a multitenant database?
Examine the query and its output executed In an RDBMS Instance: Which three statements are true about the users (other than sys) in the output?
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)
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.)
Choose two. Which two statements are true when row-archival management is enabled?
Choose two. Which two are true about creating RMAN backups for an Oracle container database?
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?
Which two are true about creating RMAN backups for an Oracle container database?
Choose three. PDB1 and PDB2 are pluggable databases in CDB1. Examine these commands: $ export ORACLE_SID=CDB1 $ sqlplus / as sysdba SQL> STARTUP ....... Database opened. SQL> SHOW PDBS CON_ID CON_NAME --------------------------------------------------------------------OPEN MODE READ ONLY NO MOUNTED MOUNTED SQL> ALTER PLUGGABLE 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 A DATABASE pdb2 OPEN; Pluggable database altered. CDB1 is then restarted. Which three are true?
While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck. FORCE LOGGING is enabled for the database. Which two could improve read performance? (Choose two.)
Choose two. 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?
Which two are true about creating pluggable databases (PDBs) in Oracle 19c and later releases?
Which three are true about monitoring waits for sessions and services? (Choose three.)
Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)
Choose three. Which are the three steps in the SQL tuning process for Oracle Database environments?
choose two 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?
Examine the RMAN command: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3); SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; } Which statement is true about the command?
Choose two. Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)?
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?
Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
Examine these queries and their output: 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?
You are administering a multitenant container database (COB) 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?
Choose two. Which two are true about an RPM-based Oracle Database installation?
Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?
Choose three. Which three capabilities require the use of the RMAN recovery catalog?
A database is configured in ARCHIVE LOG mode. Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred. In which two scenarios is complete recovery possible? (Choose two.)
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)
Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)
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?
HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1,must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?
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 rcl2c/passl2c@catdbl2c RMAN> IMPORT CATALOG rcll/pwdcatll@ractll Which two tasks are performed as part of the import?
A database is configured in ARCHIVE LOG 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.)
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:
What is the outcome?
Choose two. Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c?
Choose the best answer. Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?
Which three are true about managing memory components in an Oracle database instance? (Choose three.)
Choose two. Which two are true about backup set compression using RMAN default compression?
You execute the following piece of code with appropriate privileges: BEGIN DBMS_REDACT.ADD_POLICY ( END; object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP', => 'SAL', => 'SCOTT_EMP', => DBMS_REDACT.FULL, => 'SYS_CONTEXT (''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); END; BEGIN DBMS_REDACT.ADD_POLICY ( object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP_VW', => 'SAL', => 'SCOTT_EMP_VW', => DBMS_REDACT.NONE, => 'SYS_CONTEXT (''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); 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?
Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed: Which three are true? (Choose three.)
Choose two. Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup?
Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice. SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; Which is guaranteed to be true concerning the redaction policy?
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?
The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.