Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 301:

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

  A. A DBA can check specific tables with the DMU

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

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

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

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

  Incorrect:

  Not C: The release of Oracle Database must be 10.2.0.4, 10.2.0.5, 11.1.0.7, 11.2.0.1, or later.

• Question 302:

  Which three activities are supported by the Data Recovery Advisor? (Choose three.)

  A. Advising on block checksum failures

  B. Advising on inaccessible control files

  C. Advising on inaccessible block change tracking files

  D. Advising on empty password files

  E. Advising on invalid block header field values

  Correct Answer: ABE

  * Data Recovery Advisor can diagnose failures such as the following:

  / (B) Components such as datafiles and control files that are not accessible because they do not exist, do not have the correct access permissions, have been taken offline, and so on / (A, E) Physical corruptions such as block checksum failures and invalid block header field values / Inconsistencies such as a datafile that is older than other database files / I/O failures such as hardware errors, operating system driver failures, and exceeding operating system

  resource limits (for example, the number of open files)

  * The Data Recovery Advisor automatically diagnoses corruption or loss of persistent data on disk, determines the appropriate repair options, and executes repairs at the user's request. This reduces the complexity of recovery process, thereby reducing the Mean Time To Recover (MTTR).

• Question 303:

  You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.

  Examine the table definition:

  

  Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)

  A. The valid time columns employee_time_start and employee_time_end are automatically created.

  B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

  C. The valid time columns are not populated by the Oracle Server automatically.

  D. The valid time columns are visible by default when the table is described.

  E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets

  the visibility for data manipulation language (DML), data definition language (DDL), and queries

  performed by the session.

  Correct Answer: ABC

• Question 304:

  Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

  

  What are three possible causes for the latch-related wait events?

  A. The size of the shared pool is too small.

  B. Cursors are not being shared.

  C. A large number COMMITS are being performed.

  D. There are frequent logons and logoffs.

  E. The buffers are being read into the buffer cache, but some other session is changing the buffers.

  Correct Answer: ABD

• Question 305:

  You enabled an audit policy by issuing the following statements:

  SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;

  SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;

  For which database users and for which executions is the audit policy now active? Select two.

  A. SYS, SYSTEM

  B. SCOTT

  C. Only for successful executions

  D. Only for failed executions

  E. Both successful and failed executions

  Correct Answer: AE

  * The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default, this policy is not enabled.

• Question 306:

  A redaction policy was added to the SAL column of the SCOTT.EMP table:

  

  All users have their default set of system privileges.

  For which three situations will data not be redacted? (Choose three.)

  A. SYS sessions, regardless of the roles that are set in the session

  B. SYSTEM sessions, regardless of the roles that are set in the session

  C. SCOTT sessions, only if the MGR role is set in the session

  D. SCOTT sessions, only if the MGR role is granted to SCOTT

  E. SCOTT sessions, because he is the owner of the table

  F. SYSTEM session, only if the MGR role is set in the session

  Correct Answer: ABD

• Question 307:

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

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

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

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

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

  Correct Answer: C

• Question 308:

  You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements: What is the result of the last SET CONTAINER statement and why is it so?

  

  A. It succeeds because the PDB_ADMIN user has the required privileges.

  B. It fails because common users are unable to use the SET CONTAINER statement.

  C. It fails because local users are unable to use the SET CONTAINER statement.

  D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

  Correct Answer: C

• Question 309:

  Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX? (Choose three.)

  A. Thread creation must be routed through a dispatcher process

  B. The local listener may spawn a now process and have that new process create a thread

  C. Each Oracle process runs an SCMN thread.

  D. Each multithreaded Oracle process has an SCMN thread.

  E. The local listener may pass the request to an existing process which in turn will create a thread.

  Correct Answer: ADE

• Question 310:

  Which three operations can be performed as multipartition operations in Oracle? (Choose three.)

  A. Merge partitions of a list partitioned table

  B. Drop partitions of a list partitioned table

  C. Coalesce partitions of a hash-partitioned global index.

  D. Move partitions of a range-partitioned table

  E. Rename partitions of a range partitioned table

  F. Merge partitions of a reference partitioned index

  Correct Answer: ABF

  Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple partitions.

  A: Merge Multiple Partitions:

  The new "ALTER TABLE ... MERGE PARTITIONS " help merge multiple partitions or subpartitions with a single statement. When merging multiple partitions, local and global index operations and semantics for inheritance of unspecified physical attributes are the same for merging two partitions.

  B: Drop Multiple Partitions:

  The new "ALTER TABLE ... DROP PARTITIONS " help drop multiple partitions or subpartitions with a

  single statement.

  Example:

  view plaincopy to clipboardprint?

  SQL> ALTER TABLE Tab_tst1 DROP PARTITIONS

  Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7;

  Table altered

  SQL>

  Restrictions :

  -You can't drop all partitions of the table.

  -If the table has a single partition, you will get the error: ORA-14083: cannot drop the only partition of a partitioned.