Quiz 1z0-117

Quiz 1z0-117, Oracle Database 11g Release 2: SQL Tuning

Which three statements are true about the usage of optimizer hints?

Which three tasks are performed by the parallel execution coordinator process?

You need to upgrade you Oracle Database 10g to 11g

Which two options would you use for the optimizer?

which two cases will statements execute in parallel?

You need to migrate database from oracle Database 10g to 11g

Which two statements are true regarding statistics gathered for APPS1 service?

which three situations must you collect optimizer statistics manually for database objects in addition to automatic statistics collection?

Which two statements are true regarding the execution plan?

Which two statements are true about the usage of bind variables?