Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 231:

  You plan to install the Oracle Database 12c software on a new server. The database will use Automatic Storage Management (ASM) and Oracle Restart. Oracle Grid Infrastructure for a standalone server is already installed on the server.

  You want to configure job role separation. You create the following operating system users and groups:

  -

  The user oracle as the owner of the Oracle database installation

  -

  The user grid as the owner of Oracle Grid Infrastructure

  -

  The group oinstall as an Oracle Inventory group

  -

  The group dba as the OSDBA group for Oracle database

  -

  The group asmdba as the OSDBA group for Oracle ASM

  -

  The group asmadmin as the administration privileges group for Oracle ASM

  -

  The group asmoper as the group for Oracle ASM

  Which two additional tasks should you perform with regard to the OS-level owners and groups? (Choose two.)

  A. creating a separate central inventory group for the Oracle Database 12c installation

  B. assigning oinstall as the primary group for the oracle user

  C. assigning asmadmin and asmoper as primary groups for the oracle user

  D. creating OS groups associated with the OSBACKUPDBA, OSDGDBA, and OSKMDBA system privileges

  E. assigning asmdba as the secondary group for the oracle user

  Correct Answer: BD

• Question 232:

  You have successfully taken a database backup by using the command:

  RMAN> BACKUP AS BACKUPSET DATABASE;

  Now you execute this command:

  RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;

  What is the outcome?

  A. It fails because an incremental level 1 backup always searches for an image copy as level 0 backup.

  B. It fails because an incremental level 0 backup does not exist.

  C. It takes a backup of blocks that have been formatted since the last full database backup.

  D. It takes an incremental level 0 backup of the database.

  E. It first takes an incremental level 0 backup and then an incremental level 1 backup.

  Correct Answer: E

  References: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm (4.4.1.2)

• Question 233:

  Which two actions does an incremental checkpoint perform? (Choose two.)

  A. It signals CKPT to write the checkpoint position to the data file headers.

  B. It writes the checkpoint position to the data file headers.

  C. It advances the checkpoint position in the checkpoint queue.

  D. It writes the checkpoint position to the control file.

  Correct Answer: CD

  References: http://www.dba-oracle.com/t_incremental_checkpoint.htm

• Question 234:

  You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these users is exceeded during execution of a data manipulation language (DML) statement, the operation should abort and return an error. However, queries should still be allowed, even if users have exceeded the undo space limitation.

  How would you achieve this?

  A. Specify the maximum amount of quota a user can be allocated in the undo tablespace.

  B. Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users perform transactions.

  C. Implement a profile for these users.

  D. Implement a Database Resource Manager plan.

  Correct Answer: D

• Question 235:

  A database instance is started by using an SPFILE. The database is configured in ARCHIVELOG mode and the control file autobackup is configured. Daily full database backups are performed by using RMAN.

  You lost all control files due to media failure.

  Given the steps to recover from the error in random order:

  1.

  Shut down the instance, if it is not already down.

  2.

  Restore the control file from autobackup to a new location.

  3.

  Start the database instance to NOMOUNT state.

  4.

  Recover the database to the point of failure of the control file.

  5.

  Open the database with the RESETLOGS option.

  6.

  Mount the database.

  7.

  Update the SPFILE with the new location of the control file by using the ALTER SYSTEM command.

  Identify the correct sequence of the required steps.

  A. 1, 3, 2, 6, 7, 4, 5

  B. 1, 3, 7, 2, 6, 4, 5

  C. 1, 3, 2, 4, 5

  D. 1, 2, 6, 4, 5

  E. 1, 6, 2, 4, 5

  Correct Answer: A

• Question 236:

  What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

  A. statistics recommendations

  B. SQL profile recommendations

  C. SQL statement restructure recommendations

  D. creation of materialized views to improve query performance

  Correct Answer: B

• Question 237:

  You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.

  The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade.

  What must you do first in this situation to attempt to fix this problem?

  A. Run catuppst.sql to perform revalidation actions

  B. Run utluiobj.sql to filter out objects that were invalidated by the upgrade process.

  C. Run preupgrd.sql and then execute the generated "fix-up" scripts to resolve status issues.

  D. Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view.

  Correct Answer: D

• Question 238:

  Your database instance has started using an SPFILE. Examine the RMAN configuration settings:

  

  You execute the command:

  RMAN> BACKUP AS COPY TABLESPACE TEST;

  Which three types of files are backed up by using this command? (Choose three.)

  A. online redo log files

  B. control file

  C. SPFILE

  D. archived redo log files

  E. data file(s)

  F. PFILE

  Correct Answer: BCE

  References: http://www.juliandyke.com/Research/RMAN/BackupCommand.php

• Question 239:

  You have the following entry in the tnsnames.ors of your hq.us.example.com host machine:

  

  You issue the following command at the command prompt:

  Sqlplus HR/HR@ORCL

  Which statement is true about the connection to the ORCL database instance?

  A. The connection succeeds, provided the NAMES.DEFAULT_DOMAIN parameter is set to us.example.com in the sqlnet.ora file on the client side.

  B. The connection fails because the net service name does not have the suffix us.example.com.

  C. The connection succeeds, provided the SERVICE_NAMES initialization parameter is set to ORCL.

  D. The connection succeeds, provided the ORCL.us.example.com database service is registered with a listener, the listener is up, and the database is open.

  Correct Answer: D

• Question 240:

  Which three statements are true about Oracle Restart? (Choose three.)

  A. It can be configured to automatically attempt to restart various components after a hardware or software failure.

  B. While starting any components, it automatically attempts to start all dependencies first and in proper order.

  C. It can be configured to automatically restart a database in case of normal shutdown of the database instance.

  D. It can be used to only start Oracle components.

  E. It runs periodic check operations to monitor the health of Oracle components.

  Correct Answer: BDE