Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 261:

  When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? (Choose two.)

  A. It produces less accurate results of the comparison analysis.
  B. It automatically calls the SQL Tuning Advisor for recommendations.
  C. It shortens the time of execution and reduces the impact on system resources.
  D. Only the changes in the execution plan, and not performance regression, are detected.
  A. It produces less accurate results of the comparison analysis.
  C. It shortens the time of execution and reduces the impact on system resources.

• Question 262:

  You observed the following output for a user session:

  

  What do you infer from the preceding output?

  A. Resumable set for session with sid 18
  B. The user session has entered into a deadlock
  C. The database instance is enabled to use asynchronous commit
  D. The threshold warning limit is exceeded for the tablespace that is used by the user session
  A. Resumable set for session with sid 18

• Question 263:

  What is the default value for the ENABLED attribute of a job or program when it is created?

  A. TRUE
  B. FALSE
  C. There is no default. It must be defined at creation time.
  D. PENDING
  E. NULL
  B. FALSE

• Question 264:

  What view might you use to try to determine how long a particular backup will take?

  A. V$SESSION_EVENT
  B. V$SESSION
  C. V$WAITS
  D. V$WAITSTAT
  E. V$SESSION_LONGOPS
  E. V$SESSION_LONGOPS

• Question 265:

  True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.

  A. True
  B. False
  B. False

• Question 266:

  You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this?

  A. MAXSETSIZE TO 2;
  B. DEVICE TYPE DISK PARALLELISM 2;
  C. RETENTION POLICY TO REDUNDANCY 2;
  D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
  D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

• Question 267:

  Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURES_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression a few SQL statements.

  What would you do with these SQL statements?

  A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
  B. Capture the plans from the previous version using STS and then load them into the stored outline.
  C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).
  D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
  C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).

• Question 268:

  You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?

  A. Mount the database
  B. Open the database in NORMAL mode
  C. Open the database in RESTRICTED mode
  D. Open the database with the RESETLOGS option
  A. Mount the database

• Question 269:

  Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all that apply.)

  A. SET_ATTRIBUTE_NULL
  B. ALTER_JOB
  C. ALTER_JOB_PARAMETERS
  D. ALTER
  E. SET_ATTRIBUTE
  A. SET_ATTRIBUTE_NULL
  E. SET_ATTRIBUTE

• Question 270:

  Which of the following supplied functions is used to identify external tables, directories, and BFILES?

  A. DBMS_TDB.CHECK_DIRECTORIES
  B. DBMS_TDB.CHECK_EXTERNAL
  C. DBMS_TDB.CHECK_BFILE
  D. DBMS_TDB.CHECK_EXT
  B. DBMS_TDB.CHECK_EXTERNAL