NEW
Font size
WorksheetsDatabase Refreshment
Total questions: 20
Worksheet time: 7mins
What does ERD stand for?
Entity-Relationship Diagram
Excellent Resource Design
Every Row Depicts
Extra Relational Data
What is the purpose of normalization in a database?
Normalize emotions of developers
Reduce data redundancy
Improve data integrity
Make tables pretty
Which normal form eliminates transitive dependency?
1NF
2NF
3NF
Google Form
What does the acronym DDL stand for in database terminology?
Data Distribution Layer
Dynamic Data List
Database Data Language
Data Definition Language
In a relational database, a primary key must be:
A secret code
Repeated frequently
Able to unlock a treasure chest
Unique and not null
Which of these is an example of a many-to-many relationship?
Employees and Chairs
Cats and Owners (Cats own you, let’s be real😂)
Students and Classes
Managers and Coffee Machines
What is a foreign key?
A mysterious lost key in the data jungle
A key from another table
A key that speaks another language
A primary key in disguise
What does SQL stand for?
Spicy Query Linguistics
Super Quick Logic
Structured Query Language
Some Queries Lag
What is a database schema?
The structure of a database
A plot to overtake Excel
A schema to steal your data
A fancy name for a tablecloth
What is the result of a CROSS JOIN in SQL?
Two tables arguing over data
Rows where keys match
A cross-stitched database
All possible combinations of rows from two tables
Which of the following is not a database constraint?
UNIQUE
ENORMOUS
FOREIGN KEY
NOT NULL
What is a composite key?
A key composed of two or more columns
A key that unlocks composite materials
A combination of foreign keys
A lockpick for databases
What type of relationship exists between an order and its line items?
Many-to-Many
One-to-Many
One-to-One
Too many to count
Which of the following is a DML command?
CREATE
DROP
SELECT
Dance MySQL Dance
What is the main advantage of using a foreign key in a database?
To encrypt sensitive information
To increase the size of the database
To establish a relationship between tables
To create a backup of the data
What is the purpose of a database index?
To speed up queries
To create a table of contents
To alphabetize tables
To win a database race
What is a database transaction?
A unit of work performed on a database
A financial exchange
A high-stakes bet in SQL
A suspicious deal with a database admin
Which SQL command is used to remove a table from a database?
ERASE
REMOVE
DROP
DELETE
What is the purpose of a JOIN operation in SQL?
To combine rows from two or more tables
To delete data from a table
To create a new table
To sort data in a table
What is a stored procedure?
A procedure for cleaning the database
A method to store data in a file
A way to store user passwords
A set of SQL statements stored in the database
