Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 671:

  When running the tablespace point-in-time command

  recover tablespace users

  until time '10/06/2008:22:42:00'

  auxiliary destination 'c:\oracle\auxiliary';

  You receive the following error:

  

  What is the likely cause of the error?

  A. The database is in ARCHIVELOG mode.
  B. There is not a current backup of the database available.
  C. The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.
  D. The USERS tablespace is not eligible for TSPITR because it has invalid objects.
  E. The recover tablespace command is incorrect and generates the error.
  B. There is not a current backup of the database available.

• Question 672:

  You enabled Flashback Data Archive on the INVENTORY table.

  Which DDL operation is supported on the table after enabling Flashback Data Archive?

  A. Drop the table.
  B. Partition the table
  C. Truncate the table.
  D. Add a column to the table.
  E. Rename a column in the table.
  D. Add a column to the table.

• Question 673:

  What does the minimize load database parameter mean when backing up a database?

  A. RMAN will attempt to make the backup run as fast as possible without any IO limitations.
  B. RMAN will automatically restrict the number of channels in use to one.
  C. RMAN will spread the backup IO over the total duration stated in the backup command.
  D. RMAN will skip any datafile that currently is involved in an IO operation. RMAN will retry backing up the datafile later and an error will be raised at the end of the backup if the datafile cannot be backed up.
  E. Datafiles will be backed up; those having the lowest current number of IO operations will be backed up first.
  C. RMAN will spread the backup IO over the total duration stated in the backup command.

• Question 674:

  Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)

  A. It does not allow you to change the moving window size.
  B. Adaptive threshold functionalities use it by default to compute statistics.
  C. It is created by default with the window size being equal to the AWR retention time.
  D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
  B. Adaptive threshold functionalities use it by default to compute statistics.
  C. It is created by default with the window size being equal to the AWR retention time.

• Question 675:

  View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks. You executed the following commands:

  SQL> VAR tname VARCHAR2(60);

  SQL> BEGIN

  :tname := 'my_instance_analysis_mode_task';

  DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(:tname,'Sg_directive','SCOTT'); END;

  Which statement describes the consequence?

  Exhibit:

  

  A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
  B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.
  C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.
  D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
  C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.

• Question 676:

  To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?

  A. EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor
  B. EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor
  C. EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor
  D. Either B or C
  E. All of the above
  D. Either B or C

• Question 677:

  What is the purpose of the RMAN recovery catalog? (Choose all that apply.)

  A. It must be used because all RMAN-related backup and recovery metadata information is contained in it.
  B. It provides a convenient, optional, repository of backup- and recovery-related metadata.
  C. It provides the ability to store RMAN scripts for global use by any database that has access to the repository.
  D. It provides a means of storing all RMAN backup sets physically in an Oracle database server.
  E. It provides the ability to store backup records for more than a year.
  B. It provides a convenient, optional, repository of backup- and recovery-related metadata.
  C. It provides the ability to store RMAN scripts for global use by any database that has access to the repository.
  E. It provides the ability to store backup records for more than a year.

• Question 678:

  How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already 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.
  A. Issue the ALTER DISKGROUP ... ADD DISK command.

• Question 679:

  The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database.

  Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future.

  What would you do?

  A. Create two custom ADDM tasks.
  B. Modify the AWR snapshot time interval to two hours.
  C. Create a new scheduler window for a time period of two hours.
  D. Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
  B. Modify the AWR snapshot time interval to two hours.

• Question 680:

  You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command:

  ASMCMD> lsdsk -I -d DATA

  Which statement is true regarding the outcome of this command?

  A. The command succeeds but it retrieves only the disk names.
  B. The command produces an error because the ASM instance is down.
  C. The command succeeds but it shows only the status of the ASM instance.
  D. The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.
  D. The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.