1Z1-183 by Oracle Actual Free Exam Q&As

Question 1

Which two benefits are provided by an Application Root in a CDB?
(Choose two)

A. Automatic replication of common users to external non-CDB databases B. Inherited Oracle-supplied roles for cross-database security C. Isolation of application metadata from local PDB schemas D. Simplified patching of application code across multiple Application PDBs

Discussion 0

Correct Answer: C,D Vote an answer

Question 2

Which two actions are required to enable the In-Memory Column Store?
(Choose two)

A. Disable redo log archiving B. Enable DB_CACHE_SIZE to maximum C. Mark objects with the INMEMORY attribute D. Set the INMEMORY_SIZE initialization parameter

Discussion 0

Correct Answer: C,D Vote an answer

Question 3

Which two statements are true about PDB lifecycle management?
(Choose two)

A. Dropping a PDB can optionally keep its datafiles for reuse B. PDB states are persisted automatically without explicit SAVE STATE C. MOUNT is the default state when a PDB is created D. PDB$SEED can be opened in READ WRITE mode for patching

Discussion 0

Correct Answer: A,C Vote an answer

Question 4

What occurs when you execute the ALTER PLUGGABLE DATABASE pdb1 OPEN command without specifying any additional clauses?

A. The PDB opens in read-write mode and remains open permanently B. The PDB opens only for read-only transactions and remains in that mode permanently C. The PDB cannot open unless an instance parameter is modified D. The PDB opens in read-write mode but returns to MOUNT state on CDB restart

Discussion 0

Correct Answer: D Vote an answer

Question 5

What advantage does Flashback Database provide over traditional point-in-time recovery?

A. It creates guaranteed restore points automatically for every transaction B. It eliminates the need for any redo logs C. It allows rewinding the entire database quickly using flashback logs instead of restoring backups D. It replaces undo segments with archived redo

Discussion 0

Correct Answer: C Vote an answer

Question 6

When plugging in a PDB from an earlier release into a 23ai CDB, which action ensures it becomes fully compatible?

A. Dropping and recreating all application schemas manually B. Changing COMPATIBLE parameter in init.ora and restarting CDB C. Running DBMS_PDB.DESCRIBE followed by a metadata-only export D. Opening the PDB in UPGRADE mode and running catctl.pl scripts

Discussion 0

Correct Answer: D Vote an answer

Question 7

Which tool is typically used to perform an Oracle Grid Infrastructure installation for a standalone server?

A. Oracle Restart Configurator B. Net Configuration Assistant C. DBCA D. Oracle Universal Installer (OUI)

Discussion 0

Correct Answer: D Vote an answer

Question 8

When executing an incomplete recovery using RMAN, which additional step is mandatory after applying archived redo logs?

A. Running CATPROC.SQL to recompile PL/SQL packages B. Opening the database with RESETLOGS C. Enabling block change tracking D. Creating a new password file

Discussion 0

Correct Answer: B Vote an answer

Oracle AI Database Administration Professional - 1Z1-183 Exam Practice Test