Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 1:

  Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to tape drive fast enough.

  What could be a solution to make streaming happen during the backup?

  A. Configure backup optimization
  B. Configure the channel to increase MAXOPENFILES
  C. Configure the channel to increase the capacity with the RATE parameter
  D. Configure the channel to adjust the tape buffer size with the BLKSIZE option
  D. Configure the channel to adjust the tape buffer size with the BLKSIZE option

• Question 2:

  Your database is open in read/write mode and multiple users are connected to the database instance.

  You execute the following command:

  SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

  What would be the effect on current sessions?

  A. They are not terminated but may only issue queries.
  B. They are not affected.
  C. They are terminated immediately.
  D. They are terminated after completing the transaction.
  B. They are not affected.

• Question 3:

  Examine these statements: Which two are true about the result and effects of executing these commands? (Choose two.)

  

  A. User Alice is permitted to grant the CREATE USER privilege to user HR.
  B. The REVOKE statement successfully revokes the system privilege from Alice.
  C. User Alice is permitted to grant the CREATE USER privilege to user HR only.
  D. User Alice is not permitted to revoke the CREATE USER from user John.
  E. User HR is permitted to grant the CREATE USER privilege to any other user.
  F. The REVOKE statement successfully revokes the system privilege from user HR.
  A. User Alice is permitted to grant the CREATE USER privilege to user HR.
  E. User HR is permitted to grant the CREATE USER privilege to any other user.

• Question 4:

  Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

  

  Which two statements are true about redefining the table? (Choose two.)

  A. All the triggers for the table are disabled without changing any of the column names or column types in the table.
  B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.
  C. VPD policies are copied from the original table to the new table during online redefinition.
  D. You must copy the VPD policies manually from the original table to the new table during online redefinition.
  B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.
  C. VPD policies are copied from the original table to the new table during online redefinition.

  ---

  C (not D): CONS_VPD_AUTO Used to indicate to copy VPD policies automatically

  *

  DBMS_RLS.ADD_POLICY

  / The DBMS_RLS package contains the fine-grained access control administrative interface, which is used to implement Virtual Private Database (VPD).DBMS_RLS is available with the Enterprise Edition only.

  Note:

  *

  CONS_USE_PK and CONS_USE_ROWID are constants used as input to the "options_flag" parameter in both the START_REDEF_TABLE Procedure and CAN_REDEF_TABLE Procedure. CONS_USE_ROWID is used to indicate that the

  redefinition should be done using rowids while CONS_USE_PK implies that the redefinition should be done using primary keys or pseudo-primary keys (which are unique keys with all component columns having NOT NULL constraints).

  *

  DBMS_REDEFINITION.START_REDEF_TABLE

  To achieve online redefinition, incrementally maintainable local materialized views are used. These logs keep track of the changes to the master tables and are used by the materialized views during refresh synchronization.

  *

  START_REDEF_TABLE Procedure

  Prior to calling this procedure, you must manually create an empty interim table (in the same schema as the table to be redefined) with the desired attributes of the post-redefinition table, and then call this procedure to initiate the redefinition.

• Question 5:

  In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and an Automatic Workload Repository (AWR) snapshot is taken every 30 minutes.

  Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

  A. It measures database performance by analyzing the wait time and CPU time of all non-idle user sessions.
  B. It always compares the latest snapshot with the baseline snapshot for analysis.
  C. It runs after each AWR snapshot is created and it requires at least two snapshots for analysis.
  D. It requires at least four AWR snapshots for analysis.
  E. It calls other advisors if required, but does not provide recommendations about the advisors to be used.
  A. It measures database performance by analyzing the wait time and CPU time of all non-idle user sessions.
  C. It runs after each AWR snapshot is created and it requires at least two snapshots for analysis.

• Question 6:

  A database uses Automatic Storage Management (ASM) as database storage, which has a diskgroup, DATA1, which is created as follows:

  

  What happens when the FAILGRP1 failure group is corrupted?

  A. Mirroring of allocation units occurs within the FAILGRP2 failure group.
  B. Transactions that are using the diskgroup fail.
  C. ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the FAILGRP2 failure group.
  D. Data in the FAILGRP1 failure group is moved to the FAILGRP2 failure group and rebalancing is started.
  D. Data in the FAILGRP1 failure group is moved to the FAILGRP2 failure group and rebalancing is started.

• Question 7:

  Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)

  A. recommending creation of indexes based on SQL workload
  B. recommending restructuring of SQL statements that have suboptimal plans
  C. checking schema objects for missing and state statistics
  D. recommending optimization of materialized views
  E. generating SQL profiles
  B. recommending restructuring of SQL statements that have suboptimal plans
  C. checking schema objects for missing and state statistics
  E. generating SQL profiles

• Question 8:

  Which four are true about creating and running a remote database scheduler jobs? (Choose four.)

  A. A database destination must exist or be created for the remote database
  B. It must run as a user that is defined on the remote database
  C. Remote database jobs always run as the same user who submits the job on the local database
  D. A credential is optional for a remote database job
  E. A credential must be created to define the remote user
  F. A database destination group must exist or be created for a job to run on multiple remote databases
  G. A destination is optional for a remote database job because DB links can be used instead
  A. A database destination must exist or be created for the remote database
  B. It must run as a user that is defined on the remote database
  D. A credential is optional for a remote database job
  F. A database destination group must exist or be created for a job to run on multiple remote databases

• Question 9:

  Examine the query and its output executed In an RDBMS Instance:

  

  Which three statements are true about the users (other than sys) in the output? (Choose three.)

  A. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
  B. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
  C. The C # # A_ADMIN user can perform wallet operations.
  D. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
  E. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
  B. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
  D. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
  E. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

  ---

  B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup and shutdown) using Data Guard Broker or dgmgrl.

  D: SYSASM The new (introduced in 11g) SYSASM role to manage the ASM instance, variable extent sizes to reduce shared pool usage, and the ability of an instance to read from a specific disk of a diskgroup

  E (Not A): SYSDBA is like a role in the sense that it is granted, but SYSDBA is a special built-in privilege to allow the DBA full control over the database

  Incorrect:

  Not C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption wallet operations.

  Note:

  Use the V$PWFILE_USERS view to see the users who have been granted administrative privileges.

• Question 10:

  Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.

  What should you use to achieve this?

  A. Database replay
  B. SQL Tuning Advisor
  C. SQL Access Advisor
  D. SQL Performance Analyzer
  E. Automatic Workload Repository compare reports
  D. SQL Performance Analyzer

  ---

  You can use the SQL Performance Analyzer to analyze the SQL performance impact of any type of system change. Examples of common system changes include: ?Database upgrades ?Configuration changes to the operating system, hardware, or database ?Database initialization parameter changes ?Schema changes, such as adding new indexes or materialized views ?Gathering optimizer statistics ?SQL tuning actions, such as creating SQL profiles

  http://docs.oracle.com/cd/B28359_01/server.111/b28318/intro.htm#CNCPT961