What special Oracle feature allows you to specify how the cost based system treats a SQL statement?
Submitted by: AdministratorThe COST based system allows the use of HINTs to control the optimizer path selection. If they can give some example hints such as FIRST ROWS, ALL ROWS, USING INDEX, STAR, even better.
Submitted by: Administrator
Submitted by: Administrator
Read Online SQL Job Interview Questions And Answers
Top SQL Questions
☺ | Under which circumstance must you recompile the package body after recompiling the package specification? |
☺ | What is sql Posting? |
☺ | For which trigger timing can you reference the NEW and OLD qualifiers? |
☺ | The command used to open a CURSOR FOR loop is? |
☺ | What occurs if a procedure or function terminates with failure without being handled? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Sybase Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |