|
Home > Archive > Oracle certifications > August 2005 > qn from 1z0-007 sql
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
qn from 1z0-007 sql
|
|
| jksaviyo 2005-08-05, 1:08 pm |
| From the text book I found two answers (D,E). I could not found the third answer.
Some one says B, others says C.
So anyone can correct it? Please.
Qn:
Which three statements correctly describe the functions and use of constraints? (Choose three)
A. constraints provide data independence
B. constraint make complex queries easy
C. constraints enforce rules at the view level
D. constraints enforce rules at the table level
E. constraints prevent the deletion of a table if there are dependencies
F. constraints prevent the deletion of an index if there are dependencies
Ans | |
| jksaviyo 2005-08-06, 12:19 pm |
| Ok, no one answering for my questions. So I will try to answer again.
Probably the answer is C, D, E.
From the text book A and B related with VIEW. C also related with view, and also VIEW can support constraints [WITH CHECK OPTION, WITH READ ONLY],
So C may be correct. |
|
|
|
|