問題文
An analyst opens a new worksheet and runs a query that references a table by its unqualified name. The query fails saying the object does not exist, although the table is present. What is the most likely reason?
選択肢
- The table was created with a lower-case name and a quoted schema, which requires quoting in every reference.
- The result cache holds a stale object list, built from the earlier stale queries, which clears when the worksheet is reloaded.
- The warehouse assigned to the worksheet for the query is suspended, so object names cannot be resolved until it resumes.
- The worksheet's database and schema context is not set to the ones holding the table, so the unqualified name resolves elsewhere.