gs gs115 SQL Constraints - SQL Constraints - 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 6 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 3: In SQL, constraints can be divided into which of the following level?
Database level
Row level
Table level
Data level
Question 4: Which of the following is a constraint in SQL?
Candidate Key
Foreign Key
Alternate Key
Super Key
Question 5: Which of the following statement can be used to apply column level constraints to a table in SQL?
CREATE TABLE table_name( column1 data_type(size) constraint, column2 data_type(size) constraint, ... columnn data_type(size) constraint);CREATE TABLE table_name( constraint column1 data_type(size), constraint column2 data_type(size), ... constraint columnn data_type(size));CREATE TABLE table_name ( column1 data_type(size), column2 data_type(size), ... columnn data_type(size), constraint (column1,column2…columnn));CREATE TABLE table_name( column1 data_type(size), column2 data_type(size), ... columnn data_type(size));
Question 6: In SQL, which of the following constraint cannot be applied at the table level?
UNIQUE
PRIMARY KEY
CHECK
NOT NULL
