In the following query how many rows will be deleted?DELETE EmployeeWH – McqOptions

MCQOPTIONS

1.	In the following query how many rows will be deleted? DELETE Employee WHERE Emp_id=101; /person_id is a primary key /
A.	0
B.	No row
C.	1
D.	All of above
E.	None of these
Answer» D. All of above

Discussion

No Comment Found

Related MCQs

In the following query how many rows will be deleted?<br><pre class="prettyprint lang-c">DELETE Student<br>WHERE stu_id < 10;<br>/*person_id is a primary key */<br></pre>
In the following query how many rows will be deleted?<br><pre class="prettyprint lang-c">DELETE Employee<br>WHERE Emp_id=101;<br>/*person_id is a primary key */<br></pre>
What is abc in the following statement?<br><pre class="prettyprint lang-c">DELETE FROM Student WHERE Student_id= 0050;<br></pre>
What is xyz in the following statement?<br><pre class="prettyprint lang-c">DELETE FROM Employee WHERE Emp_id= 0012;<br></pre>
What is xyz in the following statement?
In the following query how many rows will be deleted?
What is abc in the following statement?