A

Akshay Kulkarni • 3.46K Points
Extraordinary 

Q. Which keyword is used instead of the assignment operator to initialize variables?

  • (A) NOT NULL
  • (B) DEFAULT
  • (C) %TYPE
  • (D) %ROWTYPE
  • Correct Answer - Option(B)
  • Views: 131
  • Filed under category MySQL
Explanation by: Akshay Kulkarni 
Using the default value for a variable will give it a typical value. The value for that variable will be fixed.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on MySQL

Q. "CREATE VIEW ..." command is used to create which type of table in Mysql?

Q. Which of the following is not a schema object?

Q. FULLTEXT indexes can be created only for . . . . . . . .

Q. Is there any error in executing the following MySQL command? SELECT USER (), VERSION (), DATABASE ();

Q. How is the binary log rotated?

Q. For which of the following are triggers not supported?

Q. What is generally done after the transactions are executed successfully?

Q. How is the output from PHP generated?

Q. If emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the following MySQL statement? SELECT emp_id FROM person ORDER BY emp_id;

Q. Which of these is preferred when stored procedures are not being used? CLIENT_MULTI_STATEMENTS, mysql_set_server_option()

Learn All MySQL MCQs

Question analytics