Which Of The Following Statement Can Be Used To Apply The #378
Which of the following statement can be used to apply the FOREIGN KEY constraint on more than on column in a table?
This multiple choice question (MCQ) is related to the book/course
gs gs115 Structured Query Language.
It can also be found in
gs gs115 SQL Constraints - SQL Foreign Key - Quiz No.1.
Which of the following statement can be used to apply the FOREIGN KEY constraint on more than on column in a table?
CREATE TABLE child_table ( column1 datatype constraint, ... columnn datatype constraint, FOREIGN KEY (col1, col2,...) REFERENCES (col1,col2));CREATE TABLE child_table ( column1 datatype constraint, ... columnn datatype constraint, FOREIGN KEY (col1) REFERENCES parent_table (col1), FOREIGN KEY (col2) REFERENCES parent_table (col2));CREATE TABLE child_table ( column1 datatype constraint, ... columnn datatype constraint, FOREIGN KEY (col1, col2,...) REFERENCES parent_table (col1,col2));CREATE TABLE child_table ( column1 datatype constraint, ... columnn datatype constraint, FOREIGN KEY (col1, col2,...) REFERENCES parent_table);
