
Constraints in SQL
Quiz
•
Computers
•
University
•
Medium
ALDO STALIN J L
Used 1+ times
FREE Resource
Enhance your content
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What does the ALTER TABLE clause do?
The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints
The SQL ALTER TABLE clause is used to insert data into database table
THE SQL ALTER TABLE deletes data from database table
The SQL ALTER TABLE clause is used to delete a database table
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Correct syntax query syntax to drop a column from a table is
DELETE COLUMN column_name;
DROP COLUMN column_name;
ALTER TABLE table_name DROP COLUMN column_name;
None is correct.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
SQL has how many main commands for DDL:
1
2
3
4
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which command is used for removing a table and all its data from the database:
Create command
Drop table command
Alter table command
All of the mentioned
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following language is used to specify database Schema ?
DDL
DML
DCL
None
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is NOT a type of SQL constraint?
Primary Key
Foreign Key
Alternate Key
Unique
NOT NULL
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
16 questions
Ôn tập Tin học Lớp 3_CKI
Quiz
•
3rd Grade - University
20 questions
Database-Normalisation
Quiz
•
9th Grade - University
20 questions
Excel
Quiz
•
University
18 questions
Multiplexers
Quiz
•
University
15 questions
NSCC-CODE TO COIN
Quiz
•
University
20 questions
UAS Struktur Data 2022
Quiz
•
University
17 questions
Grade 4 Computer Science Quiz
Quiz
•
4th Grade - University
20 questions
DBTHON-23 Round-1
Quiz
•
University
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
11 questions
NEASC Extended Advisory
Lesson
•
9th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
10 questions
Boomer ⚡ Zoomer - Holiday Movies
Quiz
•
KG - University
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
20 questions
Multiplying and Dividing Integers
Quiz
•
7th Grade
Discover more resources for Computers
10 questions
Boomer ⚡ Zoomer - Holiday Movies
Quiz
•
KG - University
22 questions
FYS 2024 Midterm Review
Quiz
•
University
20 questions
Physical or Chemical Change/Phases
Quiz
•
8th Grade - University
20 questions
Definite and Indefinite Articles in Spanish (Avancemos)
Quiz
•
8th Grade - University
7 questions
Force and Motion
Interactive video
•
4th Grade - University
12 questions
1 Times Tables
Quiz
•
KG - University
20 questions
Disney Trivia
Quiz
•
University
38 questions
Unit 6 Key Terms
Quiz
•
11th Grade - University
