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: 15
  • 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.

Be the first to start discuss.

Related MCQs on MySQL

Q. Which statement is used to check the status of the event scheduler at runtime?

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

Q. What is the work of INSERT command?

Q. The variable that returns code from operations that return true or false is . . . . . . . .

Q. SQL has the advantage of?

Q. Which of the following is the correct order of precedence (high to low)?

Q. The maximum non zero value for FLOAT is . . . . . . . .

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

Q. What is xyz in the following MySQL statement? CREATE VIEW xyz AS SELECT a, b FROM t;

Q. mysql_next_result() returns a status.

Learn All MySQL MCQs

Question analytics