English Русский Contacts Site map Add to favorites
Registration
Login
Master braindump list
New braindumps
Submit a dump
Get latest dump
braindumps.com.ua
flame
3COM (7)
Adobe (1)
BEA (1)
Checkpoint (22)
Cisco (20)
Citrix (21)
CIW (15)
Compaq (0)
CompTIA (51)
CWNA (2)
EMC (2)
Exin (4)
GEJOS (4)
HDI (1)
HP (4)
IBM (13)
Juniper (5)
Linux Prof Institute (LPI) (2)
Lotus (11)
Microsoft (2462)
Network Appliance (2)
Novell (16)
Oracle (423)
PLSQL (1)
PMI (5)
SAS (1)
Sun (87)
Teradata (4)
Login:
Password:
RSS feed

Contacts
Certification links
Links
Authorized users can post comments.
Please log in or sign up.

back to list
Back to main forum
Introduction to Oracle9i: SQL 

АвторSubject: Q186
written 19 January 2008 10:09   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
Tables that underlie views often have constraints that limit the data that can be added to those tables. Views cannot add data to the underlying table that would violate the table’s constraints. However, you can also define a view to restrict the user’s ability to change underlying table data even further, effectively placing a special constraint for data manipulation through the view. This additional constraint says that INSERT or UPDATE statements issued against the view are cannot create rows that the view cannot subsequently select. This constraint is configured when the view is defined by adding the WITH CHECK OPTION to the CREATE VIEW statement.
Incorrect Answers:
1: This view does not provide correct semantic of question task.
2: WITH READ ONLY clause is incorrect syntax in the CREATE VIEW command.
4: This view does not provide correct semantic of question task.
5: NO UPDATE clause is incorrect syntax in the CREATE VIEW command.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 301-303
Chapter 7: Creating Other Database Objects in Oracle

Current tread:
back to list

Q186 - Go to question 10:09 19.01.08

back to list
Up ^ gen. 0.058 Server date 04:46 10-01-2009 Developed by Zip © 2006 Up ^
Forum
Start online exam simulation
Master braindump
User braindumps
Main forum
Question comments