フリー問題

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

問題文

A team creates a public synonym for a table so that every user can write the short name. One user still receives a table or view does not exist error when using it. What is missing for that user?

選択肢

  1. The system privilege to create a synonym, because a public synonym gives a name to every user who is allowed to define names in the database.
  2. The schema prefix in front of the name, because a public synonym gives a name to every user who writes the owner too.
  3. A private synonym of the same name, because a public synonym gives a name to every user after each schema declares it.
  4. The privilege on the underlying table, because a public synonym gives a name to every user but grants nothing on the object behind it.

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

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