Free Printable BTEC National ICT U2 LAB

1.

What Query view is shown in this image?

a)

Datasheet View

b)

Design View

2.

What Query view is shown in this image?

a)

Datasheet View

b)

Design View

3.

What is letter "B" showing?

a)

Where to click to Run the Query

b)

Where to Configure the Fields returned and criteria to be used

c)

Where to click to configure the Join properties

d)

Where to click to Save this Query

4.

What is letter "C" showing?

a)

Where to click to Run the Query

b)

Where to Click to Save the Query

c)

Where to configure the Fields returned and the criteria to be used

d)

Where to configure the Join properties

5.

Wildcard that represents any collection of characters

a)

Asterisk

b)

Question Mark

c)

Query

d)

Equal Sign

6.

What function enables you to ask questions about the data stored in a database and returns the answers based on your criteria?

a)

Query

b)

Form

c)

Report

d)

Table

7.

What validation type would make sure a post code was entered correctly?

a)

Length check

b)

Format check

c)

Presence check

d)

Range check

8.

What validation type would you use to check that a number fell between 1 and 10?

a)

Range check

b)

Presence check

c)

Format Check

d)

Length check

9.

What validation type checks that a field is not left blank?

a)

Format check

b)

Length check

c)

Presence check

d)

Range check

10.

What validation type checks a minimum number of characters have been entered?

a)

Length check

b)

Format check

c)

Range check

d)

Presence check

11.

What data type is your address?

a)

text

b)

number

c)

date/time

d)

yes/no

12.

What data type should be used for this data 01776 706484?

a)

text

b)

yes/no

c)

date/time

d)

currency

13.

What data type is 543?

a)

text

b)

yes/no

c)

date/time

d)

number

14.

What data type is 13:35?

a)

text

b)

yes/no

c)

currency

d)

date/time

15.

What data type is 31/5/2017?

a)

number

b)

date/time

c)

currency

d)

yes/no

16.

The following is a description of what is held in the database, what data type is it? Pages in a book

a)

number

b)

date/time

c)

text

d)

yes/no

17.

The following is a description of the data being held inside the database, what is the data type? A car number plate

a)

text

b)

date/time

c)

number

d)

yes/no

18.

In a database, Yes/No, Text and Date/Time are all examples of:

a)

data types

b)

data queries

c)

tabs you can select

d)

records in the data table

19.

A user is required to enter "exactly 7 characters for a password". Which data validation check is used?

a)

Length

b)

Range

c)

Format

d)

All of the above

20.

What is letter "A" showing?

a)

Where to configure the Join properties

b)

Where to Run the query

c)

Where to configure which fields and criteria are used for the Query

21.

A _______ query displays a dialog box that prompts the user to enter criteria when the query is run.

a)

Top Values

b)

Pattern Match

c)

List of Values

d)

Parameter

22.

A football team keeps a database about its players. Which query would allow them to produce a query showing players who are strikers and who have scored 20 goals or more?

a)

Position = "Striker" OR Goals = 20

b)

Position = "Striker" AND Goals = 20

c)

Position = "Striker" or Goals >=20

d)

Position = "Striker" AND Goals >= 20

23.

Which is the symbol for a wildcard that represents any collection of characters

a)

Asterisk

b)

Question Mark

c)

Query

d)

Equal Sign

24.

A teacher keeps pupil test results in a database. Each pupil has sat multiple tests. The teacher wants to run a query that shows each student and the average score they have achieved across the year. What would be the correct query to use:

a)

Parameter Query

b)

GroupBy

c)

Wildcard

d)

Selection

25.

A bookshop owner is using the shop's database to help a customer. The customer is looking for a particular author but cannot remember their full name. The customer remembers that the surname of the author starts with the letters "Co". What kind of query could the bookshop owner use to find this information?

a)

Parameter

b)

GroupBy

c)

Wildcard

d)

Selection

26.

_________ means to put information in order.

a)

Query

b)

Filter

c)

Count

d)

Sort

27.

A to Z is sorting in ________ order.

a)

Ascending

b)

Descending

28.

Z to A is sorting in ________ order.

a)

Ascending

b)

Descending

29.

Click ___________ to show the results of a query

a)

Execute

b)

Show

c)

Run

d)

Results

30.

Click ___________ to show the results of a query

a)

Execute

b)

Show

c)

Run

d)

Results

31.

_________ means to put information in order.

a)

Query

b)

Sort

c)

Filter

d)

Count

32.

What is this operator?
>

a)

Less than

b)

Greater than

c)

Not equal

d)

Greater than or equal to

33.

What is this operator?
<

a)

Less than

b)

Greater than

c)

Less than or equal to

d)

Greater than or equal to

34.

What is this operator?

=

a)

Less than

b)

Not equal

c)

Equal

d)

Greater than

35.

What is this operator?
>=

a)

Less than and not equal

b)

Greater than and not equal

c)

Greater than or equal to

d)

Less than or equal to

36.

What is this operator?
<=

a)

Not equal

b)

Less than or equal to

c)

Less than and not equal

d)

Greater than and equal to

37.

A _______ query displays a dialog box that prompts the user to enter criteria when the query is run.

a)

Top Values

b)

Pattern Match

c)

List of Values

d)

Parameter

38.

A football team keeps a database about its players. Which query would allow them to produce a query showing players who are strikers and who have scored 20 goals or more?

a)

Position = "Striker" OR Goals = 20

b)

Position = "Striker" AND Goals = 20

c)

Position = "Striker" or Goals >=20

d)

Position = "Striker" AND Goals >= 20

39.

A teacher keeps pupil test results in a database. Each pupil has sat multiple tests. The teacher wants to run a query that shows each student and the average score they have achieved across the year. What would be the correct query to use:

a)

Parameter Query

b)

GroupBy

c)

Wildcard

d)

Selection

40.

A bookshop owner is using the shop's database to help a customer. The customer is looking for a particular author but cannot remember their full name. The customer remembers that the surname of the author starts with the letters "Co". What kind of query could the bookshop owner use to find this information?

a)

Parameter

b)

GroupBy

c)

Wildcard

d)

Selection

41.

A _______ query displays a dialog box that prompts the user to enter criteria when the query is run.

a)

Parameter

b)

Top Values

c)

Pattern Match

d)

List of Values

42.

If you need to rename a field what is the correct syntax?

a)

NewName/Old Name

b)

NewName:Old Name

c)

OldName:NewName

d)

OldName/NewName

43.

Normalisation is:

a)

Removing all necessary data from a database

b)

Organising a database to remove repeated entries and increase the accuracy of the data

c)

Putting fields from different tables into one big database

44.

An advantage of normalisation is:

a)

The storage space needed for a normalised database is likely to be smaller

b)

The process of normalising a database is very easy and doesn’t require any skill

c)

It is possible to see previous details that have been changed, such as a customer’s address, as we can look back at an older entry

45.

What is an atomic field?

a)

A field that contains multiple items of data

b)

A field that is repeated

c)

A field that contains only one item of data

46.

What is a foreign key?

a)

A unique identifier in a database

b)

A primary key of one table that appears in another table

c)

A field that should not be in a table and needs removing

47.

A foreign key

a)

Links to a primary key in another table.

b)

Links to another foreign key.

c)

Links to another database system.

d)

Should always reference a unique value in the same table.

48.

A primary key

a)

Is a unique identifier for the table. It cannot be null.

b)

Is a unique identifier for the table. It can be null.

c)

Is an identifier that always connects to a foreign key.

d)

Is used in flat file databases.

49.

An entity is represented by what in a database?

a)

Table

b)

Row

c)

Column

d)

Cell

50.

A record is represented by what in a database?

a)

Table

b)

Row

c)

Column

d)

Cell

51.

Which type of relationship does the ERD represent?

a)

One-to-many

b)

Many-to-many

c)

One-to-one

52.

Which type of relationship does the ERD represent?

a)

One-to-many

b)

Many-to-many

c)

One-to-one

53.

What is a composite primary key?

a)

A primary key that can be duplicated in the same table

b)

An attribute that is a primary key in another table

c)

A foreign key that is a primary key in more than one other table

d)

A primary key made up from two or more attributes

54.

What is atomic data?

a)

Data that is unique

b)

A data item that cannot be broken down any further

c)

A row that has no repeating data

d)

An attribute that depends on the primary key

55.

In a database table, rows are called __________

a)

Field

b)

Record

c)

Primary Key

56.

Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.

a)

Cell

b)

Field

c)

Column

d)

Record

57.

Data type for '12/4/16'

a)

Text

b)

Date

c)

Long text

d)

Number

58.

Data type for 'Bob'

a)

Number

b)

Memo

c)

Text

d)

Currency

59.

Data type for '5.5'

a)

number

b)

text

c)

long text

d)

autonumber

60.

Data type for '£5.67'

a)

Number

b)

Currency

c)

Date

d)

Time

BTEC National ICT U2 LAB - Queries 1

Total questions: 60

Worksheet time: 41mins

Similar Resources on Wayground