Question
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started