Knowledge quiz

It's time to put what you've learned to the test, get 8 right to pass this week.

1.

Which of the following statements about the CASCADE option for SQL Hint are correct?

There are two correct answers.
2.

Which of the following statements about a parameterized query is correct?

Choose the correct answer.
3.

Which of following statements about the execution time of a CALL statement shown in Plan Visualizer trace is correct?

Choose the correct answer.
4.

Assume there is a SQL statement "SELECT * FROM PRODUCTS" in SQLScript procedure, its STATEMENT_HASH value is "54f3a26840fd0eedc15f6c074cf26ada", and its plan ID is 12360002. What is the correct SQL statement to apply SQL HINT USE_HEX_PLAN for this SQL statement?

Choose the correct answer.
5.

Which of following statements about SQL HINT NO_INLINE in SQLScript is correct?

Choose the correct answer.
6.

Which of following statements about using SQL Hints are correct?

There are two correct answers.
7.

Which of following statements about using the inlining feature in SQLScript are correct?

There are two correct answers.
8.

Which of following statements about using table variables in SQLScript are correct?

There are two correct answers.
9.

Which of the following statements about the SQLScript function BIND_AS_PARAMETER are correct?

There are two correct answers.
10.

Assume that, unexpectedly, there is a very long running SQLScript procedure in your system. Which of the following statements about analyzing this performance issue are correct?

There are two correct answers.