フリー問題

Oracle Database Administration I のフリー問題 14 / 20 問目

問題文

A code column stores digits as text and the report has to sort them in numeric order. Which conversion fits and what is the other one for?

選択肢

  1. Turning the number into text fits because the sort then follows the numeric value while turning text into a number is for controlling how a value is printed.
  2. Turning the input into a number fits because the sort then follows the numeric value while the column itself has to be redefined with a numeric type first.
  3. Turning the data into a number fits because the sort then follows the numeric value while turning a number into text also removes the leading zeros of the value.
  4. Turning the text into a number fits because the sort then follows the numeric value while turning a number into text is for controlling how a value is printed.

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

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