Online Access Free 1Z1-182 Exam Questions

Which advisor is used to detect missing or stale object statistics?

• A.SQL Access Advisor
• B.SQL Performance Analyzer
• C.SQL Tuning Advisor
• D.SQL Statistics Advisor

Which three tasks are part of the predefined Automated Maintenance Tasks?

• A.Automatic SQL Plan Management advisor tasks.
• B.Automatic Optimizer Statistics Collection.
• C.Automatic notification tasks.
• D.Automatic error and failure log collection tasks.
• E.Automatic Backups of the database system files.
• F.Automatic segment and segment statistics advisor tasks.

Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statements are true?

• A.The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.
• B.Only queries are allowed on ORDERS while SHRINK is executing.
• C.The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.
• D.Queries and DML statements are allowed on ORDERS while the SHRINK is executing.
• E.Dependent indexes become UNUSABLE.
• F.The high-water mark (HWM) of ORDERS is adjusted.

Which statement is true about database links?

• A.A database link can be created only between two Oracle databases.
• B.A public database link can be created only by SYS.
• C.Private database link creation requires the same user to exist in both the local and the remote databases.
• D.A database link created in a database allows a connection from that database's instance to the target database's instance, but not vice versa.
• E.A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.

Which three statements are true about using SQL*Plus?

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