单选题 You want to transport the UNIVERSIRY tablespace from one database to another. The universiry tablespace is currently open read/write. The source and destination platforms have the same endian format. Examine this list of steps:
1-Make the UNIVERSIRY tablespace read-only on the source system
2-Export the UNIVERSIRY tablespace metadata using EXPDP
3-Create a cross platform backup set from the UNIVERSITY tablespace on the source system. using an RMAN command that includes the DAMAPUMP 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 pamapump clause
7-Import the UNIVERSIRY tablespace metadata using IMPDP
8-Make the UNIVERSIRY tablespace read /write on the destination system
Which are the minimum number of steps required. in the correct order, to transport the UNIVERSIRY tablespace?

单选题 Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

单选题 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/oracle_ 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
Which table or set of tables will exist after the Flashback operation has completed?

单选题 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?

单选题 A schema owner truncated a table in error and must recover the data Which Oracle
Flashback feature could be used to recover the data?

单选题 Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

单选题 How do you configure a CDB for local undo mode?

单选题 Examine this configuration
CDB1 is a container database running in ARCHIVELOG mode.
Multiple uncommitted transactions are running in CDB1
Edo log groups 1 and 2 are INACTIVE
Redo log group 3 is the CURRENT group
All members of redo log group 3 are lost before it is archived Examine these
Possible steps
1- SHUTDOWN ABORT
2-STARTUP NOMOUNT
3- STARUP MOUNT
4-ALTER DATABASE MOUNT
5- RESTORE DATABASE
6-RECOVER DATABASE NOREDO
7- RECOVER DATABASE UNTIL AVAILABLE
8-RESTORE ARCHIVELOG ALL
9-ALTER DATABASE OPEN
10-ALTER DATABASE OPEN RESETLOGS
Choose the minimum required steps in the correct order to recover the database