Question

the following query how many rows will be deleted?

DELETE student

WHERE student_id=109;

a. 1 row

b. All the rows where student ID is equal to 109

c. No row will be deleted

d. 2 rows​

Answer 1

Answer:

option (b) i guess

Explanation:

BTW mark me as brainliest

Answer 2

No delete action will take place on any row.

Explanation:

• DELETE in SQL is a Data Manipulation Language command.
• It does not change the structure or definition of a table or schema.
• Hence, it is used to remove rows or required numbers of records from an existing table.
• In order to remove a row from a table for a given condition following query is appropriate: DELETE FROM <table_name> WHERE <condition>
• Here, in the given query the command word 'FROM' is missing making the whole query incorrect.
• Hence, no delete action will take place.