Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 71:

  Which two statements are true regarding transactions in an Oracle database? (Choose two.)

  A. Multiple transactions can use the same undo segment.

  B. A transaction is assigned an undo segment when it is started.

  C. More than one transaction cannot share the same extent in the undo tablespace.

  D. The transactions use system undo segment to store undo data if all the segments in the undo tablespace are used.

  Correct Answer: AB

• Question 72:

  View the Exhibit1, which shows the options that are selected to create the user SL_REP.

  View the Exhibit2 and examine the contents of DATABASE_PROPERTIES.

  Which two statements are true regarding this user? (Choose two.)

  Exhibit1 (exhibit):

  

  Exhibit2 (exhibit):

  

  A. The user is authenticated by the operating system.

  B. The objects created by the user are placed in the USERS tablespace.

  C. The user does not require quota on the TEMP tablespace to perform sort operations.

  D. The user is forced to change the password at the first login to the database instance.

  E. The objects created by the user in future are unlocked to be accessed by all the users in the database by default.

  Correct Answer: BC

• Question 73:

  Which statement is true about the Manageability Monitor (MMON) background process?

  A. It transfers statistics from memory to disk at regular intervals.

  B. It coordinates the rebalance activity for disk groups when ASM is used.

  C. It communicates with the Automatic Storage Management (ASM) instance on behalf of the database instance.

  D. It performs dynamic memory management when Automatic Shared Memory Management is enabled for the database instance.

  Correct Answer: A

• Question 74:

  Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)

  A. It can be increased up to the value of the SGA_MAX_SIZE parameter.

  B. Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.

  C. Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and manually sized components.

  D. Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared memory management feature.

  Correct Answer: AB

• Question 75:

  Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)

  A. Recover from failures in the RAC environment.

  B. Diagnose and repair a data file corruption online.

  C. Diagnose and repair a data file corruption offline.

  D. Diagnose and repair failures on a standby database.

  Correct Answer: AD

• Question 76:

  Which three operations require undo data? (Choose three.)

  A. Committing a transaction

  B. Flashing back a transaction

  C. Recovering a failed transaction

  D. Running a read-consistent query

  E. Changing a tablespace status from READ ONLY to READ WRITE

  Correct Answer: BCD

• Question 77:

  Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?

  A. Host naming method

  B. Local naming method

  C. External naming method

  D. Directory naming method

  Correct Answer: B

• Question 78:

  A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled.

  What are the two effects of this command? (Choose two.)

  A. It fails if any existing row violates the constraint.

  B. It does not validate the existing data in the table.

  C. It enables the constraint to be enforced at the end of each transaction.

  D. It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.

  Correct Answer: AD

• Question 79:

  View the Exhibit and examine the user information.

  The user has been granted CONNECT and RESOURCE roles and no individual system privileges. The

  SL_REP user executes this command to create a table:

  SQL> CREATE TABLE orders (

  oid number(6),

  odate date,

  ccode number(4),

  oamt number(10,2)

  ) TABLESPACE purchase_space;

  The PURCHASE_SPACE tablespace already exists in the database.

  Which statement describes the effect of the command?

  Exhibit: A. The command executes successfully and creates the table in the USERS tablespace.

  

  B. The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.

  C. The command produces an error because the user does not have the privilege to createthe table.

  D. The command produces an error because the user does not have quota in the PURCHASE_SPACE tablespace.

  Correct Answer: B

• Question 80:

  You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to the point of failure. Which configuration will you do to accomplish the task?

  A. Multiplex all database files.

  B. Configure the Flash Recovery Area.

  C. Configure the database instance for ARCHIVELOG mode.

  D. Configure the FAST_START_MTTR_TARGET initialization parameter.

  Correct Answer: C