
SQL and Database Design Quiz

Quiz
•
Other
•
University
•
Medium
33KAZ undefined
Used 1+ times
FREE Resource
25 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL keyword is used to enforce a condition that a column cannot contain NULL values?
NOT NULL
PRIMARY KEY
UNIQUE
CHECK
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a partial dependency in database design?
When a non-key attribute depends on only part of a composite key
When a foreign key links two tables
When a column can store multiple values
When a primary key is not unique
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In SQL, which of the following is a character data type?
BOOLEAN
CHAR
INT
DATE
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In SQL, how do you ensure that a column must always have a value?
By adding the FOREIGN KEY constraint
By adding the NOT NULL constraint
By adding the CHECK constraint
By adding the UNIQUE constraint
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the SELECT statement in SQL?
To modify existing records
To create a new table
To delete data
To retrieve data from a database
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a "bad" design for a database table?
A table without NULL values
A table with redundant data
A table with atomic values
A table with a foreign key
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In SQL, which of the following commands is used to remove a table from the database?
REMOVE TABLE
DELETE TABLE
ALTER TABLE
DROP TABLE
Create a free account and access millions of resources
Similar Resources on Wayground
20 questions
DBMS

Quiz
•
University
23 questions
MSA Basics

Quiz
•
University
20 questions
Set 1 Quiz

Quiz
•
University
30 questions
Database Systems Quiz SE(Blue)

Quiz
•
University
30 questions
SQL Basics Quiz

Quiz
•
University
30 questions
SOAL DATABASE PART 1

Quiz
•
1st Grade - Professio...
30 questions
SMK PK_UAS 2024_BASIS DATA_XII RPL-1

Quiz
•
12th Grade - University
20 questions
UAS Basis Data

Quiz
•
University
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade