Topic: Oracle Certified Professional Exams (OCP & OCA) >> Question about constraints (Q86 in TK) 1Z0-007
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Question about constraints (Q86 in TK) 1Z0-007 |
| ozkucur |
Posted: Nov 05, 2006 12:54:04 PM |
Total Post: 23
Joined: Oct, 2006
|
Which three statements correctly describe the functions and use of constraints? (Choose
three.)
A)Constraints provide data independence.
B)Constraints 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.
ANSWER: TK says C,D,E
I am not sure about the option C. According to SYBEX book: "Constraints on views are not enforced- they are declerative constraints. To enforce constraints you must define them on the base tables"
On the other hand, the "WITH CHECK OPTION" and "WITH READ ONLY" flags on view are also defined like constraints.
So, Do constraints enforce rules at the view level or not? If not, what is correct answer to the question |
|
|
 snehalatha |
| Posted: Nov 06, 2006 12:57:50 AM |  |
|
Total Post: 169
Joined: Apr, 2006
|
Constraints enforce rules at the view level. This is true
Following are the View Constraints:
1)check option constraints
2) read-only constraints
3) primary key constraints
4) unique key constraints
5) RI constraints
You can specify only unique, primary key, and foreign key constraints on views. However, you can define the view using the WITH CHECK OPTION clause, which is equivalent to specifying a check constraint for the view. And also View constraints are supported only in DISABLE NOVALIDATE mode. You must specify the keywords DISABLE NOVALIDATE.
ex:
ALTER VIEW view_emp1
ADD CONSTRAINT con_view_emp
UNIQUE (Ename) DISABLE NOVALIDATE
This helps you
|
|
|
|
|
| ozkucur |
| Posted: Nov 07, 2006 04:46:53 AM | |
|
Total Post: 23
Joined: Oct, 2006
|
Hi snehalatha.
It was not clear to me that, "WITH CHECK OPTION" and "WITH READ ONLY" view flags were actually constraints.
This clears out the answer. Thanks.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
