You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column. You execute the following statement:
DELETE FROM Student - What is the result?
A.
All rows in the table will be deleted.
B.
All rows containing a NULL value in the FirstName column will be deleted.
C.
You will receive an error message.
D.
All rows and the table definition will be deleted.
The DELETE statement is used to delete existing records in a table.
DELETE Syntax
DELETE FROM table_name WHERE condition;
Since the WHERE condition is NOT used, therefore all rows in the table will be deleted
This section is not available anymore. Please use the main Exam Page.98-364 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
syed5
Highly Voted 4 years, 11 months agoPink_Dreams
4 years, 5 months agoSihloniphise76
Highly Voted 5 years agodzoni68
Most Recent 3 years agoNgohMac_Donald
3 years, 7 months agonate91cx
4 years, 2 months agoestherjq
4 years, 2 months agoVishal_15
4 years, 7 months agoSaranepal
4 years, 9 months agoEntbak
4 years, 10 months ago