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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!