Oracle 1Z0-055 Online Practice Questions and Exam Preparation

Oracle 1Z0-055 Online Questions & Answers

• Question 31:

  Examine the following PL/SQL block:

  

  Which statement describes the effect of the execution of the above PL/SQL block?

  A. The plan baseline are verified with the SQL profiles
  B. All fixed plan baselines are converted into nonfixed plan baselines
  C. All the nonaccepted SQL profiles are accepted into the plan baseline
  D. The nonacccepted plans in the SQL Management Base are verified with the existing plan baselines
  D. The nonacccepted plans in the SQL Management Base are verified with the existing plan baselines

• Question 32:

  Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)

  A. Flashback query
  B. Distributed transactions
  C. Logging in and logging out of sessions
  D. All DDL statements having bind variables
  E. Direct path load of data from external files
  C. Logging in and logging out of sessions
  D. All DDL statements having bind variables

• Question 33:

  Which two statements regarding the Flashback Table feature are correct? (Choose two.)

  A. Flashback Table can be performed on system tables
  B. Flashback Table operation does not shrink the segments
  C. Flashback table uses log mining to extract SQL_REDO and SQL_UNDO statements
  D. Flashback Table operation acquires exclusive manipulation language (DML) locks
  B. Flashback Table operation does not shrink the segments
  D. Flashback Table operation acquires exclusive manipulation language (DML) locks

• Question 34:

  See the Exhibit to examine a portion of the output from the VALDIATE DATABASE command.

  

  Which statement is true about the block corruption detected by the command?

  A. No action is taken except the output in the exhibit
  B. The corruption is repaired by the command implicitly
  C. The failure is logged into the Automatic Diagnostic Repository (ADR)
  D. The ADVISE FAILURE command is automatically called to display the repair script
  C. The failure is logged into the Automatic Diagnostic Repository (ADR)

• Question 35:

  You are using Recovery Manager(RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)

  A. You are backing up to tape and your tape device performs its own compression
  B. You are making image copies and you have not enabled tablespace compression
  C. You are using disk-based backups and disk space in you Flash Recovery Area or other disk-based backup destinations are limited
  D. You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage
  E. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage
  C. You are using disk-based backups and disk space in you Flash Recovery Area or other disk-based backup destinations are limited
  D. You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage
  E. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage

• Question 36:

  You executed the followingcommands:

  

  Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

  A. The statistics are stored in the pending statistics table in the data dictionary
  B. The statistics are treated as the current statistics by the optimizer for all sessions
  C. The statistics are treated as the current statistics by the optimizer for the current sessions only
  D. The statistics are temporary and used by the optimizer for all sessions until this sessions terminates
  A. The statistics are stored in the pending statistics table in the data dictionary

• Question 37:

  Your database initialization parameter file has the following entry:

  SEC_MAX_FAILED_LOGIN_ATTEMPTS=3

  Which statement is true regarding this setting?

  A. It is enforced only if the password profile is enabled for the user
  B. It locks the user account after the specified number of attempts
  C. It drops the connection after the specified number of login attempts fail for any user
  D. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege
  C. It drops the connection after the specified number of login attempts fail for any user

• Question 38:

  Which two statements are true regarding table compression? (Choose two.)

  A. It requires uncompress operation during I/O
  B. It saves disk space and reduces memory usage
  C. It saves disk space but has no effect on memory usage
  D. It incurs extra CPU overhead during DML but not direct loading operations
  E. In incurs extra CPU overhead during DML as well as direct loading operations
  B. It saves disk space and reduces memory usage
  E. In incurs extra CPU overhead during DML as well as direct loading operations

• Question 39:

  You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2.

  The SALES table has a materialized view, materialized log, indexes, referential integrity constraint and triggers with the PRECEDES clause existing on it.

  What action is required for dependent objects when you perform online table redefinition?

  A. The materialized log should be dropped before the online table redefinition process
  B. Triggers with the PRECEDES clause should be disabled before the online table redefinition process
  C. Referential integrity constraints must be manually enabled after the online table redefinition process
  D. The dependent materialized view should have a complete refresh performed after the online table redefinition process
  D. The dependent materialized view should have a complete refresh performed after the online table redefinition process

• Question 40:

  See the Exhibit:

  

  As shown in the program, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?

  A. CKPT
  B. SMON
  C. MMON
  D. DBWR
  C. MMON