Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 71:

  Identify three situations in which you would NOT be able to drop a tablespace. (Choose three.)

  A. when the tablespace is online
  B. when the tablespace has segments with data in it
  C. when the tablespace is a default permanent tablespace for the database
  D. when the tablespace contains a table that is currently being used by transactions
  E. when the tablespace contains undo data that is needed to rollback an uncommitted transaction
  C. when the tablespace is a default permanent tablespace for the database
  D. when the tablespace contains a table that is currently being used by transactions
  E. when the tablespace contains undo data that is needed to rollback an uncommitted transaction

• Question 72:

  You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the steps that will be performed later when you open the database:

  1.

  SGA is allocated.

  2.

  Control file is read.

  3.

  Redo log files are read.

  4.

  Instance recovery is started.

  5.

  Background processes are started.

  6.

  Data file headers are checked for consistency.

  7.

  Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur?

  A. 7, 1, 5, 2, 3, 6, 4
  B. 1, 2, 3, 7, 5, 6, 4
  C. 7, 1, 4, 5, 2, 3, 6
  D. 1, 7, 5, 4, 2, 3, 6
  A. 7, 1, 5, 2, 3, 6, 4

• Question 73:

  Which two statements are true regarding a tablespace? (Choose two.)

  A. It can span multiple databases
  B. It can consist of multiple data files
  C. It can contain blocks of different files
  D. It can contains segments of different sizes
  E. It can contains a part of nonpartitioned segment
  B. It can consist of multiple data files
  D. It can contains segments of different sizes

• Question 74:

  Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

  A. You cannot export data from a remote database.
  B. You can rename tables during an import operation.
  C. You can overwrite existing dump files during an export operation.
  D. You can compress the data during export but not the metadata because it is not supported.
  B. You can rename tables during an import operation.
  C. You can overwrite existing dump files during an export operation.

• Question 75:

  Which two are true about transactions, UNDO segments, and UNDO tablespaces? (Choose two.)

  A. UNDO segments grow or shrink automatically
  B. UNDO tablespaces are created and dropped automatically
  C. UNDO segments are created and dropped automatically
  D. UNDO tablespaces are brought ONLINE or OFFLINE as required
  E. All transactions belonging to a single session use the same UNDO segment
  A. UNDO segments grow or shrink automatically
  B. UNDO tablespaces are created and dropped automatically

• Question 76:

  You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be

  inserted as part of the same transaction.

  View the Exhibit to examine the commands used to create tables.

  Which action would you take to delay the referential integrity checking until the end of the transaction?

  Exhibit:

  

  A. Set the constraint to deferred before starting the transaction
  B. Alter the constraint to NOVALIDATE state before starting the transaction
  C. Enable the resumable mode for the session before starting the transaction
  D. Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction
  A. Set the constraint to deferred before starting the transaction

• Question 77:

  You executed the following command to create a password file in the database server:

  $ orapwd file = orapworcl entries = 5 ignorecase=N

  Which statement describes the purpose of the above password file?

  A. It records usernames and passwords of users when granted the DBA role
  B. It contains usernames and passwords of users for whom auditing is enabled
  C. It is used by Oracle to authenticate users for remote database administrator
  D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups
  C. It is used by Oracle to authenticate users for remote database administrator

• Question 78:

  Examine the following output:

  

  Which two statements about the above index are true? (Choose two.)

  A. It is ignored by the query optimizer.
  B. It is not used while the index is being rebuilt.
  C. The index cannot be rebuilt, and has to be re-created.
  D. The index is automatically rebuilt when used the next time.
  A. It is ignored by the query optimizer.
  B. It is not used while the index is being rebuilt.

• Question 79:

  View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings, respectively. Why are advisors not available for the shared pool and the buffer cache?

  09 (exhibit):

  

  10 (exhibit):

  

  A. because the DB_CACHE_ADVICE parameter is set to OFF
  B. because Automatic Memory Management (AMM) is disabled for the database instance
  C. because Automatic Shared Memory Management (ASMM) is enabled for the database instance
  D. because the values for the DB_CACHE_SIZE and SHARED_POOL_SIZE parameters were not set initially
  C. because Automatic Shared Memory Management (ASMM) is enabled for the database instance

• Question 80:

  The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users:

  CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2, v_mgr NUMBER, v_loc NUMBER)

  BEGIN

  INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc);

  END;

  The users having permission to execute the procedure are able to insert records into the DEPARTMENTS table even though they do not have the INSERT privilege on the table. You want only those users who have privileges on the

  DEPARTMENTS table to be able to execute the procedure successfully.

  What would you suggest to the PL/SQL developers to achieve this?

  A. Create the procedure with definer's right.
  B. Create the procedure with invoker's right.
  C. Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.
  D. Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users.
  B. Create the procedure with invoker's right.