wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Consolidation Quiz

Total questions: 30

Worksheet time: 15mins

Name
Class
Date
1.

To copy an entire table with all of the records, we must select

a)

Structure only

b)

Structure and data

c)

Enforce Referential Integrity

d)

a one-to-one relationship

2.

To create a relationship between 2 tables, which tab should we navigate to?

a)

Home Tab

b)

Views Tab

c)

Database Tools

d)

Design View

3.

The rule in a database that makes sure

the relationship between two tables is valid is

a)

referential integrity

b)

one-to-many

relationship

c)

the primary key

d)

the foreign key

4.

Which field should be used to create a

relationship between the tables shown?

a)

The foreign key field

b)

The primary key field

c)

StudentID

d)

Class

5.

What type of relationship will be created

when the tables shown are linked?

a)

one-to-many

b)

one-to-one

c)

many-to-many

d)

null set

6.

Which field should be used to create

a relationship between the 2 tables shown?

a)

Students

b)

Counsellor

c)

Comments

d)

StudentID

7.

What type of relationship will be created

when the tables shown are linked?

a)

one-to-many

b)

one-to-one

c)

many-to-many

d)

null set

8.

A collection of fields that store different kinds of data on the same item is called a ....................

a)
table
b)
record
c)
file
d)
database
9.

A collection of records about a specific topic is known as a ....................

a)
field
b)
table
c)
database
d)
file
10.

A database can be made up of tables, forms, queries, reports, macros and modules. These are collectively referred to as ....................

a)
sheets
b)
objects
c)
items
d)
files
11.

A database query uses *S* as its criteria. Which of the following names will be returned in the query?

JAMES

SHEILA

ALISON

a)
JAMES only
b)
JAMES, SHEILA and ALISON
c)
SHEILA only
d)
JAMES and SHEILA only
12.
A database table has a field for telephone numbers in the format: 452-4526. What is the best data type and field size?
a)
Data type Text and field size 7
b)
Data type Number and field size Integer
c)
Data type Text and field size 8
d)
Data type Number and field size Real
13.
A query is used to calculate each employee's bonus as 20% of their salary. What must be typed to produce the bonuses?
a)
[Salary] * 1/5
b)
Bonus: [Salary * 0.2]
c)
Bonus: [Salary] * 0.2
d)
= Salary * 0.2
14.

A specific field that uniquely identifies each record is called a ....................

a)
CID
b)
data source
c)
primary key
d)
reference field
15.
Arrange the following terms (listed alphabetically) in order of size (smallest to largest): database field record table
a)
field → table → record → database
b)
record → field → table → database
c)
field → record → table → database
d)
field → table → database → record
16.
In a database report, the average salary must be displayed in the group footer. Which formula will perform this calculation?
a)
= AVERAGE(Gender.Salary)
b)
=Avg(Salary)
c)
=Average([Salary])
d)
=Average [Salary]
17.

In a database table, the rows refer to .................... and the columns refer to ....................

a)
records, data types
b)
data types, records
c)
field names, records
d)
records, field names
18.
In a report, the summary information for each group is usually placed in the
a)
Page footer
b)
Report footer
c)
Group footer
d)
Group header
19.

In a student database, the field Lives with Parents? would likely have which data type?

a)
autonumber
b)
text
c)
string
d)

Yes/No

20.

In creating a query, a student entered the following criteria for the data field:

> = 05/11/2017 AND < = 05/14/2017

The output will show days ....................

a)

after May 14, 2017

b)

from May 11 to May 14, 2017

c)

before May 11 and after May 14, 2017

d)

between May 14 and November 5, 2017

21.

Where is data stored in a database?

a)

Report

b)
Short Text
c)

Field Size

d)
Table
22.

Information produced from queries and tables in a specific format that can be printed from a database is called ....................

a)
a file
b)
a report
c)
a binary
d)
an object
23.

The default field size for the data type Text is ....................

a)
unlimited
b)
string
c)
integer
d)
255 characters
24.

The following are listed as disadvantages of a computerized database?

1. The required computers are peripherals can be expensive

2. Data cannot be checked on entry

3. There is often a limit to the size of a database file

Which of these statements is TRUE?

a)
1 and 3 only
b)
1 and 2 only
c)
2 and 3 only
d)
1, 2 and 3
25.

The smallest piece of data that can be stored in a database is called a ....................

a)
field
b)
table
c)
record
d)
file
26.
To search a database for all names beginning with the letter R, what must be entered as the criteria?
a)
R*
b)
R...
c)
>R
d)
R?
27.
When creating a database for a supermarket, the MOST appropriate data type to use for the price of an item is
a)
currency
b)
text
c)
number
d)
autonumber
28.

When searching a database for records that match either of the conditions, this search concept is used:

a)
OR
b)
AND
c)
WITH
d)
ALSO
29.
Which of the following characteristics must two database tables have in order for them to be linked?
a)
Primary keys
b)
One field in common
c)
Referential integrity
d)
A one-to-one join type
30.
Which of the following IS NOT a view in a database?
a)
Query
b)
Datasheet
c)
Design
d)
Layout

Similar Resources on Wayground

Berpikir Komputasional

25 questions

Berpikir Komputasional

quiz

Worksheet

•

9th - 12th Grade

Assessment Tengah Semester Ganjil

35 questions

Assessment Tengah Semester Ganjil

quiz

Worksheet

•

8th Grade - University

Struktur data dan validitas Sumber Data

25 questions

Struktur data dan validitas Sumber Data

quiz

Worksheet

•

10th Grade

Latihan soal PTS kelas X

25 questions

Latihan soal PTS kelas X

quiz

Worksheet

•

10th Grade

Quiz Sistem Operasi

25 questions

Quiz Sistem Operasi

quiz

Worksheet

•

10th Grade - University

Algoritma, Flowchart, Pseudocode

25 questions

Algoritma, Flowchart, Pseudocode

quiz

Worksheet

•

9th - 12th Grade

Code.org lesson 3 and 4 quiz

25 questions

Code.org lesson 3 and 4 quiz

quiz

Worksheet

•

7th Grade - University

Asesmen Formatif

25 questions

Asesmen Formatif

quiz

Worksheet

•

10th Grade