T

Tina Singh • 10.85K Points
Tutor II 

Q. What does the DISTINCT Clause do?

  • (A) Specify the columns of the table in this SQL clause to return distinct values.
  • (B) By executing this SQL statement, all records in the SQL database will be deleted.
  • (C) The data specified in this table or view is reported in this SQL statement.
  • (D) Changes made in the SQL database transaction are permanently saved using this SQL statement.
  • Correct Answer - Option(A)
  • Views: 133
  • Filed under category MySQL
Explanation by: Tina Singh 
Specify the columns of the table in DISTINCT SQL clause to return distinct values.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. Which among the following are the correct representation of "float(4,2)"?

Q. Which error occurs while the program is running and cannot be detected by the PL/SQL compiler?

Q. How many of the following use NULL to indicate failure?

Q. In the following SQL query, what does "person_id" stands for? CREATE TABLE person (person_ id SMALLINT UNSIGNED, fname VARCHAR(20), lname VARCHAR(20), CONSTRAINT pk_person PRIMARY KEY (person_id));

Q. In a LIKE clause, you can ask for any 6 letter value by writing

Q. The data directory subdirectory that corresponds to the nbdinfo database is . . . . . . . .

Q. SHOW DATABASES lists the databases in the server to which you are connected.

Q. Which clause is similar to "HAVING" clause in Mysql?

Q. Which mode is used to turn off the special meaning of backslash and treat it as an ordinary character?

Q. The option that executes all SQL statements in a SQL script irrespective of the number of errors is . . . . . . . .

Learn All MySQL MCQs

Question analytics