Which Of The Following Statement Can Be Used To Apply The #374
Which of the following statement can be used to apply the FOREIGN KEY constraint in SQL?
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 in SQL?
CREATE TABLE table_name ( column1 datatype constraint, column2 datatype constraint, ... columnn datatype constraint, FOREIGN KEY parent_table (column_name));
CREATE TABLE table_name ( column1 datatype constraint, column2 datatype constraint, ... columnn datatype constraint, FOREIGN KEY REFERENCES parent_table (column_name));
CREATE TABLE table_name ( column1 datatype constraint, column2 datatype constraint, ... columnn datatype constraint, FOREIGN KEY (column_name) REFERENCES (column_name));
CREATE TABLE table_name ( column1 datatype constraint, column2 datatype constraint, ... columnn datatype constraint, FOREIGN KEY (column_name) REFERENCES parent_table (column_name));