Free Oracle 1Z0-182 Exam Dumps Questions & Answers

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 Diagnostic Collector used to capture and store database errors and hung analysis.
• D.  Automatic Application Tracing used to collect High-Load SQL statements and statistics.
• 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.

Which two statements are true about the configuration and use of UNDO?

• A.  UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO.
• B.  UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
• C.  Unexpired UNDO is always retained.
• D.  UNDO_RETENTION specifies how long all types of UNDO are retained.
• E.  Active UNDO is always retained.

Which of the following statements is true about external tables?

• A.  They are read/write tables.
• B.  They describe how data is stored in the external source.
• C.  They describe data stored in the database.
• D.  They describe how the external table layer presents data to the server.

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRMGR@orcl. No name server is used. Which statement is true about ORCL?

• A.  It must be the name of the server running the database to whose instance HR wishes to connect.
• B.  It must be the name of the database to whose instance HR wishes to connect.
• C.  It must resolve to a valid connect descriptor in the client's tnsnames.ora file.
• D.  It must be the value of the SERVICE_NAMES parameter on the client side.
• E.  It must resolve to a valid connect descriptor in the server's tnsnames.ora file.

Which three are benefits of using temp UNDO when performing DML on global temporary tables?

• A.  It reduces the amount of redo generated.
• B.  It reduces I/Os to the SYSTEM tablespace.
• C.  It reduces I/Os to the SYSAUX tablespace.
• D.  It permits DML on global temporary tables even if the database is opened read-only.
• E.  It reduces the amount of UNDO stored in the UNDO tablespace.