R

Ritu Singhal • 4.36K Points
Extraordinary 

Q. Find odd one out?

  • (A) GROUP BY
  • (B) DESC
  • (C) ASC
  • (D) ORDER BY
  • Correct Answer - Option(A)
  • Views: 12
  • Filed under category MySQL
Explanation by: Ritu Singhal 
Among the given options, GROUP BY is the odd one out.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. Find the error in the following SQL statement? CREATE TABLE person ( person_id SMALLINT, name VARCHAR, LAST VARCHAR, Bith_date DATE CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, LAST, Birth_date) (1,’s’,’p’, 24-1991-01);

Q. Which function returns NULL if expr1 = expr2?

Q. Which function returns an array of row values?

Q. What is the maximum collations a character set can have?

Q. Which are the two languages used in Mysql?

Q. Which among the following tags belong to Data Manipulation language?

Q. The 'SOCKET' protocol is permitted on which operating systems?

Q. How are identifiers quoted in MySQL?

Q. Suppose you have two columns named student_name and student_department inside table student_details and you are asked to update the value of these two columns where ID=4 then what statement you will write?

Q. The stored-routine privileges are contained in . . . . . . . .

Learn All MySQL MCQs

Question analytics