Question: 18.3 Define the following terms: a) Qualified name b) Rule of Referential Integrity c) Rule of Entity Integrity d) selection criteria 18.4 State the purpose
18.3 Define the following terms:
a) Qualified name b) Rule of Referential Integrity c) Rule of Entity Integrity d) selection criteria
18.4 State the purpose of the following SQL keywords:
a) ASC b) FROM c) DESC d) INSERT e) LIKE f) UPDATE g) SET h) VALUES i) ON
18.6 Fill in the blanks in each of the following statements:
a) The _________ states that every column in a primary key must have a value, and the value of the primary key must be unique b) The ________ states that every foreign-key value must appear as another table's primary-key value. c) A(n) ________ in a pattern indicates that a string matching the pattern can have zero or more characters at that location in the pattern. d) Java DB is the Oracle branded version of ________. e) A(n) ________ in a LIKE pattern string indicates a single character at that position in the pattern. f) There's a(n) ________ relationship between a primary key and its corresponding foreign key. g) SQL uses ________ as the delimiter for strings.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
