Oracle 1z0-062 問題集

質問 1：
You want execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600.
Which two statements are true? (Choose two.)
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. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
D. A resumable statement can be suspended and resumed only once during execution.
E. A suspended statement will report an error if no corrective action has taken place during a timeout period.
正解：B,E

質問 2：
Which statement is true about profiles?
A. Resource limits specified in a profile assigned to a user are always enabled.
B. Password management using profiles is always enabled.
C. A profile can be assigned only to one user.
D. A user can exist without any profile.
正解：B

質問 3：
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. Only DML and DDL statements will be monitored for the session.
B. 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.
D. Database operations will be monitored only when they consume a significant amount of resource.
E. Database operations for all sessions will be monitored.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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 the whole session if john successfully executes 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 command, and contains the SQL text and bind variables used.
D. 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.
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
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Examine the parameters for a database instance:

Your database has three undo tablespaces and the default undo tablespace is not autoextensible.
Resumable space allocation is not enabled for any sessions in the database instance.
What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?
A. Transactions fail.
B. Transactions wait until space becomes available in UNDOTBS1.
C. Transactions write their undo in a temporary tablespace.
D. Transactions write their undo in the SYSTEM undo segment.
正解：A
解説: (Topexam メンバーにのみ表示されます)