Skip to content

Quiz on Constraints in SQL

Quiz on Constraints in SQL

Time limit: 0

Quiz Summary

0 of 10 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 10 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

Review / Skip
Answered
Correct
Incorrect

Question 1 of 10

1. Question

What is the purpose of a constraint in SQL?

To improve query speed
Correct Incorrect Correct answer

To manage user access
Correct Incorrect Correct answer

To enforce rules on data in tables
Correct Incorrect Correct answer

To store large amounts of data
Correct Incorrect Correct answer

Correct

Incorrect
Question 2 of 10

2. Question

Which constraint ensures that a column cannot have NULL values?

UNIQUE
Correct Incorrect Correct answer

DEFAULT
Correct Incorrect Correct answer

PRIMARY KEY
Correct Incorrect Correct answer

NOT NULL
Correct Incorrect Correct answer

Correct

Incorrect
Question 3 of 10

3. Question

Which constraint ensures all values in a column are different?

CHECK
Correct Incorrect Correct answer

UNIQUE
Correct Incorrect Correct answer

FOREIGN KEY
Correct Incorrect Correct answer

INDEX
Correct Incorrect Correct answer

Correct

Incorrect
Question 4 of 10

4. Question

What does a PRIMARY KEY constraint do?

Allows NULL values
Correct Incorrect Correct answer

Ensures values are unique and not null
Correct Incorrect Correct answer

Creates a temporary table
Correct Incorrect Correct answer

Adds comments to code
Correct Incorrect Correct answer

Correct

Incorrect
Question 5 of 10

5. Question

Which constraint is used to link two tables together?

NOT NULL
Correct Incorrect Correct answer

UNIQUE
Correct Incorrect Correct answer

FOREIGN KEY
Correct Incorrect Correct answer

DEFAULT
Correct Incorrect Correct answer

Correct

Incorrect
Question 6 of 10

6. Question

What is the function of the CHECK constraint?

Ensures foreign key mapping
Correct Incorrect Correct answer

Prevents duplicate values
Correct Incorrect Correct answer

Sets a condition for valid data
Correct Incorrect Correct answer

Limits the size of the table
Correct Incorrect Correct answer

Correct

Incorrect
Question 7 of 10

7. Question

Which constraint is used to automatically assign a value if none is provided?

DEFAULT
Correct Incorrect Correct answer

CHECK
Correct Incorrect Correct answer

PRIMARY KEY
Correct Incorrect Correct answer

UNIQUE
Correct Incorrect Correct answer

Correct

Incorrect
Question 8 of 10

8. Question

How many PRIMARY KEYs can a table have?

One
Correct Incorrect Correct answer

Two
Correct Incorrect Correct answer

Unlimited
Correct Incorrect Correct answer

It depends on the database
Correct Incorrect Correct answer

Correct

Incorrect
Question 9 of 10

9. Question

Which constraint combination is most commonly used to identify each record uniquely?

UNIQUE + DEFAULT
Correct Incorrect Correct answer

NOT NULL + DEFAULT
Correct Incorrect Correct answer

PRIMARY KEY
Correct Incorrect Correct answer

FOREIGN KEY
Correct Incorrect Correct answer

Correct

Incorrect
Question 10 of 10

10. Question

What happens if a FOREIGN KEY constraint is violated during insertion?

The row is added anyway
Correct Incorrect Correct answer

NULL value is inserted
Correct Incorrect Correct answer

An error is thrown
Correct Incorrect Correct answer

The key is auto-created
Correct Incorrect Correct answer

Correct

Incorrect

Fill the form to proceed
Upskill & get ready for AI-era

Please leave this field empty.

Δ

Our executives will contact you shortly

Have Questions?
Talk directly to the Instructor

Please leave this field empty.

Δ

Our executives will arrange a call with the Instructor shortly

talk to the instructor

Career Counselling

Please leave this field empty.

Δ

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Signup / Login with Google

Signup / Login with X

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account