gs gs115 SQL Constraints - SQL Default Constraint - 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 5 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: Which of the following constraint is used to provide a default value to a column in SQL?
CHECK
DEFAULT
NOT NULL
PRIMARY KEY
Question 2: Which of the following statement is used to apply the DEAFULT constraint to a column in SQL?
CREATE TABLE table_name DEFAULT ( column1 datatype value, column2 datatype value, ... columnn datatype value);CREATE TABLE table_name ( column1 datatype, column2 datatype, ... columnn datatype DEFAULT (column1, column2,… columnn) value);CREATE TABLE table_name ( DEFAULT column1 datatype value, DEFAULT column2 datatype value, ... DEFAULT columnn datatype value);CREATE TABLE table_name ( column1 datatype DEFAULT value, column2 datatype DEFAULT value, ... columnn datatype DEAFULT value);
Question 3: Which of the following statement can be used to apply the DEFAULT constraint on a column in an existing table?
ALTER TABLE table_name ALTER column_name SET DEFAULT value;ALTER TABLE table_name ALTER column_name DEFAULT value;ALTER TABLE table_name column_name SET DEFAULT value;ALTER TABLE table_name CHANGE column_name SET DEFAULT value;
Question 4: Which of the following statement is used to delete the DEFAULT constraint from a column in an existing column?
ALTER TABLE table_name ALTER DELETE DEFAULT;ALTER TABLE table_name ALTER DROP DEFAULT;ALTER TABLE table_name ALTER City DROP DEFAULT;ALTER TABLE table_name ALTER City DELETE DEFAULT;
