多选题 Which three are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c?

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

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

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

单选题 Examine this configuration.
1，CDB1 is a container database running in ARCHIVELOG mode.
2，Multiple uncommitted transactions are running in CDB1
3，Redo log groups 1 and 2 are INACTIVE
4，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， STARTUP MOUNGT
4， ALTER DATABASE MOUNT
5， RESTORE DATABASE
6， RECOVER DATABASE UOREDO
7， RECOVER DATABASE UNTIL AVALABLE
8， RESTORE ARCHIVELOGALL
9， ALTER DATABASE OPEN
10，ALTER DATABASEE OPEN RESETLOGS
Choose the minimum required step in the correct order to recover the database.

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

单选题 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 format. Examine this list of steps:
1, Make the UNIVERSITY tablespace read-only on the source system
2, Export the UNIVERSITY tablespace metadata using EXPDP
3, ate a cross-platform backup set from the UNIVERSITY tablespace on the source system using an RMAN command that includes the DAMAPUMP clause
4, the cross-platform backup sets to the destination system
5, 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 are the minimum number of steps required , in the correct order , to transport the UNIVERSITY tablespace?

单选题 A user complains about poor database performance
You want to verify if the user’s session has waited for certain type of I/O activity
Which view displays all waits waited on by a session at least once?

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