Oracle 1z1-063 valid study dumps : Oracle Database 12c: Advanced Administration

Which two result in an inconsistent backup? (Choose two.)

• A. an RMAN full backup taken for a database in NOARCHIVELOG mode
• B. a user-managed backup taken for a closed database in NOARCHIVELOG mode
• C. a differential incremental backup
• D. a backup taken immediately after a SHUTDOWN ABORT command
• E. an RMAN backup taken for an open database in ARCHIVELOG mode

In which situation can you use Flashback Database?

• A. when retrieving a dropped tablespace
• B. when returning to a point in time before the most recent OPEN RESETLOGS operation
• C. when undoing a shrink data file operation
• D. when returning to a point in time before the restoration or re-creation of a control file

Examine the initialization parameter that is set in the PFILE:
DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'
You execute the following command to create CDB1 container database (CDB):
SQL>CREATE DATABASE CDB1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE
temp
UNDO TABLESPACE
Undotbsl ENABLE
PLUGGABLE DATABASE SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE
UNLIMITED SYSAUX DATAFILES SIZE 100M;
Which three statements are true? (Choose three.)

• A. undotbs1 is used as the undo tablespace for both the root and seed databases.
• B. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
• C. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
• D. It creates a multitenant container database with the root database opened and the seed database mounted.
• E. The files created for both the root and seed databases use Oracle Managed Files (OMF).
• F. It sets the users tablespace as the default for both the root and seed databases.

Examine the RMAN commands executed in your database:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET;
RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
You issue the command:
RMAN> BACKUP DATABASE;
Which two statements are true about the command? (Choose two.)

• A. It backs up data files, the control file, and the server parameter file.
• B. It creates a backup of only the control file whenever the database undergoes a structural change.
• C. It performs a log switch.
• D. It creates compressed backup sets by using binary compression by default.
• E. It backs up only the used blocks in data files.

Your database is running in archivelog mode. Examine the parameters for your database instance:
LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY'
LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch'
LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch'
LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch'
LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.
What happens at the next log switch?

• A. The database instance hangs and the redo log files are not overwritten.
• B. The database instance is shutdown immediately.
• C. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
• D. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.