Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 281:

  As part of archiving the historical data, you want to transfer data from one database to another database, which is on another server. All tablespaces in the source database are read/write and online. The source and target databases use the same compatibility level and character sets. View the Exhibit and examine the features in the source and target database.

  Which of the following steps are required to transport a tablespace from the database to the target database:

  1.

  Make the tablespace read-only at the source database.

  2.

  Export metadata from the source database.

  3.

  Convert data filed by using Recovery Manager (RMAN).

  4.

  Transfer the dump file and data filed to the target machine.

  5.

  Import metadata at the target database.

  6.

  Make the tablespace read/write at the target database.

  Exhibit: A. 2, 4, and 5

  

  B. All the steps
  C. 2, 3, 4 and 5
  D. 1, 2, 4, 5 and 6
  D. 1, 2, 4, 5 and 6

• Question 282:

  You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command:

  RMAN> CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS;

  After configuring the recovery window, you performed the database backup as follows:

  A. Backup RB1 at log sequence number 12871 on 5th Jan
  B. Backup RB2 at log sequence number 15622 on 12th Jan
  C. Backup RB3 at log sequence 16721 on 15th Jan
  D. On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all archived redo log files to date.
  D. On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all archived redo log files to date.

• Question 283:

  If a backup is expired, which of the following is true?

  A. It can never be used for a restore/recover operation.
  B. Oracle will remove the backup set pieces from the flash recovery area.
  C. The backup has been used at least once to restore and recover the database.
  D. The backup is no longer valid because of a resetlogs operation.
  E. The physical backup set pieces are missing from the media.
  E. The physical backup set pieces are missing from the media.

• Question 284:

  View the Exhibit to examine the error obtained during the I/O calibration process. There are no data files on raw devices. What is the reason for this error?

  

  A. The DISK_ASYNCH_IO parameter is set to TRUE.
  B. The FILESYSTEMIO_OPTIONS parameter is set to NONE.
  C. Another session runs the I/O calibration process concurrently.
  D. The pending area has not been created before running the I/O calibration process.
  B. The FILESYSTEMIO_OPTIONS parameter is set to NONE.

• Question 285:

  Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?

  A. Automatic PGA Memory Management
  B. Automatic SGA Memory Management
  C. Automatic Shared Memory Management
  D. Automatic Memory Management
  E. Manual SGA Memory Management
  F. None of the above
  D. Automatic Memory Management

• Question 286:

  Which of the following restrictions are NOT true with respect to tablespace point-in-time recovery? (Choose all that apply.)

  A. The target database must be in NOARCHIVELOG mode.
  B. No backup is required of the database before you perform a TSPITR.
  C. You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
  D. If you rename a tablespace, you can not perform a TSPITR to any point in time before that rename operation occurred.
  E. If you have tables in tablespace_1 that have associated constraints in tablespace_2, then you must transport both tablespaces.
  A. The target database must be in NOARCHIVELOG mode.
  B. No backup is required of the database before you perform a TSPITR.

• Question 287:

  You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.

  You execute the following statement:

  FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;

  What will be the result of executing this statement?

  A. One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
  B. One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
  C. Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
  D. None of the tables are recovered from the Recycle Bin, and the statement returns an error.
  B. One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.

• Question 288:

  Which command do you use to generate a report of database incarnations?

  A. list incarnation of database
  B. report incarnation of database
  C. list database incarnation
  D. database incarnation list
  E. report database incarnation
  A. list incarnation of database

• Question 289:

  Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?

  A. It cannot be done in parallel.
  B. It can be done at the table level or partition level.
  C. It does not require additional storage because the operation is done online.
  D. Local and global indexes are maintained automatically during the operation.
  B. It can be done at the table level or partition level.

• Question 290:

  You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur?

  A. The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.
  B. The job affinity is to a service and one node in that service is unavailable.
  C. The job affinity is to an instance and that instance is unavailable.
  D. There is no service affinity.
  E. None of the above.
  C. The job affinity is to an instance and that instance is unavailable.