Choose three. Which three are true about cloning databases into an existing CDB with RMAN?
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?
Choose three. Which three are true about corrupted data blocks and their recovery in an Oracle Database?
Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?
choose two You take your database backups by using the RMAN media management interface (MMI). Which two are true about the use of the RMAN MMI?
Choose the best answer. 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?
Choose the best answer. 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/ orac1e@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?
Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?
Choose the best answer. You want to transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have the same endian Examine this list of steps:. 1. Make the UNIVERSITY tablespace read-only on the source 2. Export the UNIVERSITY tablespace metadata using EXPDP. 3. Create a cross-platform backup set from the UNIVERSITY source system, using an RMAN command that includes the DATAPUMP clause. 4. Copy the cross-platform backup sets to the destination system. 5. Copy the Data Pump dump set from the source to the destination system. 6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause. 7. Import the UNIVERSITY tablespace metadata using IMPDP. 8. Make the UNIVERSITY tablespace read/write on the destination system. Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?
Choose three. Which three are true about Rapid Home Provisioning of Oracle software?
Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)
Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?
choose one .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?
You have configured RMAN SBT channels to write backups to media. You then take an RMAN backup by using this command: Which three are true? (Choose three.)
Choose three. Which three are true about Oracle Grid Infrastructure for a Standalone Server?
Choose two. For which two tasks can you use the DBMS_PDB.DESCRIBE procedure?
Choose two. When backing up to the Oracle Fast Recovery Area (FRA), you determine that the backup takes too long and suspect a performance bottleneck. Which two are true about diagnosing and tuning these problems?
Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)
Choose three. Which three are true about Oracle pluggable databases (PDBs)?
Choose three. Which three capabilities require the use of the RMAN recovery catalog?
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.)
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 two. RMAN has just been connected to a target database and the recovery catalog database. In which two cases would an automatic full resynchronization occur between this target database's control file and the RMAN recovery catalog?
Choose three. Which three are true about SGA memory management in a multitenant database?
Choose two. 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_user1_app SYNC; Pluggable database altered. Which two are true?
Choose two. Your database is in ARCHIVELOG mode and you plan to use Flashback Database. Which two features or parameters manage space availability in the fast recovery area?
Choose three. Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN?
Choose two. 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 three. The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3. Which three are true?