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

You execute the SHUTDOWN ABORT command. Which two statements are true?

• A.Subsequent instance startup performs instance recovery.
• B.Subsequent instance startup performs media recovery.
• C.A checkpoint is written.
• D.Data files are closed normally.
• E.Uncommitted transactions are not rolled back by the shutdown.

Which two AWR-based tools listed below are part of Oracle Database self-tuning components?

• A.Automatic population of performance views (V$ views) from statistical data stored in AWR repository and using Automatic Database Diagnostic.
• B.Automatic Application Tracing used to collect High-Load SQL statements and statistics.
• C.Automatic Application Tracing used to collect High-Load SQL statements and statistics.
• D.Automatic Diagnostic Collector used to capture and store database errors and hung analysis.
• E.Automatic capture of statistical information from the SGA and storing it in the AWR using Automatic Database Diagnostic.
• F.ADDM, a server-based expert that reviews database performance statistics captured by Snapshots to identify potential problems before system performance degrades noticeably.

Your database instance is started with an SPFILE. A PFILE is also available. You execute this command: ALTER SYSTEM SET DB_CACHE_SIZE=100K; Where does the value change?

• A.In the SPFILE and PFILE
• B.In the SPFILE, PFILE, and memory
• C.Only in memory
• D.In the SPFILE and memory
• E.Only in the SPFILE

Which three statements are true about the tools used to configure Oracle Net Services?

• A.Oracle Net Manager can be used to locally configure naming methods on a database server.
• B.Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.
• C.Oracle Net Manager can be used to centrally configure listeners on any database server target.
• D.The Oracle Net Configuration Assistant is only used when running the Oracle installer.
• E.The lsnrctl utility requires a listener.ora file to exist before it is started.
• F.Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server.

Which three statements are true about using SQL*Plus?

• A.It has its own commands that are separate from any SQL statements.
• B.It must be downloaded from the Oracle Technology Network (OTN).
• C.It can run scripts entered at the SQL prompt.
• D.It can run scripts passed to it by a shell script.
• E.It can run Recovery Manager (RMAN) commands.
• F.It has both command-line and graphical user interfaces (GUI).