gs gs115 SQL Constraints - SQL Primary 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 7 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 uniquely identify each record in a table?
UNIQUE
PRIMARY KEY
NOT NULL
CHECK
Question 4: Which of the following statement can be used to apply the primary key constraint to a column?
CREATE TABLE table_name ( column1 datatype NOT NULL PRIMARY KEY, column2 datatype, ... columnn datatype);CREATE TABLE table_name ( PRIMARY KEY column1 datatype NOT NULL, column2 datatype, ... columnn datatype);CREATE TABLE table_name PRIMARY KEY ( column1 datatype NOT NULL, column2 datatype, ... columnn datatype);CREATE TABLE table_name ( column1 datatype NOT NULL PRIMARY KEY, column2 datatype, ... columnn datatype PRIMARY KEY (column1));
Question 5: 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));
Question 6: Which of the following statement can be used to apply the PRIMARY KEY constraint to a column of an existing table?
ALTER TABLE table_name ADD column_name PRIMARY KEY;ALTER TABLE table_name column_name ADD PRIMARY KEY;ALTER TABLE table_name ADD PRIMARY KEY (column_name);ALTER TABLE Persons PRIMARY KEY (ID);
Question 7: Which of the following statement can be used to drop the PRIMARY KEY constraint form a table?
ALTER TABLE table_name DROP PRIMARY KEY;ALTER TABLE table_name DROP PRIMARY KEY (column_name);ALTER TABLE table_name DELETE PRIMARY KEY;ALTER TABLE table_name DELETE PRIMARY KEY (column_name);
