Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 351:

  ENCRYPT_TS is an encrypted tablespace that contains tables with data.

  Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

  A. The data is decrypted during SORT and JOIN operations.
  B. The data remains encrypted when it is read into memory.
  C. The data remains encrypted when it is stored in the redo logs.
  D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
  C. The data remains encrypted when it is stored in the redo logs.

• Question 352:

  Which three tasks can be performed using a duplicate database? (Choose three.)

  A. Testing the backup and recovery procedures
  B. Testing the upgrade of an Oracle database to a new release
  C. Testing the effect of an application changes on database performance
  D. Continuously updating archive log files from the target database to support failover
  A. Testing the backup and recovery procedures
  B. Testing the upgrade of an Oracle database to a new release
  C. Testing the effect of an application changes on database performance

• Question 353:

  Which steps are mandatory to enable Direct NFS?

  1.

  Mount all required file systems using the kernel NFS driver.

  2.

  Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.

  3.

  Replace the ODM library libodm11.so_stub with libodm11.so.

  A. 2 and 3
  B. 1 and 3
  C. 1 and 2
  D. 1, 2 and 3
  B. 1 and 3

• Question 354:

  Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:

  RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb; }

  Which statement is true about the duplicate database in this scenario?

  A. It contains data till the last backup
  B. It contains all data from target database until the current time
  C. It contains all data from only the committed transactions in the target database
  D. It contains all data except that which is used by the transactions in the current online redo file of target database
  D. It contains all data except that which is used by the transactions in the current online redo file of target database

• Question 355:

  You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).

  Identify two scenarios is which you must have a recovery catalog. (Choose two.)

  A. To store the backup information of multiple database
  B. To restrict the amount of space that is used by the backups
  C. To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
  D. To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.
  A. To store the backup information of multiple database
  D. To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

• Question 356:

  If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?

  A. The alter database archivelog command will fail.
  B. The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode.
  C. The alter database archivelog command will succeed.
  D. The alter database archivelog command will ask if you want to make the database consistent first.
  E. There is no alter database archivelog command. The correct command is alter database alterlogging.
  A. The alter database archivelog command will fail.

• Question 357:

  Consider the following command: backup database plus archivelog delete input;

  How many backup sets would be created by this command if the following were true:

  Control-file auto backups were enabled. The size of backup sets was not restricted. One channel was allocated.

  A. 1
  B. 2
  C. 3
  D. 4
  E. 5
  D. 4

• Question 358:

  Consider the following scenario for your database:

  Backup optimization is enabled in RMAN.

  The recovery window is set to 7 days in RMAN.

  The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.

  The TOOLS tablespace is read-only since November 4, 2007.

  On November 23, 2007, you issue the RMAN command to back up the database to disk.

  Which statement is true regarding the backup of the TOOLS tablespace?

  A. The RMAN backup fails because the TOOLS tablespace is read-only
  B. The RMAN skips the backup of the tablespace because backup optimization is enabled
  C. The RMAN makes backup because optimization can be enabled only for backups to disk
  D. The RMAN makes the backup because no backup of the tablespace exists within the seven day window
  D. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

• Question 359:

  Which of the following options describes Segment Shrink?

  A. Reclaims space above and below the high-water mark without using additional space
  B. Moves rows to a new physical location, resetting the high-water mark, but uses additional space during the operation
  C. Deallocates space above the high-water mark that is currently not in use
  D. None of the above
  A. Reclaims space above and below the high-water mark without using additional space

• Question 360:

  You executed the following command in Recovery Manager (RMAN):

  RMAN> REPORT NEED BACKUP days 3;

  What is the output of this command?

  A. a list of files that require a backup within three days
  B. a list of files requiring more than 3 days of archive logs to apply
  C. a list of files that RMAN recommends be backed up only once in every three days, based on low volatility
  D. a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
  B. a list of files requiring more than 3 days of archive logs to apply