Font size
WorksheetsDatabase Foundations
Total questions: 20
Worksheet time: 16mins
What is SQL?
Structured Query Language
Standard Query Language
Structural Query Language
Standardized Query Language
A standardized programming language that is used to manage relational databases
SQL
Table
mySQL
Query
an organized collection of structured information or data,
SQL
Schema
Database
Row
defines how data is organized within a relational database
Schema
Table
Structure
Query
are software systems used to store, retrieve, and run queries on data
DBMS
mySQL Workbench
Database Management System
Command Line
What does R in CRUD mean?
Retrieve
Read
Right
Role
What does D in CRUD mean?
Delete
Duplicate
Develop
Done
Examples of databases:
mongoDB
mySQL
myQueries
dynamoDB
All of the above
Types of Database
relational
un-relational
non-relational
none-relational
Examples of relational database
dynamoDB
mongoDB
mySQL
MSSQL
Examples of NoSQL
dynamoDB
mongoDB
mySQL
MSSQL
a request to access data from a database to manipulate or retrieve it
query
noSQL
DBMS
schema
are database objects that contain all the data in a database
table
column
row
schema
is a list of values, usually belonging to a particular field, displayed vertically in a table
table
column
row
schema
is a collection of fields that make up a record
table
column
row
schema
Describe a primary key
uniquely identifies each record in a table
must be unique
does not contain empty values
all of the above
Primary key is required in a database table
true
false
Describe a foreign key
a column or combination of columns that is used to establish a link between 2 tables
a column or combination of columns that contain values that uniquely identify each row in the table
ensures unique row identification
all of the above
a combination of two or more columns in a table that can be used to uniquely identify each row in the table
primary key
foreign key
composite key
a column or combination of columns that contain values that uniquely identify each row in the table
primary key
foreign key
composite key
