Which Of The Following Statement Can Be Used To Make A #368
Which of the following statement can be used to make a composite PRIMARY KEY?
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 Primary Key - Quiz No.1.
Which of the following statement can be used to make a composite PRIMARY KEY?
CREATE TABLE table_name ( column1 datatype constraint_type, column2 datatype constraint_type, ... columnn datatype constraint_type, constraint_name PRIMARY KEY (column1, column2));CREATE TABLE table_name ( column1 datatype constraint_type, column2 datatype constraint_type, ... columnn datatype constraint_type, CONSTRAINT constraint_name PRIMARY KEY);CREATE TABLE table_name ( column1 datatype PRIMARY KEY, column2 datatype PRIMARY KEY, ... columnn datatype constraint_type);CREATE TABLE table_name ( column1 datatype constraint_type, column2 datatype constraint_type, ... columnn datatype constraint_type, CONSTRAINT constraint_name PRIMARY KEY (column1, column2));
