Online Access Free 1Z0-183 Practice Test

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

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

Which two elements are part of a sound backup strategy?
(Choose two)

• A.Storing all backups on the same server as the database
• B.Automating archive log deletion without verification
• C.Testing recovery scenarios periodically
• D.Retaining copies of control file and SPFILE backups

Which two steps are mandatory when transporting tablespaces across platforms with different endian formats?
(Choose two)

• A.Export/import the control file with Data Pump
• B.Make tablespaces READ ONLY before backup
• C.Use RMAN CONVERT TABLESPACE to transform datafiles
• D.Recreate redo log files on target platform

How does Oracle Restart enhance availability for single-instance databases?

• A.By restarting database components such as listeners, databases, and ASM automatically after failures or reboots
• B.By managing RAC node failover events
• C.By eliminating the need for ASM
• D.By automatically applying rolling patches

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

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