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

Get Full Version of the Exam

Question No.311

Which statement is true about unified auditing?

  1. The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace.

  2. Only the CREATE, ALTER, and DROP statements are audited for all users, including SYS.

  3. Unified auditing is enabled only if the AUDIT_TRAIL parameter is set to NONE.

  4. The unified audit trail contains audit records only from unified audit policies and AUDIT settings.

Correct Answer: A



Question No.312

Which two categories of segments are analyzed by the Automatic Segment Advisor? (Choose two.)

  1. segments in tablespaces that have exceeded a critical or warning space threshold

  2. segments that have the highest growth rate in a database

  3. segments that are sparsely populated and have more than 10% of free space below the high water mark.

  4. segments that have unusable indexes

  5. segments for tables created using ADVANCED ROW COMPRESSION

Correct Answer: AB



Question No.313

The HR user updates the salary of one of the employees in the non-partitioned EMPLOYEES table, but does not commit the transaction. Which two types of lock exist in this situation? (Choose two.)

  1. exclusive lock on the EMPLOYEES table

  2. null lock on the row being updated

  3. null lock on the EMPLOYEES table

  4. row level lock on the row being updated

  5. shared lock on the EMPLOYEES table

Correct Answer: DE

Question No.314

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

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

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

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

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

Correct Answer: D

Question No.315

Identify three situations in which messages are written to the alert log file. (Choose three.)

  1. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50)quot;

  2. Creating a table returns quot;ORA-00955: name is already in used by an existing objectquot;

  3. Inserting a value into a table returns quot;ORA-01722: invalid numberquot;

  4. Updating a record in a table returns quot;ORA-00060: deadlock detected while waiting for resourcequot;

  5. Inserting a value into a table returns quot;ORA-00001: unique constraint (SYS.PK_XXXX) violatedquot;

  6. Running a query on a table returns quot;ORA-01578: ORACLE data block corrupted (file # 4, block # 131)quot;

Correct Answer: ADF

Question No.316

You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?

  1. RBAL

  2. CKPT

  3. SMON

  4. PMON

  5. MMON

  6. CTWR

  7. DBWR

Correct Answer: F

Question No.317

SMD is a smallfile locally managed tablespace with manual segment space management. The SH user receives the following error while inserting data into the sales table:


Which three actions can be taken to enable the user to insert data? (Choose three.)

  1. altering the data file associated with the SMD tablespace to grow automatically

  2. adding a data file to the SMD tablespace, provided the tablespace has not reached its maximum number of file

  3. changing segment space management for the SMD tablespace to automatic

  4. resizing the data file associated with the SMD tablespace to make it larger, provided all data files

    have not yet reached their maximum size

  5. increasing the space quota on the SMD tablespace for the SH user, provided the files have not yet reached their maximum size

Correct Answer: ABD

Question No.318

Examine the command: SQLgt; CONNECT hr/hr@orcl

Which two configurations allow this command to execute successfully? (Choose two.)

  1. In the tnsnames.ora file, the SERVICE_NAME value of CONNECT_DATA should be explicitly suffixed with the domain name.

  2. The SERVICE_NAMES initialization parameter should contain the name orcl in the database host.

  3. The orcl TNS alias should be defined such that it is resolvable by a client running on the database host.

  4. The orcl TNS alias should be defined in the tnsnames.ora file on both the client and the database host.

  5. The TNS_ADMIN environment variable should be set to orcl on the client.

Correct Answer: BC

Question No.319

Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?

  1. It terminates if the SYSTEM tablespace in the source database is not autoextensible.

  2. It automatically makes necessary changes to Oracle environment variables.

  3. It automatically enables unified auditing in the upgraded database.

  4. It automatically adds new data files if there is not enough disk space to grow.

Correct Answer: D



Question No.320

When is the UNDO_RETENTION parameter value ignored by a transaction?

  1. when there are multiple undo tablespaces available in a database

  2. when the data file of the undo tablespace is autoextensible

  3. when the undo tablespace is of a fixed size and retention guarantee is not enabled

  4. when Flashback Database is enabled

Correct Answer: C


https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention)

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