M

Mr. Dubey • 53.53K Points
Coach 

Q. What is the meaning of “EMPTY SET” in the following query?

Code: 
SELECT First_name, Last_name, Emp_id
FROM Employee
WHERE Last_name=’Gupta’;
/* after Execution*/ Mysql tool RETURN EMPTY SET 0:00sec
  • (A) Error
  • (B) Access denied
  • (C) No values
  • (D) Syntax errors
  • Correct Answer - Option(B)
  • Views: 131
  • Filed under category MySQL

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on MySQL

Q. How are identifiers quoted in MySQL?

Q. Arrays cannot have associative indices in PHP.

Q. Which of the following returns all distinct rows selected by either query?

Q. Which of the following statements is/are correct?

Q. The "Mysql command line tool" formats are bounded by . . . . . . . .

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? SELECT emp_id FROM person ORDER BY emp_id DESC;

Q. The value of event_scheduler that enables checking status but not changing it at runtime is . . . . . . . .

Q. The Audit_log_events system variable is of type . . . . . . . .

Q. Which of these has higher priority? writes, reads

Q. Regardless of whether a database or table name is case sensitive on the system, it must be referred to using the same lettercase throughout a given query.

Learn All MySQL MCQs

Question analytics