Exam 1z0-071 topic 1 question 43 discussion

Actual exam question from Oracle's 1z0-071

Question #: 43
Topic #: 1

[All 1z0-071 Questions]

Which three statements are true about views in an Oracle Database? (Choose three.)

A. A SELECT statement cannot contain a WHERE clause when querying a view containing a WHERE clause in its defining query.
B. Views have no segment.
C. Views have no object number.
D. Views can join tables only if they belong to the same schema.
E. A view can be created that refers to a non-existent table in its defining query.
F. Rows inserted into a table using a view are retained in the table if the view is dropped.

Show Suggested Answer

Suggested Answer: BEF 🗳️

by TheOracleWasTaken at Aug. 1, 2023, 11:56 p.m.

Comments

Submit Cancel

ShahedOdeh

9 months, 2 weeks ago

the correct answer is B and e and F

upvoted 1 times

...

cadcadley

1 year, 7 months ago

what that is mean no segment about view

upvoted 1 times

ArslanAltaf

1 year ago

segment mean physical storage ...

upvoted 1 times

...

KizTine

1 year, 8 months ago

I don't understand the answer E. How can views refers to non-existent table ?

upvoted 4 times

lucemqy

1 year, 7 months ago

You can create view to non-existent table or table with invalid columns by using FORCE option in the CREATE VIEW command. When you query the data from the view you will get an error

upvoted 4 times

...

TheOracleWasTaken

1 year, 11 months ago

Selected Answer: BEF

select object_id, object_name from user_objects In this table you will also find views so they do have an object number. Views have no segment since they don't take up physical space

upvoted 4 times

...