Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 211:

  Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)

  A. Bind Variable Peeking
  B. SQL Plan Baselines
  C. Adaptive Cursor Sharing
  D. Bind variable used in a SQL statement
  E. Literals in a SQL statement
  A. Bind Variable Peeking
  C. Adaptive Cursor Sharing
  D. Bind variable used in a SQL statement

• Question 212:

  Which two statements are true when row archival management is enabled? (Choose two.)

  A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
  B. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
  C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
  D. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
  E. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
  C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
  D. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

• Question 213:

  What should you do to ensure that a job stores minimal job metadata and runtime data on disk, and uses only existing PL/SQL programs?

  A. Create an event-based job.
  B. Create a lightweight job.
  C. Specify the job as a member of a job class.
  D. Use a job array.
  B. Create a lightweight job.

  ---

  References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/schedover004.htm#BGBJGHBH

• Question 214:

  You execute the following commands to audit database activities:

  SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;

  SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;

  Which statement is true about the audit record that generated when auditing after instance restarts?

  A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
  B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
  C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
  D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
  E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
  A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.

  ---

  Note:

  *

  BY SESSION

  In earlier releases, BY SESSION caused the database to write a single record for all SQL statements or operations of the same type executed on the same schema objects in the same session. Beginning with this release (11g) of Oracle Database, both BY SESSION and BY ACCESS cause Oracle Database to write one audit record for each audited statement and operation.

  *

  BY ACCESS

  Specify BY ACCESS if you want Oracle Database to write one record for each audited statement and operation.

  Note:

  If you specify either a SQL statement shortcut or a system privilege that audits a data definition language (DDL) statement, then the database always audits by access. In all other cases, the database honors the BY SESSION or BY ACCESS

  specification.

  *

  For each audited operation, Oracle Database produces an audit record containing this information: / The user performing the operation / The type of operation / The object involved in the operation / The date and time of the operation

• Question 215:

  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.
  A. Thread creation must be routed through a dispatcher process
  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.

• Question 216:

  Examine the commands executed to monitor database operations:

  $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (`batch_job' , FORCED_TRACKING => `Y');

  Which two statements are true? (Choose two.)

  A. Database operations will be monitored only when they consume a significant amount of resource.
  B. Database operations for all sessions will be monitored.
  C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
  D. Only DML and DDL statements will be monitored for the session.
  E. All subsequent statements in the session will be treated as one database operation and will be monitored.
  C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
  E. All subsequent statements in the session will be treated as one database operation and will be monitored.

  ---

  C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack. Note:

  * The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real-time Database Operation Monitoring.

  *(not B) BEGIN_OPERATION Function

  starts a composite database operation in the current session.

  / (E) FORCE_TRACKING - forces the composite database operation to be tracked when the operation starts. You can also use the string variable 'Y'.

  / (not A) NO_FORCE_TRACKING - the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable 'N'.

• Question 217:

  Which three statements are true about a job chain? (Choose three.)

  A. The DBA role is required to create a job chain.
  B. It can be used to implement dependency-based scheduling.
  C. It cannot invoke the same program or nested chain in multiple steps in the chain.
  D. It cannot have more than one dependency.
  E. It can be executed using event-based schedules.
  F. It can be executed using time-based schedules.
  B. It can be used to implement dependency-based scheduling.
  E. It can be executed using event-based schedules.
  F. It can be executed using time-based schedules.

• Question 218:

  Examine the command: SQL> CONNECT hr/hr@orcl

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

  A. In the tnsnames.ora file, the SERVICE_NAME value of CONNECT_DATA should be explicitly suffixed with the domain name.
  B. The SERVICE_NAMES initialization parameter should contain the name orcl in the database host.
  C. The orcl TNS alias should be defined such that it is resolvable by a client running on the database host.
  D. The orcl TNS alias should be defined in the tnsnames.ora file on both the client and the database host.
  E. The TNS_ADMIN environment variable should be set to orcl on the client.
  B. The SERVICE_NAMES initialization parameter should contain the name orcl in the database host.
  C. The orcl TNS alias should be defined such that it is resolvable by a client running on the database host.

• Question 219:

  The schema SALES exists in two databases, ORCL1 and ORCL2, and has the same password, SALES123.

  User SALES has CREATE DATABASE LINK and CREATE SESSION privileges on both databases.

  Examine these commands:

  Conn SALES/SALES123

  CREATE DATABASE LINK orcl2 USING 'orcl2';

  What is the outcome of executing these commands in the ORCL1 database?

  A. ORCL2 is created as a public database link to connect a single session to the SALES schema in the ORCL2 database.
  B. ORCL2 is created as a shared database link to connect multiple sessions to the SALES schema in the ORCL2 database.
  C. ORCL2 is created as a private database link to connect to only the SALES schema in the ORCL2 database.
  D. ORCL2 database link creation fails.
  C. ORCL2 is created as a private database link to connect to only the SALES schema in the ORCL2 database.

• Question 220:

  Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.)

  A. It clears all user recycle bins in a database and releases their storage space.
  B. It writes a list of invalid SYS and SYSTEM object to the registry$sys_inv_objs table.
  C. It evaluates the dependencies of network utility packages.
  D. It identifies any deprecated and unsupported parameters.
  E. It generates fix-up scripts and automatically runs them to resolve issues that are flagged in the source database.
  B. It writes a list of invalid SYS and SYSTEM object to the registry$sys_inv_objs table.
  C. It evaluates the dependencies of network utility packages.
  D. It identifies any deprecated and unsupported parameters.