Online Access Free 1Z1-183 Practice Test

Which feature of Oracle Database 23ai helps reduce the cost of SQL operations by caching frequently executed query results?

• A.Adaptive Cursor Sharing
• B.Result Cache
• C.SQL Plan Baseline Evolution
• D.SQL Plan Management (SPM)

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

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

How does Flashback Table differ from Flashback Database in terms of scope and impact?

• A.Flashback Table requires archive logs; Flashback Database uses only undo data
• B.Flashback Table disables redo log application; Flashback Database enforces redo consistency
• C.Flashback Table operates at the object level; Flashback Database rewinds the entire database instance
• D.Flashback Table reverts the entire database; Flashback Database affects a specific table

Which two actions are performed by the Data Recovery Advisor (DRA)?
(Choose two)

• A.Dropping damaged user schemas automatically
• B.Identifying physical datafile corruption
• C.Suggesting and generating repair scripts
• D.Automatically applying OS-level patches

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 but returns to MOUNT state on CDB restart
• B.The PDB opens in read-write mode and remains open permanently
• C.The PDB cannot open unless an instance parameter is modified
• D.The PDB opens only for read-only transactions and remains in that mode permanently