Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 321:

  In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file.

  Which option must you consider for this task?

  A. using only the RMAN SWITCH command to set the new location for the data file
  B. placing the database in the MOUNT state for the restore and recovery operations.
  C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
  D. configuring two channels: one for the restore operation and the other for the recovery operation
  C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

• Question 322:

  You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.

  You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table:

  SQL> SELECT object_name, original_name, droptime FROM recyclebin;

  

  What would be the outcome of the precedent statement?

  A. It retrieves the latest version of the table from the recycle bin
  B. It retrieves the oldest version of the table from the recycle bin
  C. It retrieves the version of the table for which undo information is available
  D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column
  A. It retrieves the latest version of the table from the recycle bin

• Question 323:

  You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB. You issued the following RMAN commands to create a duplicate database:

  

  Which three are the prerequisites for the successful execution of the above command? (Choose three.)

  A. The source database should be open.
  B. The target database should be in ARCHIVELOG mode if it is open.
  C. RMAN should be connected to both the instances as SYSDBA.
  D. The target database backups should be copied to the source database backup directories.
  E. The password file must exist for the source database and have the same SYS user password as the target.
  B. The target database should be in ARCHIVELOG mode if it is open.
  C. RMAN should be connected to both the instances as SYSDBA.
  E. The password file must exist for the source database and have the same SYS user password as the target.

• Question 324:

  While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?

  A. The backup fails because one of the archived redo log files is missing.
  B. The backup succeeds but it would be without the missing archived log.
  C. During backup, you are prompted for the alternative destination for the missing archived redo log file.
  D. The backup succeeds because it fails over to one of the alternative archived redo log destinations.
  D. The backup succeeds because it fails over to one of the alternative archived redo log destinations.

• Question 325:

  Which of the following statements best describes Flashback Versions Query?

  A. Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.
  B. Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.
  C. Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.
  D. Flashback Versions Query is used to view all version changes on rows that existed between two points in time.
  D. Flashback Versions Query is used to view all version changes on rows that existed between two points in time.

• Question 326:

  The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted.

  What steps should you take to recover from this tempfile loss in an efficient manner?

  A. Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles
  B. Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS
  C. Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile
  D. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
  D. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.

• Question 327:

  How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has NOT yet completed?

  A. Issue the ALTER DISKGROUP ... ADD DISK command.
  B. Issue the ALTER DISKGROUP ... UNDROP DISKS command.
  C. Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.
  D. Retrieve the disk from the Recycle Bin after the operation completes.
  B. Issue the ALTER DISKGROUP ... UNDROP DISKS command.

• Question 328:

  In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.

  Which method must you use to recover the lost data?

  A. Complete Recovery with online redo log
  B. Complete Recovery with archived redo log
  C. Tablespace Point-in-Time Recovery (TSPITR)
  D. Incomplete Recovery with system change number (SCN)
  C. Tablespace Point-in-Time Recovery (TSPITR)

• Question 329:

  What is the proper command to shut down the database in a consistent manner?

  A. shutdown abort
  B. shutdown kill
  C. shutdown nowait
  D. shutdown immediate
  E. shutdown halt
  D. shutdown immediate

• Question 330:

  Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?

  A. only encryption and compression settings for all SecureFile LOBs
  B. only encryption and deduplication settings for only SecureFile CLOBs
  C. deduplication, encryption, and compression settings for all SecureFile LOBs
  D. deduplication, encryption, and compression settings only for SecureFile CLOBs
  C. deduplication, encryption, and compression settings for all SecureFile LOBs