Examine the details of the uncompressed, non-partitioned heap table CITIES.
Examine the command:
SQL>ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it?
CORRECT TEXT
You are using RMAN to back up your database. All the data files are in read/write mode.
Examine the RMAN configuration parameters:
Which two statements are true about a whole consistent backup of a database running in ARCHIVELOG mode? (Choose two.)
You run a script that completes successfully using SQL*Plus that performs these actions:
1.Creates a multitenant container database (CDB)
2.Plugs in three pluggable databases (PDBs)
3.Shuts down the CDB instance
4.Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script?
Unified auditing is enabled in your database. The HR_ADMINand OE_ADMINroles exist and are granted system privileges.
You execute the command:
SQL>CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin, oe_admin; Which statement is true?
Which three statements are true about server-generated alerts? (Choose three.)
