Free Oracle 1Z1-182 Exam Dumps Questions & Answers

Which three statements are true about Enterprise Manager Cloud Control?

• A.It uses a web-based console built into the Oracle database using XML DB.
• B.It provides management for Oracle-engineered systems.
• C.It provides management for Oracle middleware.
• D.It is integrated with My Oracle Support.
• E.It is available to manage a database only when that database is open.

Which data dictionary view describes the data sources of external tables?

• A.DBA_ALL_USER_TABLES
• B.DBA_ALL_USER_EXTERNAL_LOCATIONS
• C.DBA_ALL_USER_TAB_COLUMNS
• D.DBA_ALL_USER_EXTERNAL_TABLES

Which two are true about shrinking a segment online?

• A.It must be in a tablespace that uses Automatic Segment Space Management (ASSM).
• B.To shrink a table it must have a PRIMARY KEY constraint.
• C.It is not possible to shrink either indexes or Index Organized Tables (IOTs).
• D.To shrink a table it must have row movement enabled.
• E.To shrink a table it must have a UNIQUE KEY constraint.

You have connected to a PDB to perform the administration operations of changing and verifying a system parameter that is PDB_MODIFIABLE. What is the appropriate mode to open the PDB to achieve this?

• A.RESTRICTED READ ONLY
• B.RESTRICTED WRITE ONLY
• C.READ ONLY
• D.READ WRITE

In which two ways would you disable timing information collected for wait events and much of the performance monitoring capability of the database?

• A.By setting the TIMED_STATISTICS system parameter to FALSE.
• B.By executing the PL/SQL procedure DBMS_TIME_STATISTIC.DISABLE(TRUE).
• C.By setting the TIMED_STATISTICS_LEVEL system parameter to FALSE.
• D.By executing the PL/SQL procedure DBMS_TIME_STATISTIC.LEVEL(BASIC).
• E.By setting the STATISTICS_LEVEL parameter to BASIC.