A

Admin • 36.96K Points
Coach 

Q. Which key declares that an index in one table is related to that in another?

  • (A) primary
  • (B) ALTER DATABASE
  • (C) foreign
  • (D) cross
  • Correct Answer - Option(C)
  • Views: 11
  • Filed under category MySQL
Explanation by: Admin 
This question asks about the type of key that links an index in one table to an index in another table.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. What is the embedded server library containing the MySQL server linkable into applications?

Q. Which statements are used to control a cursor variable?

Q. What is the similarity between CLOB and NCLOB Oracle Large Object Data Types?

Q. MySQL client runs on the machine containing the databases and servers connect to the client over a network.

Q. The exec_stmt_ssl is written in . . . . . . . .

Q. Which clause is used to rename the existing table?

Q. In the following MySQL command how many rows will be updated? UPDATE person SET lname=’s’, Fname = ’p’, WHERE person_id = 1; /* person_id is a primary key */

Q. The TRIGGER privilege is used for the table to be able to create and drop triggers for it.

Q. The right shift operator is . . . . . . . .

Q. The following MySQL query belongs to which condition types? SELECT fname FROM person WHERE title=’TELLER’;

Learn All MySQL MCQs

Question analytics