Free Printable BTEC IT U2: Exam Prep

Free Printable Worksheets

Worksheets

BTEC IT U2: Exam Prep

Total questions: 99

Worksheet time: 1hrs 14mins

Name

Class

Date

1.

Jimmy is planning to name the relations depending on their content. What is a relation in a database?

a)

Attribute

b)

Table

c)

Row

d)

Column

2.

A select operation retrieves a subset of tuples from a relation

a)

True

b)

False

3.

Complete the sentence below.

A _____ is a row in a database table. This is also known as a record.

a)

Tuple

b)

Server

c)

Relation

d)

Domain

4.

Complete the sentence below.

The _____ is all the possible allowable values for an attribute.

a)

Cardinality

b)

Domain

c)

Tuples

d)

Table

5.

The cardinality is how _______ an attribute is in terms of its data values.

a)

Unique

b)

Many times

c)

False

d)

Equal

6.

What type of database is designed to store data locally?

a)

Proprietary Database

b)

Open-Source Database

c)

Desktop Database

d)

Online Databse

7.

What is an attribute in a database?

a)

A property, quality, or characteristic that describes an entity

b)

A physical object or a concept that needs to be recorded in the database

c)

A field that uniquely identifies each record in the table

d)

A field that appears as the primary key in another table

8.

What is a primary key in a database?

a)

A field that uniquely identifies each record in the table

b)

A physical object or a concept that needs to be recorded in the database

c)

A property, quality, or characteristic that describes an entity

d)

A field that appears as the primary key in another table

9.

What is a foreign key in a database?

a)

A field that appears as the primary key in another table

b)

A physical object or a concept that needs to be recorded in the database

c)

A property, quality, or characteristic that describes an entity

d)

A field that uniquely identifies each record in the table

10.

What is a record in a database?

a)

A collection of data for a set of fields

b)

A physical object or a concept that needs to be recorded in the database

c)

A property, quality, or characteristic that describes an entity

d)

A field that uniquely identifies each record in the table

11.

What is a composite key in a database?

a)

A primary key made up of more than one field

b)

A physical object or a concept that needs to be recorded in the database

c)

A property, quality, or characteristic that describes an entity

d)

A field that appears as the primary key in another table

12.

Complete the sentence below.

A _____________ is a row in a database table. This is also known as a record.

a)

Table

b)

Entity

c)

Record

d)

Tuple

13.

Complete the sentence below.

The _____________is all the possible allowable values for an attribute.

a)

Domains

b)

Attributes

c)

Relation

d)

Tuples

14.

This database object is a primary container used to hold data in MS Access

a)

Query

b)

Form

c)

Table

d)

Report

15.

Designed to show only one record at a time, this object is useful for editing and data input.

a)

Table

b)

Form

c)

Query

d)

Report

16.

A ___________ is designed to "ask" a question of the database and returns only a subset of data

a)

Query

b)

Form

c)

Table

d)

Record

17.

This object is used for "output" only and cannot edit or add information to the database

a)

Table

b)

Query

c)

Form

d)

Report

18.

A _________ ___ is a unique identifier for the table.

a)

line item

b)

data type

c)

primary key

d)

property field

19.

The table view that displays data in rows and columns is called the

a)

datasheet view

b)

design view

c)

form view

d)

report view

20.

The ________ _____ defines the type of data stored in a field.

a)

query grid

b)

field name

c)

record type

d)

data type

21.

The default data type assigned to a primary key is ________________.

a)

autonumber

b)

text

c)

number

d)

integer

22.

An alternative term for Table

a)

Entity

b)

Attribute

c)

Relation

d)

Object

23.

An alternative term for Field

a)

Record

b)

Attribute

c)

Key

d)

Object

24.

To run a query, click which of the following?

a)

File menu

b)

The Σ button

c)

Red exclamation mark

d)

The design button

25.

An alternative name for Record

a)

Tuple

b)

Tiple

c)

Topple

d)

Tapple

26.

A query can be based on...

a)

Tables

b)

Queries

c)

Forms

d)

Reports

27.

MS Access is an example of a RDBMS. What do these letters stand for?

a)

Relational Database Management System

b)

Rational Data Based on Management Sytem

c)

Reports Data Based on Making Sums

d)

Real Data Beautifully Made Splendid

28.

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

29.

The arithmetic operator for 'equal to' is?

a)

=

b)

<

c)

>

d)

<>

30.

The arithmetic operator for 'not equal to' is?

a)

=

b)

<

c)

>

d)

<>

31.

The arithmetic operator for 'less than' is?

a)

=

b)

<

c)

>

d)

<>

32.

The arithmetic operator for 'greater than' is?

a)

=

b)

<

c)

>

d)

<>

33.

a)

6

b)

4

c)

5

d)

10

34.

a)

6

b)

4

c)

5

d)

10

35.

In a database table a row of data is called?

a)

Row

b)

Field

c)

Cell

d)

Record

36.

A column in a database table is called?

a)

Row

b)

Keys

c)

Column

d)

Field

37.

Pick one or more data types

a)

Text

b)

Number

c)

Column

d)

Date/Time

38.

1. Data _____________ refers to ensuring accuracy and consistency of data.

a)

Integrity

b)

Collation

c)

Assessment

d)

System

39.

Which of these is not an example of a field type?

a)

Picture

b)

Short Text

c)

Date and Time

d)

Yes/No

40.

In Microsoft Access, a field labelled “Price” must be created as

a)

Currency

b)

Primary Key

c)

Number

d)

Short Text

41.

This can offer a way to view, format, and summarize the information in your Microsoft Access database.

a)

query

b)

table

c)

form

d)

report

e)

record

42.

A table is divided into __________________

a)

field and form

b)

fields and records

c)

datasheet and design

d)

record and form

43.

Which of the following is an old method of a database?

a)

Address Book

b)

Filing Cabinet

c)

Fax Machine

d)

Typewriter

44.

Access offers different views of objects. Which view do you use to edit a table?

a)

Datasheet View

b)

Design View

c)

Table View

d)

Print View

45.

How would you define a Query?

a)

Created to see tables better

b)

Allow you to retrieve data from tables

c)

The wizard allows you to go step by step

46.

You discover many errors in a database table. What has been lost?

a)

Data Integrity

b)

Database Management System

c)

Fields and Records

d)

Primary Key

47.

What is a database form?

a)

A column in a table that stores a piece of data for a record.

b)

Stores information about one specific kind of item in a database.

c)

Forms are a way to view and browse information in a database.

d)

An organized collection of related data.

48.

What is data integrity?

a)

Maintaining and assuring accuracy and consistency of data in a database.

b)

Stores all the information for one item in a table.

c)

Stores information about one specific kind of item in a database.

d)

Forms are a way to view and browse information in a database.

49.

Does Microsoft Access need to be told about relationships between tables?

a)

No, relationships are automatically detected

b)

No, relationships are not supported

c)

Yes, relationships need to be defined.

d)

Yes, only when the fields have different names.

50.

......................... data type stores data in a Yes/No or True/False format

a)

Currency

b)

Numeric

c)

Boolean

51.

Normalisation is:

a)

Filling in empty fields so that all rows / tuples contain data.

b)

Organising a database to remove duplication of data, and maintain the accuracy / integrity of the data.

c)

Putting fields from different tables into one big database.

d)

Creating a spreadsheet

52.

A row in a database.

a)

Record

b)

Field

c)

Entity

d)

Table

53.

Fields in database are similar to _________ in tables.

a)

Rows

b)

Columns

c)

Cells

d)

Values

54.

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

d)

A field containing data about atoms

55.

A unique identifying field.

a)

Primary Key

b)

Integer

c)

Verification

d)

Boolean

56.

What is the primary key in this database?

a)

Emp_Id

b)

Last Name

c)

Gender

d)

Title

57.

What is a foreign key?

a)

The primary key in one table used to link to another table

b)

Two fields combined together to make one key

c)

A unique identifier

d)

None of these

58.

Which of the following are primary keys?

a)

CostumeHireGroupID

b)

CostumeID

c)

RentalID

d)

CustomerID

e)

FirstName

59.

A composite key is a combination of two fields that together can uniquely identify a record.

a)

True

b)

False

60.

What type of relationship should we not use in our database structure?

a)

One to One

b)

One to Many

c)

Many to One

d)

Many to Many

61.

Referential Integrity is a rule states that every foreign key value must match the primary key value of a record in another table, or must be null.

a)

True

b)

False

62.

The best data type to choose for a postcode would be

a)

Number

b)

Text

c)

Date/Time

d)

Currency

63.

Which data type would be most suitable for the 'DateofBirth' field?

a)

Currency

b)

Number

c)

Date/Time

d)

Yes/No

e)

Memo

64.

Which datatype will be used to generate numbers automatically while inserting data?

a)

Number

b)

Auto number

c)

Automatic Number

d)

Integer

65.

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

a)

Form

b)

Query

c)

Report

d)

Table

66.

The Query button is located on the _______ tab.

a)

Home

b)

File

c)

Create

d)

Export

67.

Click ___________ to show the results of a query

a)

Execute

b)

Show

c)

Run

d)

Results

68.

What Query view is shown in this image?

a)

Datasheet View

b)

Design View

c)

Layout view

d)

Report view

69.

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

70.

Besides entering data directly into the table, you could use a

a)

Field

b)

Form

c)

Query

d)

Report

71.

Reducing the size of a field length is an example of a (a) check

72.

Test data which should be accepted is known as

a)

Normal

b)

Extreme

c)

Erroneous

d)

Invalid

e)

Boundary

73.

Test data way outside a range which should be rejected is known as

a)

Normal

b)

Extreme

c)

Erroneous

d)

Invalid

e)

Boundary

74.

Test data with the incorrect data type which should be rejected is known as

a)

Normal

b)

Extreme

c)

Erroneous

d)

Invalid

e)

Boundary

75.

A primary key field from one table appears in a second table. What is the field in the second table called?

a)

A primary key

b)

A foreign key

c)

A relationship key

d)

A linked key

76.

What Query view is shown in this image?

a)

Datasheet View

b)

Design View

77.

The arithmetic operator for 'less than or equal to' is?

a)

=

b)

<=

c)

>=

d)

<>

78.

What is a "Control source" in an Access control?

a)

Where formatting is controlled

b)

Where the data comes from / is calculated

c)

Where data is duplicated

d)

Where a primary key is defined

79.

What is CustomerID acting as in (2)?

a)

A foreign key

b)

A primary key

c)

A normal attribute

d)

A record

80.

What is the relationship between "books" and "loans"?

a)

1:1

b)

1:many

c)

many:1

d)

There is no relationship

81.

What type of validation is shown here?

a)

Length check

b)

Format check

c)

Value lookup

d)

Range check

82.

How will "Fullname" display?

a)

FredBloggs

b)

Fred Bloggs

c)

Bloggs, Fred

d)

BloggsFred

83.

How many hours are allocated for the examination in Part A?

a)

2 hours

b)

3 hours

c)

4 hours

d)

5 hours

84.

What is the total mark for Part A of the examination?

a)

26 marks

b)

40 marks

c)

66 marks

d)

80 marks

85.

What is the total mark allocation for Activity 1?

a)

6 marks

b)

8 marks

c)

10 marks

d)

12 marks

86.

Which activity involves creating queries and a report?

a)

Activity 2

b)

Activity 3

c)

Activity 4

d)

Activity 5

87.

In Activity 5, what aspect of the database is primarily evaluated?

a)

User interface design

b)

Database structure and validation

c)

Query efficiency

d)

Report layout

88.

In Activity 8 , what aspect of the database is primarily evaluated?

a)

User interface design

b)

Database structure and validation

c)

Query efficiency

d)

Report layout

89.

What is data integrity?

a)

Maintaining and assuring accuracy and consistency of data in a database.

b)

Stores all the information for one item in a table.

c)

Stores information about one specific kind of item in a database.

d)

Forms are a way to view and browse information in a database.

90.

How many hours are allocated for the examination in Part A?

a)

2 hours

b)

3 hours

c)

4 hours

d)

5 hours

91.

How many hours are allocated for the examination in Part B?

a)

2 hours

b)

3 hours

c)

4 hours

d)

5 hours

92.

What is the total mark for Part A of the examination?

a)

26 marks

b)

40 marks

c)

66 marks

d)

80 marks

93.

What is the total mark for Part B of the examination?

a)

26 marks

b)

40 marks

c)

66 marks

d)

80 marks

94.

How should the folder for submitting work be named?

a)

[Centre #]_[Registration number #]_[surname]_[initial]_PartA

b)

[Registration number #]_[Centre #]_[surname]_[initial]_PartA

c)

[surname]_[initial]_[Registration number #]_[Centre #]_PartA

d)

[surname]_[Centre #]_[initial]_[Registration number #]_PartA

95.

A DBMS is a

a)

Database management system

b)

Database multi system

c)

Data set management system

d)

Database merger system

96.

What is a foreign key?

a)

The primary key in one table used to link to another table

b)

Two fields combined together to make one key

c)

A unique identifier

97.

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

a)

Form

b)

Query

c)

Report

d)

Table

98.

What is the result of this query

a)

A field called "The Value" containing 5% of the total cost for all rows

b)

A field called "The Value" containing 5% of the total cost for each row

c)

A field called "sum([Cost])" containing 5% of the total cost for all rows

d)

An error

99.

Here is some data. What is the best way to normalise it?

a)

Have a table for lenders and a table for books

b)

Put everything into a single table

c)

Have a table for Lenders and a table for Books, then add a table Lender/Book with a primary key made from primary keys in the other tables

d)

Put every attribute into its own table

Reset

Similar Resources on Wayground

100 questions

QUIZ KOMKOM

Worksheet

•

9th Grade - University

100 questions

Tercer Laboratorio : Laboratorio 2

Worksheet

•

11th Grade

100 questions

Latihtubi ICT 2016

Worksheet

•

10th - 12th Grade

100 questions

PPJ - Pengalamatan IP

Worksheet

•

11th Grade

101 questions

NASA Test

Worksheet

•

9th - 12th Grade

100 questions

TKJ Test

Worksheet

•

10th - 12th Grade

100 questions

jak znasz się na mincraft

Worksheet

•

1st - 12th Grade

100 questions

Tes LCTK Lanjutan

Worksheet

•

10th Grade - University