Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 131:

  Examine the parameters:

  

  Users complain that their sessions for certain transactions hang. You investigate and discover that some users fail to complete their transactions, causing other transactions to wait on row-level locks.

  Which two actions would you take to prevent this problem? (Choose two.)

  A. Increase the maximum number of ITL slots for segments on which a blocking user performs a transaction.

  B. Decrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users.

  C. Set a limit in the profiles of blocking users to control the number of data blocks that can be accessed in a session.

  D. Use Database Resource Manager to automatically kill the sessions that are idle and are blocking other sessions.

  E. Decrease the IDLE_TIME resource limit in the profiles assigned to blocking users.

  Correct Answer: BD

• Question 132:

  Which two statements are true about Automatic Storage Management (ASM)? (Choose two.)

  A. It mounts databases and diskgroups to make ASM files available to database instances.

  B. It spreads files proportionally across all disks in a diskgroup, aiming to ensure that all the disks in a diskgroup have the same I/O load.

  C. It automatically places each disk from an external redundancy diskgroup in its own failure group.

  D. It divides files into extents and allows an extent to span disks.

  E. It mirrors data at the allocation unit (AU) level across failure groups within a normal or high redundancy diskgroup.

  Correct Answer: BC

• Question 133:

  You want to create a test database as a replica of your production database with minimum intervention from a DBA.

  Which method would you use?

  A. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

  B. Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.

  C. Create the database by using the CREATE DATABASE. . . command and manually import data by using Data Pump.

  D. Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.

  Correct Answer: A

• Question 134:

  You want to load data from a large file into your database without causing an overhead on the SGA.

  Which tool would you use.

  A. external table

  B. Oracle data Pump

  C. SQL*Loader with a direct data path

  D. SQL*Loader with a conventional data path

  E. Enterprise Manager Database Express

  Correct Answer: C

  References https://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_modes.htm#i1007501

• Question 135:

  You are using RMAN to back up your database. All the data files are in read/write mode.

  Examine the RMAN configuration parameters: Which two statements are true about a whole consistent backup of a database running in ARCHIVELOG mode? (Choose two.)

  

  A. The backup can be used as an incremental level 0 backup.

  B. The database instance must be shut down to take the backup.

  C. The database must be in MOUNT state to take the backup.

  D. The backup consists of blocks that have been formatted.

  E. The system Change Number (SCN) is the same for all the data files in the backup.

  Correct Answer: BE

• Question 136:

  Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

  A. An AWR snapshot shows the SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time.

  B. AWR data is stored in memory and in a database.

  C. All AWR tables belong to the SYSTEM schema.

  D. The manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is used by the self-tuning components in a database.

  E. An AWR snapshot contains system-wide tracing and logging information.

  Correct Answer: ABD

• Question 137:

  You want to import the schema objects of the HR user from the development database DEVDB to the production database PRODDB by using Oracle Data Pump. A database link devdb.us.oracle.com is created between PRODDB and DEVDB.

  You execute the following command on the PRODDB database server:

  

  What should you do to resolve the error?

  A. Add network_link = devdb.us.oracle.com.

  B. Add the SYSTEM user to the schemas option.

  C. Change the dumpfile option value to [email protected].

  D. Replace the schemas option with network_1ink = devdb.us.oracle.com.

  E. Replace the dumpfile option with network_1ink = devdb.us.oracle.com.

  Correct Answer: E

• Question 138:

  Which three statements are true about server-generated alerts? (Choose three.)

  A. Server-generated alerts notify administrators of problems that cannot be resolved automatically.

  B. Alerts are not issued for locally managed read-only tablespaces.

  C. Response actions cannot be specified for server-generated alerts.

  D. Stateful alerts can be queried only from the DBA_ALERT_HISTORY view.

  E. When an alert is cleared, it is moved to the DBA_ALERT_HISTORY view.

  Correct Answer: ABE

  References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema001.htm#ADMIN10120

• Question 139:

  Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and generates lots of redo.

  Which two actions would you take to solve this problem? (Choose two.)

  A. Increase the size of the temporary tablespace.

  B. Enable Automatic Memory Management (AMM).

  C. Enable undo retention guarantee.

  D. Enable temporary undo for the database.

  E. Increase the size of the redo log buffer.

  Correct Answer: AD

• Question 140:

  You want to create a file watcher and an event-based job for detecting the arrival of files on the local server from various locations. To achieve this, you enable the raising of file arrival events from remote systems.

  Which two conditions must be satisfied to receive file arrival events from a remote system? (Choose two.)

  A. The remote system must have a running Oracle Database instance and a scheduler agent installed.

  B. The initialization parameter REMOTE_OS_AUTHENT must be set to TRUE on your database.

  C. The local database must be set up to run remote external jobs.

  D. The remote system's scheduler agent must be registered with your database.

  E. Database links to remote databases must be created.

  Correct Answer: AC

  References: https://docs.oracle.com/cd/E18283_01/server.112/e17120/scheduse005.htm