WorksheetsCompSci Databases & SQL
Total questions: 10
Worksheet time: 2mins
Name
Class
Date
1.
Which of these is required of a Primary Key?
a)
Easy to recognise
b)
Unique
c)
Short
d)
A number
2.
When a table contains the primary key from another table, this is…
a)
A foreign key
b)
A secondary key
c)
A tertiary key
d)
A primary key
3.
Tables are linked together by
a)
Lines
b)
Links
c)
Relationships
d)
Hyperlinks
4.
Relationships can be
a)
One-to-one
b)
One-To-Many
c)
Either
5.
SQL stands for
a)
Stratified Query Language
b)
Structured Query Language
c)
Strategic Query Links
d)
Standard Query List
6.
Which SQL query finds information in a DB?
a)
UPDATE
b)
DELETE
c)
INSERT
d)
SELECT
7.
Which SQL query changes information in a DB?
a)
UPDATE
b)
DELETE
c)
INSERT
d)
SELECT
8.
Which SQL query removes information from a DB?
a)
UPDATE
b)
DELETE
c)
INSERT
d)
SELECT
9.
Which SQL query adds new information to a DB?
a)
UPDATE
b)
DELETE
c)
INSERT
d)
SELECT
10.
Which SQL keyword would you see if there was a relationship?
a)
INNER JOIN
b)
REL
c)
RSHIP
d)
LINK
100 %
