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: Q144
written 19 January 2008 10:09   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
This statement provides correct syntax to define the FOREIGN KEY constraint on the DEPTNO column of the EMP table.
Incorrect Answers:
1: There is incorrect syntax, because list of columns and column for the constraint need to be surrounded with the brackets.
3: It is incorrect to use FOREIGN KEY keywords to define constraint on the table. It can be used to add integrity constraint to existing table.
4: It is incorrect to use FOREIGN KEY keywords to define constraint on the table. It can be used to add integrity constraint to existing table.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 238-245
Chapter 5: Creating Oracle Database Objects

Current tread:
back to list

Q144 - Go to question 10:09 19.01.08

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