Question

If in Table “account”, a column “cust_id” consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement?

SELECT DISTINICT cust_id
FROM account;

a.

{1, 2, 2, 3, 3, 5, 6, 7, 8, 8}

b.

{1, 2, 3, 5, 6, 7, 8}

c.

{ }

d.

None of the mentioned

Posted under MySQL Database

Answer: (b).{1, 2, 3, 5, 6, 7, 8}

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. If in Table “account”, a column “cust_id” consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement?

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!

Java Programming

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

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...

MS Office

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

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

Big Data Computing

Enhance your understanding of Big Data Computing with our comprehensive MCQs. Explore...

Object Oriented Programming Using C++

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

Data Warehousing and OLAP

Strengthen your knowledge of Data Warehousing and OLAP with our specialized MCQs....

Wireless and Mobile Communications

Get to grips with modern communication technologies with our Wireless and Mobile...

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...