R

Ritu Singhal • 4.36K Points
Extraordinary 

Q. Which clause is used to remove a foreign key constraint?

  • (A) REMOVE
  • (B) DELETE
  • (C) DROP
  • (D) EXCLUDE
  • Correct Answer - Option(C)
  • Views: 19
  • Filed under category MySQL
Explanation by: Ritu Singhal 
This question asks about removing a special rule called a foreign key constraint in a MySQL database.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. Which subquery cannot be executed by itself as a separate statement?

Q. The table that lists the column level privileges is . . . . . . . .

Q. The generic handle whose meaning depends on context is . . . . . . . .

Q. The mode used to turn off the special meaning of backslash and treat it as an ordinary character is

Q. What will be the output of the following MySQL statement? SELECT customer_id, product_id, avail_balance FROM account WHERE avail_balance BETWEEN 3000 AND 5000.

Q. INT2 maps to MySQL type . . . . . . . .

Q. MySQL Access security is controlled through

Q. Which option is used to specify to the server the IP number of the server host on which the server should listen?

Q. The values of any IN OUT parameters are copied before the subprogram is executed.

Q. Which of the following is TRUE about SQL Auto Increment?

Learn All MySQL MCQs

Question analytics