フリー問題

MySQL 8.0 Database Developer のフリー問題 15 / 20 問目

問題文

A generated column carries an expression and has an index over it, and a query writes that same expression directly instead of naming the column. What does the optimizer do?

選択肢

  1. The optimizer therefore postpones the eager lookup while it settles the final arrangement.
  2. The optimizer therefore spots the equal wording while it settles the final arrangement.
  3. The optimizer therefore dismisses the strange phrasing while it settles the final arrangement.
  4. The optimizer therefore overlooks the unnamed helper while it settles the final arrangement.

解答・解説を確認するには

正解と解説の確認、回答の記録には無料登録が必要です。登録すると演習モードでフリー問題に回答し、正誤と解説をその場で確認できます。