Question 1

DELETE from Customer

will:

Group of answer choices

a.)Delete all records from the Customer Table

b.)Delete the Customer Database

c.)Delete all tables from the Customer DB

d.)Delete the Customer Table

Question 2

Use the RESTORE command to recall deleted records

Group of answer choices

a.)True

b.)False

Question 3

Given the fields (in the exact order), MemberID, Name, and Address. Which is not a valid insert statement?

Group of answer choices

a.)INSERT INTO MEMBER (MemberID, Name, Address) values (1,Dave Jones, 123 Main)

b.) INSERT INTO MEMBER VALUES (1,Dave Jones, 123 Main)

c.)All are valid

d.)INSERT INTO MEMBER (MemberID, Address, Name) VALUES (1, 123 Main,Dave Jones)

Question 4

SELECT * into newMembers FROM Members

Is equivalent to:

Insert into newMembers SELECT * from Members

assuming the Members table already exists (I suggest you investigate).

Group of answer choices

a.)True

b.)False

Question 5

UPDATE SalesTeam set Sales=20000

Will set all Sales, for all records to 20000

Group of answer choices

a.)True

b.)False