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

Get Full Version of the Exam

Question No.241

Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to tape drive fast enough. What could be a solution to make streaming happen during the backup?

  1. Configure backup optimization

  2. Configure the channel to increase MAXOPENFILES

  3. Configure the channel to increase the capacity with the RATE parameter

  4. Configure the channel to adjust the tape buffer size with the BLKSIZE option

Correct Answer: D

Question No.242

Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in the USERS tablespace is damaged. Which command must you execute before starting the recovery of this tablespace?





Correct Answer: A

Question No.243

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

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

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

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

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

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

Correct Answer: BCE

Question No.244

In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and an Automatic Workload Repository (AWR) snapshot is taken every 30 minutes.

Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

  1. It measures database performance by analyzing the wait time and CPU time of all non- idle user sessions.

  2. It always compares the latest snapshot with the baseline snapshot for analysis.

  3. It runs after each AWR snapshot is created and it requires at least two snapshots for analysis.

  4. It requires at least four AWR snapshots for analysis.

  5. It calls other advisors if required, but does not provide recommendations about the advisors to be used.

Correct Answer: AC

Question No.245

What is the outcome of the SHUTDOWN ABORT command?

  1. Pending transactions are committed and the database is closed.

  2. Dirty buffers in the buffer cache and unwritten redo are not written to the data files and redo log files respectively.

  3. Uncommitted transactions are rolled back

  4. Instance recovery must be requested by the DBA at the next startup

Correct Answer: B

Question No.246

Which three statements are true about Database Resource Manager? (Choose three.)

  1. A resource plan change can be automated by using the Oracle Scheduler.

  2. It can be used to control the consumption of only physical I/Os where excessive physical I/Os can trigger an automatic session termination but excessive logical I/Os cannot.

  3. It can be used to control the usage of the undo tablespace by consumer groups.

  4. A resource plan can have multiple resource plan directives, each of which controls resource allocation for a different consumer group.

  5. It can be used to enable resumable timeout for user sessions.

  6. It can be used to control the usage of the temp tablespace by consumer groups.

Correct Answer: ACD

Question No.247

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

  1. Oracle Data Pump export and import operations can be performed to move data across different database releases.

  2. DBMS_DATAPUMP PL/SQL packages can be used independent of Data Pump clients.

  3. A directory object must exist and a user performing an EXPDP or IMPDP operation must have read and write permission on that directory object.

  4. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

  5. Oracle Data Pump export operations invoked from the clients that are connected remotely by using a connection string, create Data Pump files on the client file system.

Correct Answer: ABC

Question No.248

Examine the command:


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

  1. All data definition language (DDL) commands are logged in to the alert log file.

  2. All DDL commands are logged in to a text file in Automatic Diagnostic Repository (ADR) home.

  3. A subset of executed DDL statements is written into an XML file in ADR home.

  4. A subset of executed DDL statements is written to the DDL log in ADR home.

  5. All DDL commands are logged in to a trace file in ADR home.

Correct Answer: CD

Question No.249

In which situations does the Database Writer process (DBWn) write to data files? (Choose two).

  1. when the RMAN recovery process starts

  2. when a user process commits a transaction

  3. when a tablespace is made read-only or taken offline

  4. when PMON cleans up dirty buffers in the database buffer cache

  5. when clean buffers for reading new blocks into the database buffer cache are not found easily

Correct Answer: BD

Explanation: https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm

Question No.250

You have a production Oracle 12c database running on a host.

You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.

The steps in random order:

  1. Create directory structures similar to the production database on all new machines.

  2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.

  3. Create a database clone template for the database.

  4. Run the Database Configuration Assistant (DBCA) to create the database.

  5. Run OUI in graphical mode on each machine.

  6. Run OUI in silent mode using the OUI response file.

Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

A. 1, 5, and 4 B. 3, 1, 5, and 6 C. 2, 3, 6, and 4 D. 2, 1, 6, and 4 E. 2, 3, 1, and 6

Correct Answer: E

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