wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

CS IGCSE Database + SQL recap quiz

Total questions: 47

Worksheet time: 24mins

Name
Class
Date
1.

In a database, Multiple _________ can be created.

a)

Tables

b)

Documents

c)

Primary Key

d)

All of these

2.

___________________ Key uniquely identifies each record in table.

a)

Fields

b)

Record

c)

Row

d)

Primary

3.

In a Database, each row is called a _____________

a)

Field

b)

Data

c)

Record

d)

Table

4.

In a Database, each column is called a _____________

a)

Field

b)

Data

c)

Record

d)

Table

5.

This table has ___________ records.

a)

2

b)

4

c)

5

d)

6

6.

This table has ___________ fields.

a)

2

b)

4

c)

5

d)

6

7.

___________, ___________ & ___________ are fields.

a)

S. No, Product Code & Description

b)

1021, Beverages & Soft drinks, coffees, teas

c)

Dairy Products, Beverages & Seafood.

d)

All of these are fields.

8.

Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?

a)

Name

b)

ID

c)

City

d)

All of these

9.

Which one of the following attributes cannot be taken as a primary key?

a)

ID

b)

RegistrationNo

c)

DepartmentID

d)

Street

10.

Database if the collection of information or group of facts in a structured way.

a)

Maybe

b)

No

c)

Yes

d)

Not Always

11.

______________ datatype you'd select for entering "Address".

a)

Number

b)

Date

c)

Text

d)

Time

12.

You have to enter Sam's DOB, What datatype would you use for this field.

a)

Time

b)

Date

c)

Text

d)

Number

13.

Information corresponding to each field is called (a)   .

14.

______________ symbol indicates that a field is the Primary Key of the table.

a)
b)
c)
d)

All of these

15.
What is a database?
a)
A piece of software to do calculations
b)
A device to load information onto the computer.
c)
A structured collection of information
d)
A calculator
16.
Which of the following describes a relational database?
a)
Access
b)
A database that has a table
c)
There are two or more tables that are linked using the primary keys
d)
There are more than one table that have duplicate data
17.
A sports club needs to store information about each member.  The individual information about each member is called a:
a)
Field
b)
File
c)
Table
d)
Record
18.
One of the members of the Sports Club has decided to resign.  What would the secretary do with the record for that member on the database?
a)
Amend the record
b)
Delete the field
c)
Delete the record
d)
Delete the file
19.
The Sports Club has had an Open Day and has gained a new member.  How will they add their details to the database?
a)
Add another field
b)
Amend a record
c)
Add a new record
d)
Delete a record
20.
The whole database is called:
a)
The file
b)
The field
c)
The record
d)
The table
21.
One specific piece of information about a person or thing is called:
a)
Field
b)
File
c)
Record
d)
Table
22.
A scout company have a database with records of all the scouts.  They want to create a list of all scouts who are under 15 and their achievements. What would they use? 
a)
SQL UPDATE command
b)
Form 
c)
SQL SELECT Query
d)
Sort
23.
A gym has a database with all their members they want to include email addresses in the database, what will they do?
a)
Add a record
b)
Add a field
c)
Edit a record
d)
Delete a field
24.
A health club wants to find all the members who use the club 3 days or more a week.  What will they put in the query in the 'days' SQL query criteria?
a)
>3
b)
<3
c)
<=3
d)
>=3
25.
The health club stores the ages of its members.  What validation check would be used on the age field?
a)
Restricted choice
b)
Length
c)
Presence
d)
Range
26.
What data type would be used to store the following item code:   0024
a)
Text
b)
Integer
c)
Real
d)
Boolean
27.
The school wants to sort the data by staff Surname.  How will they sort it?
a)
Ascending order
b)
Descending order
28.
IKEA stores details of it's stock on a relational database.  Along with a unique stock code, all items are stored in coded aisles eg. BLU24, ORA23, YEL49 etc.  What type of validation would be used on this aisle code?
a)
Presence
b)
Length
c)
Range
d)
Field
29.

What type of data stored in the Name field?

a)

Date and time

b)

Numeric

c)

text

d)

yes/no

30.

What type of data is stored in the shoe size field?

a)

Numeric

b)

yes/no

c)

alphanumeric

d)

text

31.

what data type is stored in Sports field?

a)

text

b)

numeric

c)

yes/no

d)

alphanumeric

32.

What type of data is stored in Hair Colour field?

a)

yes/no

b)

alphanumeric

c)

Data / time

d)

text

33.

This type of data can only have two values: TRUE or FALSE and YES or NO?

a)

Alphanumeric/text

b)

Logical Boolean

c)

Date/Time

d)

Numeric

34.

This data type refers to data made up to letters and numbers symbols and spaces?

a)

Numeric

b)

Date and time

c)

Alphanumeric/text

d)

Currency

35.

Name the part of this database.

(a)  

36.

Name the type of field used to hold unique data that is used to identify each record.

(a)  

37.
How many records are in this database?
a)
8
b)
5
c)
10
d)
12
38.

Which statement is used to extract data from a database?

a)

Extract

b)

Get

c)

Open

d)

Select

39.

If you were wanting to filter data, which clause would you use?

a)

Where

b)

Order by

c)

From

d)

Select

40.

Which word is missing from the following SQL statement?


Select * table_name

a)

With

b)

Where

c)

From

d)

And

41.

What is the correct order of clauses in a SQL statement?

a)

SELECT, FROM, ORDER BY, WHERE

b)

SELECT, FROM, WHERE, ORDER BY

c)

SELECT, WHERE, FROM, ORDER BY

d)

WHERE, FROM, SELECT, ORDER BY

42.

How do we select all rows for the "Designer" table?

a)

SELECT * FROM Designer

b)

SELECT [All] FROM Designer

c)

SELECT Designer.*

d)

SELECT FROM Designer

43.

How would we script a SQL query to select "Description" from the Item table?

a)

SELECT Item.Description

b)

EXTRACT Description FROM Item

c)

SELECT Item FROM Description

d)

SELECT Description FROM Item

44.

Which query would return only the fields DesignerID and Designer?

a)

SELECT * FROM Designers

b)

SELECT DesignerID, Name FROM Designers

c)

SELECT DesignerID AND Designer FROM Designers

d)

SELECT DesignerID, Designer FROM Designers

45.

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

a)

SELECT * FROM Items ORDER BY Price ASCENDING

b)

SELECT * FROM Items ORDER BY Price ASC

c)

SELECT * FROM Items BY Price LOWEST TO HIGHEST

d)

SELECT * FROM Items ORDER BY Price DESC

46.

How would you display Chairs in the Items table that have a Price greater than £50.

a)

SELECT * FROM Items WHERE Type = 'Chair' AND Price > 50

b)

SELECT * FROM Items WHERE Type = 'Chair' OR Price < 100

c)

SELECT * FROM Iterms WHERE Type = 'Chair' AND Price >= 50

d)

SELECT * FROM Items WHERE Price > 50

47.

What does SQL stands for?

a)

Standard Query Language

b)

Structured Query Language

c)

Structured Query Link

d)

Standard Query Link

Similar Resources on Wayground

Units 5/6 Review - HWH

52 questions

Units 5/6 Review - HWH

quiz

Worksheet

•

9th - 12th Grade

ONLINE QUIZ FOR G K MASTER SERIES-2 (04.10.2020)

50 questions

ONLINE QUIZ FOR G K MASTER SERIES-2 (04.10.2020)

quiz

Worksheet

•

6th - 12th Grade

SIMDIG (search engine)

52 questions

SIMDIG (search engine)

quiz

Worksheet

•

10th Grade

RANKING 1

50 questions

RANKING 1

quiz

Worksheet

•

7th - 11th Grade

Film Appreciation Semester 1 Final Review

51 questions

Film Appreciation Semester 1 Final Review

quiz

Worksheet

•

9th - 12th Grade

Dasar Pengembangan Perangkat Lunak

50 questions

Dasar Pengembangan Perangkat Lunak

quiz

Worksheet

•

10th Grade

Coping phrases & el calendario

51 questions

Coping phrases & el calendario

quiz

Worksheet

•

6th - 12th Grade

GK- Marathon 13,14 & 15

50 questions

GK- Marathon 13,14 & 15

quiz

Worksheet

•

8th Grade - Professio...