Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 691:

  What does it mean if a backup is expired?

  A. The backup set has exceeded the retention criteria set in RMAN and is eligible for removal.
  B. The backup set has one or more invalid blocks in it and is not usable for recovery.
  C. The backup set contains one or more tablespaces no longer in the database.
  D. The backup set contains one or more missing backup set pieces.
  E. The backup set is from a previous version of RMAN and was not upgraded.
  D. The backup set contains one or more missing backup set pieces.

• Question 692:

  Your database has experienced a loss of datafile users_01.dbf, which is associated with a tablespace called USERS. The database is still running. Which answer properly describes the order of the steps that you would use to recover from this error?

  1.

  Shut down the database.

  2.

  Take the users_01.dbf datafile offline with the alter database command.

  3.

  Restore the users_01.dbf datafile from backup media with the required archived redo logs.

  4.

  Restore all users tablespace-related datafiles from backup media.

  5.

  Issue the recover tablespace users command.

  6.

  Issue the recover datafile users_01.dbf command.

  7.

  Start up the database.

  8.

  Bring the users_01.dbf datafile online with the alter database command.

  A. 1, 3, 6, 7
  B. 2, 3, 6, 8
  C. 1, 2,3,6,7
  D. 1, 2, 3, 6, 7, 8
  E. 2, 3,6,5,7
  B. 2, 3, 6, 8

• Question 693:

  View the following SQL statements: Transaction T1

  SQL> INSERT INTO hr.regions 2 VALUES (5,'Pole'); 3 COMMIT;

  Transaction T2

  SQL> UPDATE hr.regions 2 SET region_name='Poles' 3 WHERE region_id = 5; 4 COMMIT;

  Transaction T3

  SQL> UPDATE hr.regions 2 SET region_name='North and South Poles' 3 WHERE region_id = 5;

  You want to back out transaction T2.

  Which option would you use?

  A. It is possible, but transaction T3 also backs out.
  B. It is possible with the NOCASCADE_FORCE option.
  C. It is possible with the NONCONFLICT_ONLY option.
  D. It is not possible because it has conflicts with transaction T3.
  B. It is possible with the NOCASCADE_FORCE option.

• Question 694:

  Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablspace. A user issues a query on the ORDERS table and receives the following

  error:

  ERROR at line 1:

  ORA-01565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp' ORA-27037: unable to obtain file status

  What would be the most efficient way to rectify this error? ##

  A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.
  B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
  C. Allow the database to continue running, drop the temp01.tmp temporary file, and then re- create it with new tempfiles.
  D. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.
  A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.

• Question 695:

  Which of the following are prerequisite steps to transport a database? (Choose all that apply.)

  A. Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine if the intended destination is listed.
  B. Verify that there are no restrictions or limitations that the source or destination database may encounter.
  C. Verify that the source and destination have the same Oracle version, critical updates, patch-set version, and patch- set exceptions.
  D. Determine if you will perform the conversion on the source or destination platform.
  E. None of the above.
  A. Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine if the intended destination is listed.
  B. Verify that there are no restrictions or limitations that the source or destination database may encounter.
  D. Determine if you will perform the conversion on the source or destination platform.

• Question 696:

  What is the purpose of the list expired backup command?

  A. Lists all backups impacted by a resetlogs command
  B. Lists all backups that are subject to retention criteria
  C. Lists all backups that are missing associated physical backup set pieces
  D. Lists the status of datafile backup failures due to the use of the duration command
  E. Lists backups that cannot be used by the restore command because they have been marked as disabled
  C. Lists all backups that are missing associated physical backup set pieces

• Question 697:

  Which method could be utilized to identify both DML operations and the SQL statements needed to undo those operations for a specific schema owner? (Choose all that apply.)

  A. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows by START_SCN and TABLE_OWNER.
  B. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows by START_SCN and TABLE_OWNER.
  C. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows by START_TIMESTAMP and TABLE_OWNER.
  D. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows by START_TIMESTAMP and TABLE_OWNER.
  B. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows by START_SCN and TABLE_OWNER.
  C. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows by START_TIMESTAMP and TABLE_OWNER.

• Question 698:

  What command would you issue to enable automated backups of control files?

  A. alter database controlfile autobackup on
  B. alter system controlfile autobackup on
  C. configure controlfile autobackup on
  D. enable controlfile autobackup
  C. configure controlfile autobackup on