TEST 1

TEST 1 - Quiz Note: It is recommended that you save your...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Quiz Note: It is recommended that you save your response as you complete each question. Question 1 (2 points) Question 1 Unsaved ____ yields only the rows that appear in both tables. Question 1 options: 1) INTERSECT 2) UNION 3) DIFFERENCE 4) SELECT Question 2 (2 points) Question 2 Unsaved A ____ is any key that uniquely identifies each row. Question 2 options: 1) superkey 2) special 3) selective 4) candidate Question 3 (2 points) Question 3 Unsaved In an outer join, the matched pairs would be retained and any unmatched values in the other table would be left ____. Question 3 options: 1) in another table 2) null 3) out of the results 4) with matching values from the original table Question 4 (2 points) Question 4 Unsaved Since it is used to link the tables that originally were related in a M:N relationship, the composite entity structure includes-as foreign keys-at least the ____ keys of the tables that are to be linked. Question 4 options: 1)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
composite 2) super 3) primary 4) unique Question 5 (2 points) Question 5 Unsaved Accurate, relevant, and timely information is the key to ____. Question 5 options: 1) data management 2) good decision making 3) knowledge 4) understanding Question 6 (2 points) Question 6 Unsaved In the following table description, ____ is the primary key. PRODUCT (PROD_CODE, PROD_DESCRIPT, PROD_PRICE, PROD_ON_HAND, VEND_CODE) Question 6 options: 1) PROD_DESCRIPT 2) PROD_CODE 3) PROD_PRICE 4) PROD_ON_HAND Question 7 (2 points) Question 7 Unsaved In the relational model, ____ are important because they are used to ensure that each row in a table is uniquely identifiable Question 7 options: 1) relations 2) keys 3) indexes 4)
Background image of page 2
Question 8 (2 points) Question 8 Unsaved A(n) ____ is an ordered arrangement of keys and pointers. Question 8 options: 1) table 2) superkey 3) relationship 4) index Question 9 (2 points) Question 9 Unsaved If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that ____ key, the attribute (B) is fully functionally dependent on (A). Question 9 options: 1) foreign 2) unique 3) composite 4) complete Question 10 (2 points) Question 10 Unsaved A(n) ____ model represents a global view of the database as viewed by the entire organization. Question 10 options: 1) external 2) conceptual 3) internal 4) physical Question 11 (2 points) Question 11 Unsaved A(n) ____ enables a database administrator to define schema components. Question 11 options:
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 14

TEST 1 - Quiz Note: It is recommended that you save your...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online