Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 241:

  To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:

  

  The blocks of code execute successfully; however, you do not get the required outcome.

  What could be the reason?

  A. A template needs to be associated with the task.
  B. A workload needs to be associated with the task.
  C. The partial or complete workload scope needs to be associated with the task.
  D. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.
  B. A workload needs to be associated with the task.

• Question 242:

  What will be the end result of this set of RMAN commands?

  shutdown abort

  startup mount

  restore datafile 4 until time '09/30/2008:15:00:00';

  recover datafile 4 until time '09/29/2008:15:00:00';

  alter database open resetlogs;

  A. Datafile 4 will be recovered until 9/30/2008 at 15:00 and the database will open.
  B. The restore command will fail.
  C. The recover command will fail.
  D. The alter database open resetlogs command will fail.
  E. All these commands will fail because they must be in the confines of a run block.
  D. The alter database open resetlogs command will fail.

• Question 243:

  Over the course of a day, a department performed multiple DML statements (inserts, updates, deletes) on multiple rows of data in multiple tables. The manager would like a report showing the time, table name, and DML type for all changes that were made.

  Which Flashback technology would be the best choice to produce the list?

  A. Flashback Drop
  B. Flashback Query
  C. Flashback Transaction Query
  D. Flashback Versions Query
  E. Flashback Table
  C. Flashback Transaction Query

• Question 244:

  You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control- file autobackups. Which files are not backed up during the RMAN backup?

  A. Database Datafiles
  B. Database Control Files
  C. Online redo logs
  D. Archived redo logs
  E. The database SPFILE
  F. None of the above, all these files are backed up.
  C. Online redo logs

• Question 245:

  View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions:

  RMAN> BACKUP DATABASE FILESPERSET 2;

  The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?

  Exhibit:

  

  A. Because the progress is reported for each data file
  B. Because the progress is reported for each backup set
  C. Because other RMAN sessions have issued the same BACKUP command
  D. Because new data files have been added to the database while the RMAN backup is in progress
  B. Because the progress is reported for each backup set

• Question 246:

  For which of the following can you use Segment Shrink? (Choose all that apply.)

  A. Heap tables
  B. Tables with function-based indexes
  C. Indexes
  D. Partitions and subpartitions
  E. None of the above
  A. Heap tables
  C. Indexes
  D. Partitions and subpartitions

• Question 247:

  You have the following requirements in relation to the detection of block corruption for your database instance:

  Check for logical self-consistency of data blocks when modified in memory.

  Checksums are calculated before and after the block change.

  Checks are performed for the lost writes to the physical standby database.

  Which method would help you perform the above checks automatically?

  A. Set the DB_SECUREFILE parameter to PERMITTED.
  B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY.
  C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL.
  D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL.
  B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY.

• Question 248:

  What are the different logging modes available in Oracle Database 11g? (Choose two.)

  A. NOLOG mode
  B. NOARCHIVELOG mode
  C. LOGGING mode
  D. HOTDATABASE mode
  E. ARCHIVELOG mode
  B. NOARCHIVELOG mode
  E. ARCHIVELOG mode

• Question 249:

  Given the following steps, which would be the correct order to create a backup of an Oracle database in ARCHIVELOG mode with control-file autobackups enabled?

  a.

  backup archivelog all;

  b.

  backup database all;

  c.

  backup controlfile;

  d.

  backup archivelog, database, controlfile delete input;

  e.

  backup database plus archivelog delete input

  A. e
  B. a, b, a, c
  C. d
  D. b, a, c
  E. b, a, c, d, e
  A. e

• Question 250:

  Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?

  A. Create new indexes.
  B. Modify existing indexes.
  C. Implement partitioning on a nonpartitioned table.
  D. Create materialized views.
  E. All of the above
  E. All of the above