Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 491:

  The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?

  A. The tape I/O performed is asynchronous
  B. The tape buffer is allocated from the System Global Area (SGA)
  C. The tape buffer is allocated from the Program Global Area (PGA)
  D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes
  C. The tape buffer is allocated from the Program Global Area (PGA)

• Question 492:

  You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;

  Which requirement must be fulfilled for this command to succeed?

  A. The tablespace must be locally managed.
  B. The tablespace must have only one temp file.
  C. The tablespace must be made nondefault and offline.
  D. The tablespace can remain as the default but must have no active sort operations.
  A. The tablespace must be locally managed.

• Question 493:

  Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?

  A. SQL Repair Advisor
  B. SQL Optimizer
  C. SQL Access Advisor
  D. SQL Tuning Advisor
  D. SQL Tuning Advisor

• Question 494:

  Examine the following PL/SQL block:

  DECLARE

  my_plans PLS_INTEGER;

  BEGIN

  my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE( sql_id => '99twu5t2dn5xd');

  END;

  /

  Which statement is true about the plan being loaded into the SQL plan baseline by the above command?

  A. It is loaded with the FIXED status.
  B. It is loaded with the ACCEPTED status.
  C. It is not loaded with the ENABLED status.
  D. It is not loaded with the ACCEPTED status.
  B. It is loaded with the ACCEPTED status.

• Question 495:

  When manually configuring the SGA, which of the following parameter changes requires an instance restart to take effect?

  A. DB_CACHE_SIZE
  B. SHARED_POOL_SIZE
  C. LARGE_POOL_SIZE
  D. JAVA_POOL_SIZE
  E. SGA_MAX_SIZE
  F. SORT_AREA_SIZE
  E. SGA_MAX_SIZE

• Question 496:

  Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member.

  When you attempt to start the database, you receive the following errors:

  ORA-00313: open failed for members of log group 1 of thread 1

  ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'

  You discover that the online redo log file of the current redo group is corrupted.

  Which statement should you use to resolve this issue?

  A. ALTER DATABASE DROP LOGFILE GROUP 1;
  B. ALTER DATABASE CLEAR LOGFILE GROUP 1;
  C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
  D. ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG';
  C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

• Question 497:

  Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?

  A. Segment Advisor
  B. SQL Access Advisor
  C. Undo Advisor
  D. SQL Tuning Advisor
  B. SQL Access Advisor

• Question 498:

  Evaluate the following code:

  

  What is the outcome of this block of code?

  A. It creates a task and workload, and executes the task.
  B. It creates a task and workload but does not execute the task.
  C. It produces an error because a template has not been created.
  D. It produces an error because the SQL Tuning Set has not been created.
  A. It creates a task and workload, and executes the task.

• Question 499:

  Before a Flashback Table operation, you execute the following command:

  ALTER TABLE employees ENABLE ROW MOVEMENT;

  Why would you need this to be executed?

  A. Because row IDs may change during the flashback operation
  B. Because the object number changes after the flashback operation
  C. Because the rows are retrieved from the recycle bin during the flashback operation
  D. Because the table is moved forward and back to a temporary during the flashback opertion
  A. Because row IDs may change during the flashback operation

• Question 500:

  Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)

  A. It creates jobs without considering the priorities associated with them.
  B. It translates tasks into jobs for execution by the scheduler.
  C. It determines the list of jobs that must be created for each maintenance window.
  D. It is spawned by the MMON background process at the start of the maintenance window.
  E. It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.
  B. It translates tasks into jobs for execution by the scheduler.
  C. It determines the list of jobs that must be created for each maintenance window.
  D. It is spawned by the MMON background process at the start of the maintenance window.