Free Oracle 1Z1-182 Exam Dumps Questions & Answers

Which two tasks can be performed in the NOMOUNT state?

• A.  Creating a database.
• B.  Re-creating control files.
• C.  Enabling online redo log archiving.
• D.  Renaming data files.
• E.  Full database recovery.

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces?

• A.  Online table segment shrink.
• B.  Online index segment shrink.
• C.  Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR).
• D.  Oracle Managed Files (OMF).
• E.  Automatic data file extension (AUTOEXTEND).

Which three statements are true about the Oracle Database server during and immediately after SHUTDOWN TRANSACTIONAL?

• A.  Sessions remain connected even if they are not running a transaction.
• B.  Uncommitted transactions are allowed to continue to the next COMMIT.
• C.  New connection requests made to the database instance are refused.
• D.  Uncommitted transactions are allowed to continue to the next ROLLBACK.
• E.  Instance recovery occurs automatically during the shutdown.

What are the three components of Oracle Database Automatic Maintenance Tasks?

• A.  Oracle Database Resource Manager, which enables you to manage and configure system resources used by the Automatic Maintenance Tasks.
• B.  The maintenance windows managed by Oracle Database Scheduler, which are predefined time intervals permitting scheduled tasks.
• C.  A set of tasks that are started automatically at regular intervals to perform maintenance operations on the database.
• D.  A packaging system that allows you to combine all error and failure logs to share with Oracle Support.
• E.  A diagnostic system that collects database error logs and details about database failures that can be found to diagnose complete file.
• F.  A database alert log that stores details about major database operations and errors, which is used to manage cluster performance.

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.