PrepAway - Latest Free Exam Questions & Answers

Which of the following SQL statements will remove all rows that had a SALES_DATE in the year 1995?

Given the following table definition:
SALES
————————–
SALES_DATE DATE
SALES_PERSON CHAR(20)
REGION CHAR(20)
SALES INTEGER
Which of the following SQL statements will remove all rows that had a SALES_DATE in the year

1995?

PrepAway - Latest Free Exam Questions & Answers

A.
DELETE * FROM sales WHEREYEAR(sales_date) = 1995

B.
DELETE FROM sales WHEREYEAR(sales_date) = 1995

C.
DROP * FROM sales WHEREYEAR(sales_date) = 1995

D.
DROP FROM sales WHEREYEAR(sales_date) = 1995


Leave a Reply