Oracle 1z0-182 Actual Exam Questions

Last updated on July 23, 2025.

Topic 1 - Exam A

Question #1 Topic 1

Which of the following ALTER SYSTEM statements can be run from within a pluggable database (PDB) and affect the entire container database (CDB)?

  • A. ALTER SYSTEM ENABLE / DISABLE RESTRICTED SESSION
  • B. ALTER SYSTEM FLUSH BUFFER_CACHE
  • C. ALTER SYSTEM CHECKPOINT
  • D. ALTER SYSTEM SWITCH LOGFILE
Reveal Solution Hide Solution   Discussion  

Correct Answer: BC 🗳️

Question #2 Topic 1

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

  • A. READ ONLY
  • B. READ WRITE
  • C. RESTRICTED WRITE ONLY
  • D. RESTRICTED READ ONLY
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️

Question #3 Topic 1

Which statement regarding PDBs (Pluggable Database) is correct?

  • A. You can drop a PDB as long as it is not the PDB seed.
  • B. When the relocation of a PDB is finished, the source PDB must be dropped.
  • C. You cannot drop a source PDB of a refreshable PDB.
  • D. You can drop an application root along with the associated PDBs.
Reveal Solution Hide Solution   Discussion  

Correct Answer: A 🗳️

Question #4 Topic 1

Which role is used to manage Unified Auditing policies and operations?

  • A. The AUDIT_ADMIN role
  • B. The SYSAUDIT role
  • C. The DBA role
  • D. The SYSTEM role
Reveal Solution Hide Solution   Discussion  

Correct Answer: A 🗳️

file Viewing page 1 out of 33 pages.
Viewing questions 1-4 out of 131 questions
Next Questions
Browse atleast 50% to increase passing rate cup
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Loading ...