Your database is on ARCHIVELOG mode and an incremental backup exists.A media failure in the loss of a data file and an online redo log.Examine these commands:1. STARTUP NOMOUNT2. STARTUP MOUNT3. RESTORE DATABASE4. RECOVER DATABASE5. RECOVER DATABASE UNTIL CANCEL6. ALTER DATABASE OPEN7. ALTER DATABASE OPEN RESETLOGSWhich commands are required to recover your database?
Examine the RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?
One of your multitenant container databases (CDB) contains two pluggable databases (PDBs) called PDB1 and PDB2.You connect to PDB2 as a common user with DBA privileges.The STATISTICS_LEVEL parameter is PDB modifiable.As the user SYS, you execute this command successfully on PDB2:SQL> ALTER SET STATISTICS_LEVEL=ALL SID='*' SCOPE=BOTH;Which two statements are true about the result of this command?
A database is running in archivelog mode. The database contains locally managed tablespaces. Examine the RMAN command:RMAN> BACKUP -AS COMPRESSED BACKUPSET -SECTION SIZE 1024M -DATABASE;Which statement is true about the execution of the command?
One of your container databases (CDBs) has five pluggable databases (PDBs).COMMON_USER_PREFIX -These commands executed successfully while connected as SYS to CDB$ROOT:SQL> CREATE USER c##dba_admin IDENTIFIED BY orcl123;SQL> CREATE ROLE c##role1 CONTAINER=ALL;SQL> GRANT CREATE VIEW TO c##role1 CONTAINER=ALL;SQL> GRANT c##role1 TO c##dba_admin CONTAINER=ALL;SQL> GRANT c##role1 to system CONTAINER=ALL;Which three are true? (Choose three.)
Which two statements are true about scheduling operations in a pluggable database (PDB)?
