Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 171:

  Your database instance has the following parameter setting:

  OS_AUTHENT_PREFIX = OPS$

  You execute the following command:

  

  And then grant OPS$GUEST_USER the CREATE SESSION privilege.

  Which two statements are true? (Choose two.)

  A. GUEST_USER can query the tables created in the USERS tablespace by default.

  B. The authentication details for GUEST_USER are stored in the database password file.

  C. A local GUEST_USER OS account should exist before GUEST_USER can log on to the database.

  D. GUEST_USER can log on to the database without specifying a username and password.

  E. GUEST_USER is forced to change the password at the first login.

  Correct Answer: CD

• Question 172:

  You want to upgrade an Oracle Database running Oracle Database 11g to Oracle Database 12c.

  Which three tasks should be performed before a manual upgrade? (Choose three.)

  A. running preupgrad.sql in Oracle Database 11g to generate fix-up scripts and a log file

  B. running utlu121s.sql from the new Oracle home to display information about the required initialization parameters

  C. copying the initialization parameter file to the new Oracle home

  D. copying the password file to the new Oracle home

  E. copying net configuration files to the new Oracle home

  Correct Answer: ACE

• Question 173:

  Your database has been running with a peak load for the past hour. You want to preserve the performance statistics collected during this period for comparison when you analyze the performance of the database later.

  What must you do to achieve this?

  A. Increase the window size of the moving window baseline so that it equals the Automatic Workload Repository (AWR) snapshot retention period.

  B. Create a baseline on a pair of snapshots that span the peak load period.

  C. Generate Active Session History reports for the peak load period.

  D. Set the snapshot retention period in AWR to 60 to avoid automatic purging of snapshots for the past hour.

  Correct Answer: B

• Question 174:

  Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration? (Choose four.)

  A. listener configured by using NETCA

  B. database service created by using SRVCTL

  C. database created by using a SQL statement

  D. database created by using DBCA

  E. ASM instance created by using ASMCA

  F. database service created by using DBMS_SERVICE.CREATE_SERVICE

  G. database service created by modifying the SERVICE_NAMES initialization parameter

  Correct Answer: BCEF

  References: https://docs.oracle.com/cd/E18283_01/server.112/e17120/restart002.htm#insertedID3

• Question 175:

  Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified auditing by executing the command:

  $ make –fins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME

  Which two steps should you perform before executing this command? (Choose two.)

  A. Ensure that the initialization parameter AUDIT_TRAIL is set to DB.

  B. Drop any existing fine-grained audit (FGA) policies.

  C. Stop the listener.

  D. Shut down the database instance.

  E. Disable auditing by setting the initialization parameter AUDIT_TRAIL to NONE.

  Correct Answer: CE

  References: https://blogs.oracle.com/UPGRADE/entry/unified_auditing_is_it_on

• Question 176:

  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.

  Correct Answer: D

• Question 177:

  Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup.

  Which two statements are true in this scenario? (Choose two.)

  A. The user-managed backup consists of only formatted data blocks.

  B. The database must be shut down to take a user-managed backup.

  C. The RMAN backup contains only data files.

  D. The RMAN backup can be performed while the database is open.

  E. The database must be in MOUNT state to take RMAN backup.

  Correct Answer: AB

• Question 178:

  Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup.

  In which three scenarios do you need media recovery? (Choose three.)

  A. loss of all the copies of the control file

  B. loss of all the inactive online redo log group members

  C. loss of a data file that belongs to the active undo tablespace

  D. loss of data files that belong to the SYSTEM tablespace

  E. logical corruption of data that is caused by a wrong transaction

  F. abnormal termination of the database instance

  Correct Answer: ACD

• Question 179:

  You plan to install the Oracle Database 12c software. You want to use Oracle Automatic Storage Management (ASM) for storage and Oracle Restart for managing components. Oracle Grid Infrastructure

  for a Standalone Server is already installed on the server.

  Which three statements must be true for successful installation of the Oracle Database 12c software? (Choose three.)

  A. The OSBACKUPDBA, OSDGDBA, and OSKMDBA OS groups must be created.

  B. An operating system OSDBA group must be created for users with the SYSDBA system privilege.

  C. The Oracle Database 12c software owner and the Oracle Grid Infrastructure owner must belong to the same Oracle Inventory Group.

  D. The Oracle Database 12c installation must have a separate Oracle inventory directory.

  E. An operating system OSOPER group be created for users with the SYSOPER system privilege.

  Correct Answer: BCE

• Question 180:

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

  A. You cannot specify how partitioned tables should be handled during an import operation.

  B. Only data can be compressed during an export operation.

  C. Existing dump files can be overwritten during an export operation.

  D. Tables cannot be renamed during an import operation.

  E. Metadata that is exported and imported can be filtered based on objects and object types.

  Correct Answer: AE

  References: https://docs.oracle.com/cd/B28359_01/server.111/b28300/expimp.htm#UPGRD12560