Question

If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL command?

SELECT emp_id
FROM person
ORDER BY emp_id ASC;

a.

{9, 7, 6, 4, 3, 1, 2}

b.

{1, 2, 3, 4, 6, 7, 9}

c.

{2, 1, 3, 4, 6, 7, 9}

d.

None of the mentioned

Posted under MySQL Database

Answer: (b).{1, 2, 3, 4, 6, 7, 9}

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL command?

Add Comment

Suggested Topics

Are you eager to expand your knowledge beyond MySQL Database? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...

DBMS

Get a firm grasp on database systems with our DBMS MCQs. Explore relational...

Object Oriented Programming Using C++

Enhance your programming skills with our MCQs on Object Oriented Programming using...

SQL Server

Master Microsoft's database server with our SQL Server MCQs. Topics cover database...

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...

Compiler Design

Unravel the process of translating source code into executable programs with our...

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....