フリー問題

Oracle AI Database SQL Associate のフリー問題 2 / 20 問目

問題文

A developer loads twenty rows into a table and later runs a query on it with no ORDER BY clause. The rows come back in a sequence that differs from the sequence they were loaded in. Which statement describes how a relational table holds its rows?

選択肢

  1. A table holds an unordered set of rows and a query hands them back in whatever sequence the database server finds cheapest to produce.
  2. A table holds rows in the sequence they were loaded and a query hands back that same sequence until some of those rows are deleted.
  3. A table holds rows grouped by the block they occupy and a query hands back the blocks in ascending order of the block number.
  4. A table holds rows sorted by the primary key and a query hands back that key order whenever the key column values stay unchanged.

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

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