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

Get Full Version of the Exam

Question No.131

What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?

  1. It fails with the ORA-665610 Invalid DDL statement on history-tracked message

  2. The rows in the table are truncated without being archived.

  3. The rows in the table are archived, and then truncated.

  4. The rows in both the table and the archive are truncated.

Correct Answer: C

Question No.132

Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.

You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:


SQL gt; FLASHBACK DATABASE to TIME quot;TO_DATE (`08/20/12#39; , `MM/DD/YY#39;)quot;;

Examine following commands:




Which command or commands should you execute next to allow updates to the flashback back schema?

  1. Only 1

  2. Only 2

  3. Only 3

  4. 3 and 1

  5. 1 and 2

Correct Answer: D

Question No.133

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

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

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

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

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

Correct Answer: CD



Question No.134

You find this query being used in your Oracle 12c database:


Which method a used by the optimizer to limit the rows being returned?

  1. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows

  2. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.

  3. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.

  4. A TOP-N query is created to limit the rows to 20 percent of the total rows

Correct Answer: C

Question No.135

Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.

A user issues a query on a table on one of the PDBs and receives the following error: ERROR at line 1:

ORA-01565: error in identifying file `/u01/app/oracle/oradata/CDB1/temp01.tmp#39; ORA-27037: unable to obtain file status

Identify two ways to rectify the error.

  1. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.

  2. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.

  3. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.

  4. Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.

  5. Shut down the database instance and then restart the CDB and PDBs.

Correct Answer: AE


Because temp files cannot be backed up and because no redo is ever generated for them, RMAN never restores or recovers temp files. RMAN does track the names of temp files, but only so that it can automatically re-create them when needed.

If you use RMAN in a Data Guard environment, then RMAN transparently converts primary control files to standby control files and vice versa. RMAN automatically updates file names for data files, online redo logs, standby redo logs, and temp files when you issue RESTORE and RECOVER.

Question No.136

Which statement is true about Oracle Net Listener?

  1. It acts as the listening endpoint for the Oracle database instance for all local and non- local user connections.

  2. A single listener can service only one database instance and multiple remote client connections.

  3. Service registration with the listener is performed by the process monitor (PMON) process of each database instance.

  4. The listener.ora configuration file must be configured with one or more listening protocol

    addresses to allow remote users to connect to a database instance.

  5. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly.

Correct Answer: C



Question No.137

Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:


DATAFILE `u01/oracle/rddb1/undotbs01.dbf#39; SIZE 60M AUTOEXTEND ON; What is the result?

  1. It executes successfully and creates an UNDO tablespace in HR_PDB.

  2. It falls and reports an error because there can be only one undo tablespace in a CDB.

  3. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.

  4. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.

  5. It executes successfully but neither tablespace nor the data file is created.

Correct Answer: E


Interesting behavior in DB of creating an undo tablespace in a PDB. With the new Multitenant architecture the undo tablespace resides at the CDB level and PDBs all share the same UNDO tablespace.

When the current container is a PDB, an attempt to create an undo tablespace fails without returning an error.

Question No.138

Examine the following command;

ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?

  1. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.

  2. All DDL commands are logged in the alert log file.

  3. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.

  4. Only DDL commands that resulted in the creation of new segments are logged.

  5. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

Correct Answer: E

Question No.139

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? (Choose three.)

  1. A DBA can check specific tables with the DMU

  2. The database to be migrated must be opened read-only.

  3. The release of the database to be converted can be any release since

  4. The DMU can report columns that are too long in the converted characterset.

  5. The DMU can report columns that are not represented in the converted characterset.

Correct Answer: ADE


A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the migration process.

D: Exceed column limit

The cell data will not fit into a column after conversion. E: Need conversion

The cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found

Oracle Database Migration Assistant for Unicode (DMU) is a unique next-generation migration tool providing an end-to-end solution for migrating your databases from legacy encodings to Unicode.


Not C: The release of Oracle Database must be,,,, or later.

Question No.140

In your production database, data manipulation language (DML) operations are executed on the SALES table.

You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.

What action would you take to achieve this task?

  1. Apply fine-grained auditing.

  2. Implement value-based auditing.

  3. Impose standard database auditing to audit object privileges.

  4. Impose standard database auditing to audit SQL statements.

Correct Answer: B

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