Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 121:

  Your database is in NOARCHIVELOG mode. You want to enable archiving for the database.

  Examine the steps:

  1.

  Execute the ALTER DATABASE ARCHIVELOG command.

  2.

  Execute SHUTDOWN IMMEDIATE.

  3.

  Execute STARTUP MOUNT.

  4.

  Set the DB_RECOVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/.

  5.

  Execute STARTUP NOMOUNT.

  6.

  Open the database.

  7.

  Execute SHUTDOWN TRANSACTIONAL.

  Identify the required steps in the correct sequence.

  A. 4, 2, 5, 1, 6

  B. 1, 2, 3, 4, 6

  C. 2, 3, 1, 6

  D. 2, 5, 1, 6

  Correct Answer: C

• Question 122:

  Identify the access that is initially available to connect to your Database as a Service (DBaaS) environment.

  A. Enterprise Manager on port 1158

  B. telnet on port 23

  C. Cloud Control on port 7799

  D. SSH on port 22

  E. SSL/TLS on port 443

  Correct Answer: D

• Question 123:

  Which statement is true about profiles?

  A. Resource limits specified in a profile assigned to a user are always enabled.

  B. A user can exist without any profile.

  C. A profile can be assigned only to one user.

  D. Password management using profiles is always enabled.

  Correct Answer: D

• Question 124:

  Which three statements are true about naming methods? (Choose three.)

  A. Local naming supports multiple protocols, but for any one connection, the client and server must use the same protocol.

  B. In the Easy Connect method, clients can connect to a database server by using the host name of the database with an optional port and service name.

  C. In the Easy Connect method, the listener port and IP address must be provided for the connection to be successful.

  D. The local naming method does not support connect-time failover and load-balancing options.

  E. The directory naming method supports connect-time failover and load-balancing options.

  Correct Answer: ABE

• Question 125:

  Which task is performed by a background process in a database instance?

  A. Connecting between a client process and a dispatcher

  B. Executing PL/SQL code

  C. Creating dedicated server connections

  D. Copying online redo log files to offline storage

  Correct Answer: D

• Question 126:

  As part of a manual upgrade of your database to Oracle Database 12c, you plan to issue the command: SQL> STARTUP UPGRADE

  Which three statements are true about the upgrade process? (Choose three.)

  A. All system triggers are disabled during the upgrade process.

  B. Only queries on fixed views execute without errors until you run the catctl.pl script.

  C. The COMPATIBLE parameter must be set to at least 12.1.0 before issuing the command.

  D. All job queues remain active during the upgrade process.

  E. Only connections AS SYSDBA are allowed during the upgrade process.

  Correct Answer: ADE

• Question 127:

  Which statement is true about using the Export/Import method for migrating data when upgrading to Oracle Database 12c?

  A. It automatically restarts a Data Pump Export or Import job after a failure is connected and the job continues from the point of failure.

  B. It can be used to migrate a database only if the source and target databases are hosted on the same endian format.

  C. It can be used to migrate a database only if the source database does not have any tablespace in read-only mode.

  D. It allows migration of a database directly over network links.

  Correct Answer: D

• Question 128:

  Your database is in ARCHIVELOG mode and you want to automate the backup scheduling for your database.

  Which two tools or utilities would you use to achieve this? (Choose two.)

  A. Oracle Enterprise Manager Database Express (EM Express)

  B. Oracle Enterprise Manager Cloud Control

  C. Database Configuration Assistant (DBCA)

  D. Recovery Manager (RMAN) script invoked by using scheduler

  Correct Answer: BD

• Question 129:

  Which two would you recommend to an application developer for reducing locking conflicts on tables in an Oracle database? (Choose two.)

  A. Create objects in locally managed tablespaces with Automatic Segment Space Management (ASSM) enabled.

  B. Avoid coding long-running transactions.

  C. Allow the database to handle locks ln default locking mode.

  D. Create objects in locally managed tablespaces with manual segment space management enabled.

  E. Enable undo retention guarantee.

  Correct Answer: BC

• Question 130:

  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

  Correct Answer: BCE