Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 231:

  Where is backup metadata stored for use by Recovery Manager (RMAN)?

  A. in the SYSTEM tablespace
  B. in the control file
  C. in the SPFILE
  D. in the SYSAUX tablespace
  E. in the diagnostic destination files
  B. in the control file

• Question 232:

  Your database instance is functional for the past one month. The Automatic Workload Repository (AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance of the database between 7 PM and 9 PM of the previous day. Choose two actions any of which can be referred to first to diagnose the problem. (Choose two.)

  A. Use the Active Session History report.
  B. Use the AWR Compare Periods report.
  C. Use an ADDM analysis between 7 PM and 9 PM of the previous day.
  D. Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.
  B. Use the AWR Compare Periods report.
  C. Use an ADDM analysis between 7 PM and 9 PM of the previous day.

• Question 233:

  Which statement is true about a whole consistent database backup on a database running in

  ARCHIVELOG mode?

  Exhibit:

  

  A. The backup will consist of used data blocks only.
  B. The database must be shut down to accomplish the backup.
  C. The backup can be accomplished without shutting down the database.
  D. The backup will contain all database files that have never been backed up.
  B. The database must be shut down to accomplish the backup.

• Question 234:

  The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?

  A. Inactive and current redo log files are required to accomplish recovery
  B. Online and archived redo files are required to accomplish instance recovery
  C. All redo log entries after the last checkpoint are applied from redo log files to data files
  D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files
  C. All redo log entries after the last checkpoint are applied from redo log files to data files

• Question 235:

  View the Exhibit and examine the PL/SQL package and procedure. You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body. Which statement is true after you recompile the EMP_ADMIN package body? Exhibit:

  

  A. The USE_P procedure remains valid.
  B. The USE_P procedure becomes invalid.
  C. The SHOW_DETAIL procedure becomes invalid.
  D. The EMP_ADMIN package specification becomes invalid and needs to be recompiled.
  A. The USE_P procedure remains valid.

• Question 236:

  User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command:

  SQL> SELECT ename FROM emp

  2 WHERE job='CLERK' FOR UPDATE OF empno;

  SCOTT has opened another session to work with the database instance.

  Which three operations would wait when issued in SCOTT's second session? (Choose three.)

  A. LOCK TABLE emp IN SHARE MODE;
  B. LOCK TABLE emp IN EXCLUSIVE MODE;
  C. UPDATE emp SET sal=sal*1.2 WHERE job='MANAGER'
  D. INSERT INTO emp(empno,ename) VALUES (1289,'Harry');
  E. SELECT ename FROM emp WHERE job='CLERK' FOR UPDATE OF empno;
  A. LOCK TABLE emp IN SHARE MODE;
  B. LOCK TABLE emp IN EXCLUSIVE MODE;
  E. SELECT ename FROM emp WHERE job='CLERK' FOR UPDATE OF empno;

• Question 237:

  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.
  B. The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.

• Question 238:

  You suspect unauthorized data manipulation language (DML) operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. You also plan to transfer these values to another table for analysis. How would you achieve this?

  A. by using triggers
  B. by using Data Pump
  C. by using external tables
  D. by using anonymous PL/SQL blocks
  A. by using triggers

• Question 239:

  View the Exhibits and examine lock waits. Users HR and SH complain that their transactions on one of the application tables, EMP, are waiting for response.

  Which action would you take to release the lock and enable users HR and SH to continue with their transactions?

  07 (exhibit):

  

  08 (exhibit):

  

  A. Kill the session of the user SCOTT with session ID118.
  B. Issue manual checkpoint using the ALTER SYSTEM command.
  C. Modify the profile used by user SCOTT to reduce the CONNECT_TIME limit.
  D. Flush the Shared Pool to remove the SQL statement causing "wait" in memory.
  A. Kill the session of the user SCOTT with session ID118.

• Question 240:

  You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the profile.

  Some user sessions are currently connected to the database instance and are using the APP_USER profile.

  This command is used to drop the profile:

  SQL> DROP PROFILE app_user;

  Which statement describes the result?

  A. The command produces an error.
  B. The profile is dropped and current user sessions use the DEFAULT profile immediately.
  C. The profile is dropped, the sessions are terminated, and the subsequent user sessions use the DEFAULT profile.
  A. The command produces an error.