wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Database Foundations

Total questions: 20

Worksheet time: 16mins

Name
Class
Date
1.

What is SQL?

a)

Structured Query Language

b)

Standard Query Language

c)

Structural Query Language

d)

Standardized Query Language

2.

A standardized programming language that is used to manage relational databases

a)

SQL

b)

Table

c)

mySQL

d)

Query

3.

an organized collection of structured information or data,

a)

SQL

b)

Schema

c)

Database

d)

Row

4.

defines how data is organized within a relational database

a)

Schema

b)

Table

c)

Structure

d)

Query

5.

are software systems used to store, retrieve, and run queries on data

a)

DBMS

b)

mySQL Workbench

c)

Database Management System

d)

Command Line

6.

What does R in CRUD mean?

a)

Retrieve

b)

Read

c)

Right

d)

Role

7.

What does D in CRUD mean?

a)

Delete

b)

Duplicate

c)

Develop

d)

Done

8.

Examples of databases:

a)

mongoDB

b)

mySQL

c)

myQueries

d)

dynamoDB

e)

All of the above

9.

Types of Database

a)

relational

b)

un-relational

c)

non-relational

d)

none-relational

10.

Examples of relational database

a)

dynamoDB

b)

mongoDB

c)

mySQL

d)

MSSQL

11.

Examples of NoSQL

a)

dynamoDB

b)

mongoDB

c)

mySQL

d)

MSSQL

12.

a request to access data from a database to manipulate or retrieve it

a)

query

b)

noSQL

c)

DBMS

d)

schema

13.

are database objects that contain all the data in a database

a)

table

b)

column

c)

row

d)

schema

14.

is a list of values, usually belonging to a particular field, displayed vertically in a table

a)

table

b)

column

c)

row

d)

schema

15.

is a collection of fields that make up a record

a)

table

b)

column

c)

row

d)

schema

16.

Describe a primary key

a)

uniquely identifies each record in a table

b)

must be unique

c)

does not contain empty values

d)

all of the above

17.

Primary key is required in a database table

a)

true

b)

false

18.

Describe a foreign key

a)

a column or combination of columns that is used to establish a link between 2 tables

b)

a column or combination of columns that contain values that uniquely identify each row in the table

c)

ensures unique row identification

d)

all of the above

19.

a combination of two or more columns in a table that can be used to uniquely identify each row in the table

a)

primary key

b)

foreign key

c)

composite key

20.

a column or combination of columns that contain values that uniquely identify each row in the table

a)

primary key

b)

foreign key

c)

composite key