A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?

Question

Tom Ogan · Accepted Answer

The data from the permanent table.

Tom Ogan · Answer

The data from the temporary table.

Tom Ogan · Answer

An error stating that the view could not be compiled.

Tom Ogan · Answer

An error stating that the referenced object could not be uniquely identified.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 318 - COF-C02 discussion

Suggested answer: A

0 comments