1z1-062 試験問題を無料オンラインアクセス

Examine the following ALTER command:
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?

• A.It adds previously dropped disks back into the disk group
• B.It mounts disks in the disk group for which the drop-disk operation has already been co pleted
• C.It restores disks that are being dropped as the result of a DROP DISKGROUP operation.
• D.It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
• E.It cancels all pending disk drops within the disk group

Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

• A.All AWR tables belong to the SYSTEM schema.
• B.The snapshots collected by AWR are used by the self-tuning components in the database
• C.AWR contains system wide tracing and logging information.
• D.The AWR data is stored in memory and in the database.
• E.AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

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.Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
• B.Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
• C.Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session.
• D.A suspended statement will report an error if no corrective action has taken place during a timeout period.
• E.A resumable statement can be suspended and resumed only once during execution.

Which statement is true about profiles?

• A.A user can exist without any profile.
• B.A profile can be assigned only to one user.
• C.Password management using profiles is always enabled.
• D.Resource limits specified in a profile assigned to a user are always enabled.

Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

• A.The manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is used by the self-tuning components in a database.
• B.All AWR tables belong to the SYSTEM schema.
• C.An AWR snapshot contains system-wide tracing and logging information.
• D.An AWR snapshot shows the SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time.
• E.AWR data is stored in memory and in a database.