[Free] 2019(Nov) EnsurePass Oracle 1z0-062 Dumps with VCE and PDF 281-290

Get Full Version of the Exam
http://www.EnsurePass.com/1z0-062.html

Question No.281

The HR schema exists in two databases, BOSTON and DENVER, and has the same password, HR.

You have the CREATE DATABASE LINK and CREATE SESSION privileges on both the database.

BOSTON is defined as a service name in the tnsnames.ora of both the databases. You plan to use the command:

CREATE DATABASE LINK hr_link CONNECT to hr IDENTIFIED BY hr USING #39;denver#39;;

What must be done to ensure only the HR user in the BOSTON database can access the HR schema in the DENVER database?

  1. Execute this command as HR user in the BOSTON database and SYS user in the DENVER database.

  2. Execute this command as SYS user in both the databases.

  3. Execute this command as HR user in the DENVER database.

  4. Execute this command as HR user in the BOSTON database.

Correct Answer: D

Question No.282

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.)

  1. Increase the size of the temporary tablespace.

  2. Enable Automatic Memory Management (AMM).

  3. Enable undo retention guarantee.

  4. Enable temporary undo for the database.

  5. Increase the size of the redo log buffer.

Correct Answer: AD

Question No.283

Which files must you copy from the Oracle home of the database that is being upgraded to the new Oracle home for Oracle Database 12c? (Choose three.)

  1. the tnsnames.ora file

  2. the sqlnet.ora file

  3. the initialization parameter file

  4. the password file

  5. the listener.ora file

Correct Answer: ABE

Explanation:

https://docs.oracle.com/cd/E11882_01/server.112/e23633/afterup.htm#UPGRD52747

Question No.284

You plan to upgrade your Oracle Database 9i to Oracle Database 12c. Which two methods can you use? (Choose two.)

  1. Perform a rolling upgrade.

  2. Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).

  3. Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command.

  4. Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Pump to import data from the source Oracle 9i database to the target Oracle 12c database.

  5. Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle Database 12c.

Correct Answer: AE

Question No.285

You want execution of large database operations to suspend, and then resume, in the event of space allocation failures.

You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600. Which two statements are true? (Choose two.)

  1. Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session.

  2. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.

  3. A resumable statement can be suspended and resumed only once during execution.

  4. A suspended statement will report an error if no corrective action has taken place during a timeout period.

  5. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

Correct Answer: AD

Question No.286

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.)

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

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

  3. Stop the listener.

  4. Shut down the database instance.

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

Correct Answer: CE

Explanation:

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

Question No.287

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

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

  2. 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.

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

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

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

Correct Answer: ABE

Question No.288

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.)

  1. Oracle Enterprise Manager Database Express (EM Express)

  2. Oracle Enterprise Manager Cloud Control

  3. Database Configuration Assistant (DBCA)

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

Correct Answer: BD

Question No.289

Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database? (Choose two.)

  1. The DEGREE_OF_PARALLELISM parameter is set to AUTO.

  2. You cannot have multiple SQL *Loader data files.

  3. If no data file is specified, it assumes the data file to be lt;table-namegt;.dat in the current directory and uses it.

  4. You can have multiple bad files created when loading in parallel.

  5. You can selectively load rows into a table based on a filter.

Correct Answer: AC

Explanation:

https://docs.oracle.com/database/121/SUTIL/GUID-0F35B551-861B-450D-8BF3- 2312893A67D7.htm#SUTIL3951

Question No.290

Which four statements are true about the components of the Oracle Scheduler? (Choose four.)

  1. A schedule can be specified to a single job only.

  2. A scheduler job can point to a chain instead of pointing to a single program object.

  3. A job may get started automatically when a window opens.

  4. A program and job can be specified as part of a schedule definition.

  5. A job is specified as part of a program specification.

  6. A program can be used in the definition of multiple jobs.

  7. A program and schedule can be specified as part of a job definition.

Correct Answer: BCFG

Explanation:

https://docs.oracle.com/cd/B19306_01/server.102/b14231/schedover.htm

Get Full Version of the Exam
1z0-062 Dumps
1z0-062 VCE and PDF