gs gs115 SQL Constraints - SQL Not Null - 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 ensure that the data present in a column of a table is not empty?
NULL
UNIQUE
NOT NULL
PRIMARY KEY
Question 4: Which of the following statement is used to apply the NOT NULL constraint?
CREATE TABLE table_name ( column1 data_type NOT NULL, column2 data_type NOT NULL, ... columnn data_type NOT NULL);CREATE TABLE table_name ( NOT NULL column1 data_type, NOT NULL column2 data_type, ... NOT NULL columnn data_type);CREATE TABLE table_name ( column1 data_type, column2 data_type, ... columnn data_type, NOT NULL (column1, column2,..., columnn));CREATE TABLE table_name NOT NULL ( column1 data_type, column2 data_type, ... columnn data_type);
Question 5: Which of the following combination of statements can be used to add the NOT NULL constraint to an existing column?
UPDATE table_name SET column_name = <value> WHERE column_name IS NULL; & ALTER TABLE table_name ALTER COLUMN column_name data_type NOT NULL;UPDATE table_name SET column_name = <value> WHERE column_name IS NOT NULL; & ALTER TABLE table_name ALTER COLUMN column_name data_type IS NULL;UPDATE table_name SET column_name = <value>; & ALTER TABLE table_name ALTER COLUMN column_name data_type NOT NULL;UPDATE table_name SET column_name = <value> WHERE column_name IS NULL; & ALTER TABLE table_name ALTER COLUMN column_name data_type;
Question 6: Which of the following statement can be used to remove the NOT NULL constraint from an existing column?
ALTER TABLE table_name ALTER COLUMN column_name data_type IS NULL;ALTER TABLE table_name ALTER COLUMN column_name data_type NOT NULL;ALTER TABLE table_name ALTER COLUMN column_name data_type;ALTER TABLE table_name ALTER COLUMN column_name data_type NULL;
Question 7: Which of the following operator is used to test a column for empty values in SQL?
IS NULL
IS NOT NULL
NOT NULL
NULL
