A

Admin • 36.96K Points
Coach 

Q. Which of the following is an illegal unquoted identifier name?

  • (A) id1
  • (B) 123
  • (C) 123id
  • (D) 123_id
  • Correct Answer - Option(D)
  • Views: 149
  • 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. The function 'fetchrow_hashref()' returns reference to hash of row values keyed by . . . . . . . .

Q. The LOCAL capability for LOAD DATA does not need to be enabled explicitly.

Q. Which clause is used to sort the result by one or more columns?

Q. What sets up an association between one or more MyISAM tables and the named key cache?

Q. Which function returns reference to array of row values?

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

Q. If the PIPES_AS_CONCAT is disabled, 'abc' || 'xyz' results in . . . . . . . .

Q. The number of languages that have interfaces to bind to the C API of MySQL among these is . . . . . . . . Perl, PHP, Python

Q. What will be the output of the following MySQL command? SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’ AND start_date>2008-11-23;

Q. There can be more than one column per table with the AUTO_INCREMENT attribute.

Learn All MySQL MCQs

Question analytics