1z0-067 무료 덤프문제 온라인 액세스

Examine these parameter values:

There are currently no user defined tablespaces with an 8K or 16K blocksize.
Which statement would return an error?

• A.ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
• B.ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
• C.ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;
• D.ALTER SYSTEM SET DB_CACHE_SIZE=50M;
• E.ALTER SYSTEM SET DB_16K_CACHE_SIZE=0;

For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY
DATABASE;
Which statement is true about the execution of the command?

• A.It performs a backup as a backup set of all data files including those that belong to the new tablespace.
• B.It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.
• C.It performs an image copy backup of all data files including those that belong to the new tablespace.
• D.It returns an error because there is no level 0 backup available for new data files.
• E.It performs a level-0 backup of all data files including those that belong to the new tablespace.

Examine the command used to perform an incremental level-0 backup:
RMAN>BACKUP INCREMENTAL LEVEL0 DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command:
SQL>ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING
FILE'/mydir/rman_change_track.f';
To perform an incremental level-1 cumulative backup, you issue the command:
RMAN>BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;
Which two statements are true in the preceding situation?

• A.The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level
  0 backup.
• B.The incremental level 1 backup does not use change tracking data for accomplishing the backup.
• C.The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.
• D.The block change tracking data is used only from the next incremental backup.
• E.The block change tracking data is used for the next incremental level 1 backup only after the next level
  0 backup.

Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required?

• A.All the control files are missing.
• B.A data file belonging to a noncritical tablespace is missing.
• C.All the data files are missing.
• D.The database backup is older than the control file backup.
• E.The current online redo log file is missing.

What two are the prerequisites for enabling Flashback Database?

• A.The database must be in MOUNT EXCLUSIVE mode
• B.The database must be in ARCHIVELOG mode
• C.The database instance must have the keep buffer pool defined
• D.The database must be opened in RESTRICTED mode
• E.The database instance must be started in the NOMOUNT state