Important Oracle 1Z0-182 Exam Questions

Answer: A

Explanation:

A .True. Any PDB except PDB$SEED can be dropped.

B .False. Source PDBs of refreshable clones can be dropped after cloning.

C .False. Dropping an application root requires explicit handling of PDBs.

D .False. Relocation doesn't mandate dropping the source PDB.

Answer: E

Explanation:

A .False. ''Logging out to the abc database'' is nonsensical; abc is a script, not a database.

B .False. SQL*Plus finds abc.sql in the current directory by default; a full path isn't required unless it's elsewhere.

C .False. The first @ specifies the TNS alias (orcl), the second runs the script (@abc); this is valid syntax.

D & E.True (identical options). The command connects to orcl via TNSNAMES.ORA, authenticates HR, and executes abc.sql.

Mechanics:sqlplus hr/hr@orcl resolves orcl to a listener address, connects, and@abc runs the script post-login.

Answer: A

Explanation:

A .True. DBA_EXTERNAL_LOCATIONS (or prefixed variants) shows external table data sources (e.g., file paths).

B-D .False. These views cover columns or tables but not external sources specifically.

Answer: A, D

Explanation:

A .True. TIMED_STATISTICS = FALSE disables timing data collection.

B .False. No such procedure exists.

C .False. No TIMED_STATISTICS_LEVEL parameter exists.

D .True. STATISTICS_LEVEL = BASIC disables most performance monitoring.

E .False. No such procedure exists.

Answer: A, B, C

Explanation:

A .True. Integrates with MOS for patches and support.

B .True. Manages Exadata, etc.

C .True. Covers WebLogic and other middleware.

D .False. Web-based, but not built into the DB.

E .False. Can manage stopped instances via agents.