> > >

MySQL MCQs

Consider the following queries:
create table foo (id int primary key auto_increment, name int);
create table foo2 (id int auto_increment primary key, foo_id int references foo(id) on delete cascade);
Which of the following statements is true?

Two tables are created

If a row in table foo2, with a foo_id of 2 is deleted, then the row with id = 2 in table foo is automatically deleted

Those queries are invalid

If a row with id = 2 in table foo is deleted, all rows with foo_id = 2 in table foo2 are del

Answer

Correct Answer: If a row with id = 2 in table foo is deleted, all rows with foo_id = 2 in table foo2 are del

Explanation:

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it