Explore topic-wise MCQs in Mysql.

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

1.	If attribute fruit stores data as apple, mango, banana in table person then what will be the output of the following query? SELECT fruit FROM Employee WHERE Emp_id=1 ORDER BY fruit;
A.	apple, banana, mango
B.	mango, apple, banana
C.	apple, mango, banana
D.	All of above
E.	None of these
Answer» B. mango, apple, banana

Discussion

2.	If attribute fruit stores data as apple, mango, banana in table person then what will be the output of the following query?
A.	apple, banana, mango
B.	mango, apple, banana
C.	apple, mango, banana
D.	All of above
E.	None of these
Answer» B. mango, apple, banana

Discussion

Explore topic-wise MCQs in Mysql.

If attribute fruit stores data as apple, mango, banana in table person then what will be the output of the following query?SELECT fruit FROM EmployeeWHERE Emp_id=1ORDER BY fruit;

If attribute fruit stores data as apple, mango, banana in table person then what will be the output of the following query?

If attribute fruit stores data as apple, mango, banana in table person then what will be the output of the following query?
SELECT fruit FROM Employee
WHERE Emp_id=1
ORDER BY fruit;