| OracleSQL - Exam Revision help [message #319173] |
Fri, 09 May 2008 04:50  |
Jazzy20
Messages: 2
Registered: May 2008
Location: Hull, UK
|
Junior Member |
|
|
Hi guys. Been looking over this forum the past couple of days, specifically in this section.
Ive just got afew questions to ask to help me prep for my exam next Friday.
---------------------------------------------------------------
8. Describe briefly what each of the following terms means with regard to integrity constraints. Explain in each case when the integrity constraint is checked.
a. NOT DEFERRABLE
b. DEFERRABLE INITIALLY DEFERRED
c. DEFERRABLE INITIALLY IMMEDIATE
--------------------------------------------------------------
This specific question will be on the exam, people who took this before said it appears all the time, ive searched google and comes up with nothing relevent.
Ive got more to ask but im looking though my lecture notes to find the answers. Is it possible to ask afew more if i get stuck? i don't feel confidant about the exam yet, but i want that to change and do the best as i can.
Thanks 
[Updated on: Fri, 09 May 2008 04:51] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: OracleSQL - Exam Revision help [message #319215 is a reply to message #319200] |
Fri, 09 May 2008 06:21  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
This looks like it's testing your ability to write nested OR statements.
The question as prsented seems quite ambiguous.
I think the best interpretation of it is probably this, but I'm quite possibly wrong. It's quite possible that the Forename, Surname and Courses are meant to be one clause.
except (students whose student number is ‘P4420’)
or (whose Forename is either ‘Richard’ or ‘Judy’),
or (( either their Surname ends in ‘ing’) or (they are on one of the courses identified by ‘C4567’,’D4567’ and ‘X4520’))
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
