R

Ritu Singhal • 4.36K Points
Extraordinary 

Q. Which clause is mandatory with clause "SELECT" in Mysql?

  • (A) FROM
  • (B) WHERE
  • (C) Both FROM and WHERE
  • (D) None of the mentioned
  • Correct Answer - Option(A)
  • Views: 23
  • Filed under category MySQL
Explanation by: Ritu Singhal 
This question is about the parts of a MySQL query that lets you get information from a database.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on MySQL

Q. The option that suppresses output unless there are errors in the table is . . . . . . . .

Q. What is the number of attributes in the following SQL table? CREATE TABLE employee ( emp_name CHAR(30), emp_id INT );

Q. What is the default format for "Date" data type?

Q. Which subtypes are used to declare fixed-point numbers with a maximum precision of 38 decimal digits?

Q. Which clause is used to "filter out unwanted Groups"?

Q. Which is the correct format to store date in the SQL?

Q. Consider a database name "db_name" whose attributes are intern_id (primary key), subject. Intern_id = {1, 2, 3, 4, 5, 6} Subject = {sql, oop, sql, oop, c, c++} If these are one to one relation then what will be the output of the following MySQL statement? SELECT intern_id FROM db_name WHERE subject IN (c, c++);

Q. MySQL is

Q. What is the default format for "Time" data type?

Q. What is the datatype for single precision floating point number?

Learn All MySQL MCQs

Question analytics