1Z1-183 試験問題を無料オンラインアクセス

What happens to existing ASM disk groups during a Grid Infrastructure upgrade?

• A.They are converted to local file systems temporarily
• B.They remain intact and are compatible with the new release once upgraded
• C.They are automatically dropped and recreated
• D.They require manual migration to new disks

What is the effect of issuing ALTER PLUGGABLE DATABASE ALL OPEN READ ONLY;?

• A.Only PDB$SEED opens, as it is the default template PDB
• B.All user-created PDBs except PDB$SEED open in read-only mode
• C.The command fails because PDB$SEED cannot change open mode
• D.All PDBs in the CDB are opened in READ WRITE mode

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

How does Oracle Enterprise Manager (OEM) assist in monitoring application performance?

• A.By providing end-to-end application tracing with SQL response time analysis
• B.By locking optimizer statistics to prevent changes
• C.By disabling SQL plan baselines automatically during tuning
• D.By only reporting on system resource utilization, not SQL performance

What is the primary purpose of an Automatic Workload Repository (AWR) baseline?

• A.To store SQL Plan Baselines for specific queries
• B.To enable flashback database functionality
• C.To schedule automatic database backups
• D.To define a reference workload for comparing performance over time