PrepAway - Latest Free Exam Questions & Answers

which of the following is NOT an accurate statement?

If a view named V1 is created in such a way that it references every column in a table named
EMPLOYEE except a column named SALARY, which of the following is NOT an accurate
statement?

PrepAway - Latest Free Exam Questions & Answers

A.
View V1 can be used in the same context as the EMPLOYEE table for all data retrieval
operations that do not acquire SALARY information

B.
View V1 can be used as a data source for other views

C.
View V1 does not have to reside in the same schema as the EMPLOYEE table

D.
All data, except SALARY data that is stored in the EMPLOYEE table is copied to the physical
location associated with view V1

One Comment on “which of the following is NOT an accurate statement?


Leave a Reply