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

A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)

• A.V$SYSTEM_EVENT
• B.V$SESSION_WAIT_CLASS
• C.V$SESSION_EVENT
• D.V$SESSION_WAIT
• E.V$SESSION

A database is configured to use automatic undo management with temporary undo enabled. An update is executed on a heap-organized table stored in the TBS1 tablespace. Where is the undo stored?

• A.in the SYSAUX tablespace
• B.in the redo logs
• C.in rollback segments
• D.in the undo tablespace
• E.in the temporary tablespace

Which two tasks does DBUA perform by default? (Choose two.)

• A.enabling flashback in the source database if not enabled
• B.running the Pre-Upgrade information tool
• C.adding more data files if there is insufficient disk space for the SYSTEM tablespace during the upgrade
• D.setting user tablespaces to "read only" before starting the upgrade
• E.starting the source database instance if not started

Which two are true about the default listener for a single instance database? (Choose two.)

• A.It must be defined in the LISTENER.ORA file.
• B.It must be defined by using the Listener Control utility.
• C.It listens on the default port 1521.
• D.It uses the settings of the INSTANCE_NAME and SERVICE_NAMES parameters from all databases using that listener.
• E.It must support at least one service on startup.

Which two statements are true about VSTABLESPACE and DBA_ TABLESPACE?

• A.VSTABLESPACE is a dynamic view that is populated with data from the DBA_ TABLESPACES data queried only when a database is open.
• B.VSTABLESPACE and DBA_ TABLESPACES are view based on base tables in the data dictionary.
• C.VSTABLESPACE metadata is lost at shutdown, but DBA_ TABLESPACE metadata persists across shutdowns.
• D.VSTABLESPACE cab be queries by all users, but DBA_ TABLESPACEs cab be queries only by SYSDBA users.
• E.VSTABLESPACE is a dynamic view that is populated with data from th DBA_ TABLESPACE dictionary view.