Computing

Question 1

1Which SQL command adds new rows to a table?

Easy

A. UPDATE B. DROP C. INSERT D. SELECT

Question 2

2Which SQL command retrieves data from a table?

Easy

A. INSERT B. SELECT C. UPDATE D. DELETE

Question 3

3Which SQL clause filters rows?

Hard

A. FROM B. WHERE C. ORDER BY D. SELECT

Question 4

4A database table is made up of

Easy

A. only images B. records (rows) and fields (columns) C. only formulas D. slides

Question 5

5A field that uniquely identifies each record in a table is the

Easy

A. query B. primary key C. index D. foreign key

Question 6

6A query in a database is used to

Easy

A. draw pictures B. retrieve specific information C. print slides D. format text

Question 7

7The SQL command used to retrieve data is

Easy

A. DELETE B. SELECT C. INSERT D. UPDATE

Question 8

8A foreign key is a field that

Hard

A. is always numeric B. uniquely identifies records in its table C. refers to the primary key of another table D. is encrypted

Question 9

9Referential integrity ensures that

Hard

A. tables are sorted B. no nulls exist C. data is encrypted D. foreign key values match existing primary keys

Question 10

10Normalisation in databases aims to

Medium

A. increase duplication B. reduce data redundancy C. slow queries D. delete all data