{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

weekly review 12 commentary - Question 1 Multiple Choice...

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

View Full Document Right Arrow Icon
Question 1: Multiple Choice Average Score 1.56652 points In the table created by the following query, which field(s) must have unique values? CREATE TABLE Books (Title char (200) NOT NULL, ISBN int PRIMARY KEY ) Correct Percent Answered ISBN 78.326% TITLE 9.871% Title and ISBN must be unique 9.657% Neither field must be unique. 2.146% Unanswered 0% Kai Zhao 5/3/12 11:12 AM Comment [1]: The ISBN field is the 'primary key'. Records must have unique entries in their primary key field
Background image of page 1

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

View Full Document Right Arrow Icon
Question 2: Multiple Choice Average Score 1.35622 points The figure below shows a record in the books table. Which (if any) of the following query or queries successfully insert(s) this record ? /*Query A*/ INSERT INTO books values (672325676, 'VBA for Excel', 'KZ', 20.07, 10.17) /*Query B*/ INSERT INTO books values (672325676, VBA for Excel, KZ, 20.07, 10.17) /*Query C*/ INSERT INTO books (ISBN, Title, Author, Price, usedPrice) values (672325676, 'VBA for Excel', 'KZ', 20.07, 10.17) /*Query D*/ INSERT INTO books (ISBN, Title, Author, Price, usedPrice) values (672325676, VBA for Excel, KZ, 20.07, 10.17) Correct Percent Answered Only query A 1.717% Only query B 0% Only query C 19.099%
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}