gs gs115 SQL Constraints - SQL Foreign Key - Quiz No.1
gs gs115 Structured Query Language Quiz
This quiz belongs to book/course code gs gs115 Structured Query Language of gs organization. We have 79 quizzes available related to the book/course Structured Query Language. This quiz has a total of 8 multiple choice questions (MCQs) to prepare and belongs to topic SQL Constraints. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: In SQL, which of the following constraint is used to establish a link between two tables?
PRIMARY KEY
LINK
FOREIGN KEY
CANDIDATE KEY
Question 4: 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));
Question 5: Which of the following statement is used to create the FOREIGN KEY constraint on an already existing table?
ALTER TABLE table_name ADD CONSTRAINT constraint_name FOREIGN KEY REFERENCES parent_table (column_name);ALTER TABLE table_name ADD CONSTRAINT constraint_name FOREIGN KEY (column_name) REFERENCES parent_table;ALTER TABLE table_name ADD CONSTRAINT constraint_name FOREIGN KEY (column_name) REFERENCES parent_table (column_name);ALTER TABLE table_name ADD CONSTRAINT constraint_name FOREIGN KEY (column_name) REFERENCES (column_name);
Question 6: Which of the following statement can be used to delete the FOREIGN KEY constraint from a table?
ALTER TABLE table_name DROP FOREIGN KEY constraint_name;ALTER TABLE table_name DROP FOREIGN KEY;ALTER TABLE table_name DELETE FOREIGN KEY constraint_name;ALTER TABLE table_name DELETE FOREIGN KEY;
Question 8: 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);
