Free Oracle 1Z1-183 Exam Dumps Questions & Answers

Which two tuning actions help reduce SQL execution cost?
(Choose two)

• A.  Disable adaptive query optimization
• B.  Gather optimizer statistics regularly
• C.  Use bind variables instead of literals
• D.  Disable SQL plan baselines

Which step is required when creating a Container Database (CDB) using Database Configuration Assistant (DBCA) with the intention to host multiple Pluggable Databases (PDBs)?

• A.  Skip root and seed creation to save space for future PDBs
• B.  Select the "Create as Container Database" option and specify the number of PDBs
• C.  Create separate SYSTEM tablespaces for each seed database
• D.  Disable Oracle Managed Files to manually configure datafiles

What is the key benefit of using PDB cloning for transport across different CDBs?

• A.  It enables cross-platform migration while maintaining application metadata integrity
• B.  It eliminates the need for network services between source and target
• C.  It automatically adjusts the character set without user intervention
• D.  It copies data at the block level, bypassing tablespace checks

What is the purpose of using bind variables in SQL statements?

• A.  To reduce SQL parse overhead and improve plan reuse
• B.  To generate automatic statistics for queries
• C.  To force index usage regardless of optimizer choice
• D.  To bypass cost-based optimization

Which two items must be available to perform a complete recovery of a database using RMAN?
(Choose two)

• A.  All archived redo logs
• B.  Block change tracking file
• C.  Latest control file
• D.  Recovery catalog only