최신Oracle Database 12c: Installation and Administration - 1z0-062무료샘플문제

A. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

B. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

C. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

D. Re-create the password file in the Oracle Database 12c format.

E. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

A. Each multithreaded Oracle process has an SCMN thread.

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

C. Thread creation must be routed through a dispatcher process

D. Each Oracle process runs an SCMN thread.

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

A. A committed delete to the SALES table was made more than 12 minutes before the query began

B. An update to the SALES table was committed after the query began

C. An update was made to the SALES table before the query began

D. An uncommitted delete to the SALES table was made more than 12 minutes before the query began

E. An uncommitted update to the SALES table was made more than 12 minutes before the query began

F. An update was made to the SALES table after the query began

G. A committed update to the SALES table was made more than 12 minutes before the query began

A. GUEST_USER can query the tables created in the USERS tablespace by default.

B. The authentication details for GUEST_USER are stored in the database password file.

C. A local GUEST_USER OS account should exist before GUEST_USER can log on to the database.

D. GUEST_USER can log on to the database without specifying a username and password.

E. GUEST_USER is forced to change the password at the first login.

A. It executes successfully and sets the Fast Recovery Area as the local archive destination.

B. It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database.

C. It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.

D. It fails and returns an error about LOG_ARCHIVE_DEST not being set.

A. Automatic Database Diagnostic Monitor (ADDM) report

B. SQL Access Advisor with a SQL tuning set

C. SQL Performance Analyzer

D. SQL Access Advisor with a hypothetical workload

E. SQL Tuning Advisor

A. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

B. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.

C. Both the indexes are created and used by the optimizer for queries on the ORDERS table.

D. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.

E. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.

F. Only the ORD_CUSTOMER_IX1 index created.

A. Statements that refer to standalone procedure can be audited.

B. DDL statements can be audited.

C. Only one audit record is ever created for a session per audited statement even though it is executed more than once.

D. Operations by the users logged on as SYSDBA cannot be audited.

A. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.

B. Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session.

C. A suspended statement will report an error if no corrective action has taken place during a timeout period.

D. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

E. A resumable statement can be suspended and resumed only once during execution.

A. An SPFILE can be created only before a database instance is started.

B. A PFILE can be used to start up a database instance even if an SPFILE exists.

C. An SPFILE can be created from a PFILE or from memory.

D. An SPFILE contains only those dynamic parameters that can be changed without having to restart the database instance.

E. An SPFILE must reside in the ORACLE_HOME/dbs directory.