Choose two. Your SALES_ROOT application container has two application PDBs. The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs. Examine this query and its output: SELECT containers_default, container_map, table_name FROM dba_tables WHERE owner='FIN' ; CONTAINERS_DEFAULT CONTAINER_MAP CONTAINER_MAP_OBJECT TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------NO YES NO REVENUE NO NO YES MAPTABLE Which two are true?
choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).
Which two statements are true about RMAN duplexed backups?
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?
You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance?
Choose three. Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
Choose two. Which two statements are true when row-archival management is enabled?
Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)
Which two are true about automatic block repair? (Choose two.)
Choose two. Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases?
Choose three. Which three are true about the Oracle Optimizer?
Choose three. Which three are true about patchsets?
Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?
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?
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 f ind that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
Choose three. Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output?
Choose two. Which two are true about the Optimizer Statistics Advisor?
Choose the best answer. 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/orac1e_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?
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 the tools for diagnosing Oracle Database failure situations?
You plan to create a database by using the Database Configuration Assistant (DBCA), with t he following specifications: Applications will connect to the database via a middle tier. The number of concurrent user connections will be high. The database will have mixed workload, with t he execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database?
Choose two. Which two are true about gathering optimizer statistics?
Choose two. In which two situations can you use Database Upgrade Assistant?
Examine this configuration: While CDB1 is open, ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/ controlfile02.ctl’is accidentally deleted. To recover from this critical failure, you execute these commands:
What will be the outcome?
Which two statements are true about the Database Configuration Assistant (DBCA)?
Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)
choose two Which two statements are true about encrypted backups performed by using RMAN?
Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)
RMAN is connected to a target database instance and an auxilary instance. You execute 3625the command: RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G; What is the outcome?
Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)
Choose three. Which three are true about backing up the control file?
Choose three. Which three are true about Rapid Home Provisioning of Oracle software?
Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?
choose three Which three are true about unified auditing in full mode?
Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?
choose four Which four are true about performance-related Oracle tools?
Examine the statements that use flashback technologies:
FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYYMM¬DD HH:MI:SS');
SELECT * FROM customers AS OF SCN 123456;
FLASHBACK TABLE customers TO BEFORE DROP;
FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
ALTER TABLE customers FLASHBACK ARCHIVE; Which set ofstatements depends on the availability of relevant undo data in the undo tablespace?
Choose two. Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases?
Choose three. Which three are true about block media recovery?