consider the following queries create table foo id int primary key..., MySQL, Databases

Test
- Model Test
Index

Question: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?

A Two tables are created 
B 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 
C Those queries are invalid 
D If a row with id = 2 in table foo is deleted, all rows with foo_id = 2 in table foo2 are deleted

/71

+ AnswerD

+ Report

Descriptive on MySQL Ebook

Total Preview: 952

Question: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?

A Two tables are created

B 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

C Those queries are invalid

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

D

Question: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?