Explore topic-wise MCQs in Mysql.

This section includes 7 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.

1.

In the following query how many rows will be deleted?
DELETE Student
WHERE stu_id < 10;
/*person_id is a primary key */
A. No row
B. 0-9
C. 1-7
D. All of above
E. None of these
Answer» C. 1-7
Discussion
2.

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
3.

What is abc in the following statement?
DELETE FROM Student WHERE Student_id= 0050;
A. server name
B. column name
C. database name
D. table name
E. None of these
Answer» E. None of these
Discussion
4.

What is xyz in the following statement?
DELETE FROM Employee WHERE Emp_id= 0012;
A. database name
B. row name
C. table name
D. column name
E. None of these
Answer» D. column name
Discussion
5.

What is xyz in the following statement?

A. database name
B. row name
C. table name
D. column name
E. None of these
Answer» D. column name
Discussion
6.

In the following query how many rows will be deleted?

A. 0
B. No row
C. 1
D. All of above
E. None of these
Answer» D. All of above
Discussion
7.

What is abc in the following statement?

A. server name
B. column name
C. database name
D. table name
E. None of these
Answer» E. None of these
Discussion