Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 111:

  All the database users are presently connected to the database instance and working. The HR user has opened three database sessions and executed the following command in one of his sessions:

  SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';

  123 rows updated.

  SQL> DELETE FROM persons WHERE exp='Y';

  3 rows deleted.

  The SYS user opens a new session after HR executed the above commands.

  Which sessions can see the effect of the UPDATE and DELETE commands?

  A. All sessions of the HR user only
  B. All sessions of the HR user and the SYS user
  C. The session of the HR user that executed the commands
  D. All the sessions for which the database users have access privilege to the PERSONS table
  C. The session of the HR user that executed the commands

• Question 112:

  Your database instance is running. db01 is a net service name. You issue a connection request using the following command:

  SQL> CONNECT scott/tiger@db01

  Which component receives the request and establishes the appropriate connection?

  A. listener
  B. user process
  C. service name
  D. server process
  A. listener

• Question 113:

  Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?

  A. The DML operations re-create the bitmap index blocks
  B. The bitmap index is rebuilt automatically after a DML operation
  C. The smallest amount of a bitmap that can be locked is a bitmap segment
  D. Additional time is taken to remove NULL values from the bitmap index after a DML operation
  C. The smallest amount of a bitmap that can be locked is a bitmap segment

• Question 114:

  To make audit information more productive, the DBA executes the following command before starting an audit operations:

  SQL>ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;

  Which statement is true regarding the audit record generated when auditing starts after restarting the database?

  A. It contains only the plan for the SQL statement executed by the user
  B. It contains the SQL text executed by the user and the bind variables used with it
  C. It contains the plan and statistics associated with the SQL statement executed by the user
  D. It contains the plan for the SQL statement executed by the user and the bind variables used with it
  B. It contains the SQL text executed by the user and the bind variables used with it

• Question 115:

  Which tablespaces are mandatory in an Oracle database for it to be operational? (Choose all that apply.)

  A. Undo tablespace
  B. USERS tablespace
  C. SYSAUX tablespace
  D. SYSTEM tablespace
  E. Temporary tablespace
  C. SYSAUX tablespace
  D. SYSTEM tablespace

• Question 116:

  SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command?

  A. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT
  B. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users
  C. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session
  D. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully
  E. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT
  C. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session

• Question 117:

  Which is true about external tables?

  A. The ORACLE_DATAPUMP access driver can be used to load data into external tables
  B. They do not support partitioning
  C. Segments are allocated for external tables
  D. DML operations may be performed on external tables
  E. They may have indexes
  A. The ORACLE_DATAPUMP access driver can be used to load data into external tables

• Question 118:

  Identify the memory component from which memory may be allocated for:

  Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations

  A. Large Pool
  B. Redo Log Buffer
  C. Database Buffer Cache
  D. Program Global Area (PGA)
  A. Large Pool

• Question 119:

  These are points that describe the contents of different memory components:

  1: Descriptive information or metadata about schema objects that are queried by using SQL statements

  2: The runtime area for data manipulation language (DML) or data definition language (DDL) statements

  3: Results of SQL queries and PL/SQL functions

  4: Executable forms of SQL cursors, PL/SQL programs, and Java classes

  5:

  The information necessary to reconstruct changes made to the database by a transaction Which of these will be stored in the Shared Pool if the necessary configurations are done?

  A. 1 and 2
  B. 2 and 5
  C. 1,3, and 4
  D. 3,4 and 5
  E. 1,2,3 and 4
  C. 1,3, and 4

• Question 120:

  Your database instance is in the open state with uncommitted transactions. You plan to execute these commands:

  

  Which is true about the STARTUP command?

  A. It performs an instance recovery before opening the database in read/write mode
  B. It performs an instance recovery and leaves the database instance in mount state
  C. It opens the database in read-only mode
  D. It opens the database in read/write mode only if an spfile is used
  C. It opens the database in read-only mode