R

Ranjeet • 34.60K Points
Instructor I 

Q. The clause that enables mapping a short command to a long command is . . . . . . . .

  • (A) map
  • (B) direct
  • (C) label
  • (D) alias
  • Correct Answer - Option(D)
  • Views: 13
  • Filed under category MySQL
Explanation by: Ranjeet 
This question is about a special feature in MySQL that lets you use a short, easy-to-remember name to stand in for a longer, more complicated command. Imagine you have a very long command that you use often. Instead of typing it out every time, you can give it a nickname! This nickname is called an alias.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. The line that is not used to turn on the event scheduler is . . . . . . . .

Q. How do the STRICT_ALL_TABLES and STRICT_TRANS_TABLES mode values deal with bad data?

Q. The security context when a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access is . . . . . . . .

Q. The maximum non zero values for DOUBLE is . . . . . . . .

Q. Which table lists the accounts and the databases for which the privileges are provided?

Q. How is a stored procedure invoked?

Q. If you are asked to delete the entire data of a table without disturbing the table definition then in such case which statement you will use?

Q. Which is not an aggregate function?

Q. Which clause in the SQL standard controls how NULL values in a composite foreign key are handled when comparing to a primary key.

Q. What does LAST_INSERT_ID() return when no AUTO_INCREMENT value has been generated during the current connection?

Learn All MySQL MCQs

Question analytics