Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

database

Total questions: 83

Worksheet time: 44mins

Name
Class
Date
1.
Identify the primary key from the following
a)
name
b)
mark
c)
telephone number
d)
Gender
2.
For the following two ENTITIES, which is the appropriate relationship:
HOUSE/POSTCODE
a)
One to One
b)
One to Many
c)
Many to Many
3.
What is database?
a)
An
collection of
related table.
b)
An
integrated
collection of
logically
related table.
c)
An
integrated
collection of
related table.
d)
An
collection of
logically
related table.
4.
A database does NOT consist of .........
a)
field
b)
table
c)
character
d)
report
5.
Tables in database NOT
a)
known as folder
b)
consist a set of related records
c)
organized in rows and column
d)
contain fields and records
6.
Records in database .....
a)
A group of related records in a
database.
b)
 known as row
c)
contains data about a given
person only
d)
known as column
7.
Field in database .....
a)
also known as a row
b)
A single item of data common to all reports
c)
Contains a specific category of data within a
field
d)
also known as a column
8.
Example of field name is
a)
Ahmad
b)
RM3000
c)
019-499987123
d)
D.O.B
9.
Primary key is
a)
A field that uniquely identifies each
field in a file.
b)
A field that uniquely identifies each
record in a file.
c)
A record that uniquely identifies each
record in a file.
d)
A record that uniquely identifies each
field in a file.
10.
Foreign key is
a)
Foreign key is a field in the
table that is foreign key in
another table.
b)
Foreign key is a field in the
table that is record key in
another table.
c)
Foreign key is a field in the
table that is primary key in
another table.
d)
Foreign key is a field in the
table that is column key in
another table.
11.
Entity-relationship diagrams is
a)
a tool that graphically shows the collections of entities in a system
b)
a tool that graphically shows the connections among entities in a system
12.
For the following two ENTITIES, which is the appropriate relationship:
RULER / COUNTRY
a)
One to One
b)
One to Many
c)
Many to Many
13.
For the following two ENTITIES, which is the appropriate relationship:
PRODUCTS /PRICES
a)
One to One
b)
One to Many
c)
Many to Many
14.
For the following two ENTITIES, which is the appropriate relationship:
ZOO / ANIMAL
a)
One to One
b)
One to Many
c)
Many to Many
15.
For the following two ENTITIES, which is the appropriate relationship:
DOCTOR / PATIENT
a)
One to One
b)
One to Many
c)
Many to Many
16.
For the following two ENTITIES, which is the appropriate relationship:
SIM CARD / PHONE NUMBER
a)
One to One
b)
One to Many
c)
Many to Many
17.
For the following two ENTITIES, which is the appropriate relationship:
ACTORS / MOVIES
a)
One to One
b)
One to Many
c)
Many to Many
18.
For the following two ENTITIES, which is the appropriate relationship:
CUSTOMER / ORDER
a)
One to One
b)
One to Many
c)
Many to Many
19.
For the following two ENTITIES, which is the appropriate relationship:
STUDENTS/SUBJECTS
a)
One to One
b)
One to Many
c)
Many to Many
20.
For the following two ENTITIES, which is the appropriate relationship:
STUDENTS/SUBJECTS
a)
One to One
b)
One to Many
c)
Many to Many
21.
For the following two ENTITIES, which is the appropriate relationship:
ADDRESS/ POSTCODE
a)
One to One
b)
One to Many
c)
Many to Many
22.

A sports club needs to store information about each individual member. The information about each member is called a:

a)

Field

b)

File

c)

Table

d)

Record

23.
One specific piece of information about a person or thing is called:
a)
Field
b)
File
c)
Record
d)
Table
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' query criteria?

a)

>3

b)

<3

c)

<=3

d)

>=3

25.

A scout company have a database with records of all the scouts. They want a list of all scouts who are under 15 and their achievements. What would they use to search the data?

a)

Report

b)

Table

c)

Query

d)

Sort

26.

What data type would be used to store the following item code: 0024

a)

Text

b)

Numeric

c)

Calculated

d)

Boolean

27.

The school wants to sort the data in alphabetical order by staff Surname. How will they sort it?

a)

Ascending order

b)

Descending order

28.

Text, Integer, Currency, Boolean and Date/Time are all examples of...

a)

Data Types

b)

Filters

c)

Sorts

d)

Validations

29.
A unique identifying field.
a)
Primary Key
b)
Integer
c)
Verification
d)
Boolean
30.

The four main objects of a database consist of:

a)

form, table, query, report

b)

filter, table, database, query

c)

form, data type, record, query

d)

form, record, field, report

31.

Which field type can only be one of two possibilities?

a)

Boolean (Yes/No)

b)

Graphic (OLE Object)

c)

Date

d)

Time

32.

Which field type can hold a picture?

a)

Boolean (Yes/No)

b)

Graphic (OLE Object)

c)

Date

d)

Time

33.

How many fields are shown here?

a)

5

b)

7

c)

11

d)

35

34.

How many records are shown here?

a)

5

b)

7

c)

11

d)

35

35.

How have the results shown been sorted?

a)

On the 'Id' field in Descending order

b)

On the 'Id' field in Ascending order

c)

On the 'City' field in Descending order

d)

On the 'City' field in Ascending order

36.

Which statement is used to extract data from a database?

a)

Extract

b)

Get

c)

Open

d)

Select

37.

Which word is missing from the following SQL statement?


Select * table_name

a)

With

b)

Where

c)

From

d)

And

38.

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

39.

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

40.

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

41.

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

42.

Match the following SQL term with a description - FROM

a)

The criteria which must be met

b)

The fields to display

c)

The field and order used to sort the results

d)

The table used in the query

43.

Match the following SQL term with a description - SELECT

a)

The fields to display

b)

The table used in the query

c)

The criteria which must be met

d)

The field and order used to sort the results

44.

Match the following SQL term with a description - WHERE

a)

The table used in the query

b)

The fields to display

c)

The field and order used to sort the results

d)

The criteria which must be set

45.

Match the following SQL term with a description - ORDER BY

a)

The fields to display

b)

The field and order used to sort the results

c)

The table used in the query

d)

The criteria that must be met

46.

Which symbol would you use to represent more than 50

a)

= 50

b)

< 50

c)

> 50

d)

# 50

47.

When examining a row in a table, we refer to it as a...

a)

row number

b)

result number

c)

record

d)

result

48.

When examining a column in a table, we refer to it as a...

a)

field name

b)

folder name

c)

column number

d)

table name

49.

When defining a table, each field name has both a ...

a)

table name and a database

b)

command and an argument

c)

goal and a purpose

d)

name and a data type

50.

What would the SQL query pictured do?

a)

Find all the men

b)

Find all of the female writers

c)

Find all of Elgar's friends

d)

Find all the male writers

e)

Find all the fish

51.

Which of the queries is most likely to have produced this result?

a)

ANSWER: SELECT id, name, year FROM movies WHERE year > 2010;

b)

ANSWER: SELECT id, name, year FROM movies WHERE year < 2010;

c)

ANSWER: SELECT * FROM movies WHERE year > 2010;

d)

ANSWER: SELECT id, name, year FROM movies WHERE YEAR > 2010;

52.
What is missing in this code? SELECT * FROM WHERE genre = ‘action’ ORDER BY year ASC;
a)
Missing an AND
b)
Table name
c)
Capitalize action
d)
None of these
53.
The following are functions of a DBMS except
a)
Creating database
b)
Processing data
c)
Creating and processing forms
d)
Administrating database
54.
The DBMS that most difficult to use is ________
a)
Microsofts SQL Server
b)
Oracle Corporation Oracle
c)
Microsoft Access
d)
IBM DB2
55.
Duplicate data often results in loss of data integrity because:
a)
A. Data formats may be inconsistent
b)
B. Data values may not agree
c)
Neither A & B
d)
Both A & B
56.
A database management system (DBMS) is a:
a)
Software system used to create, maintain, and provide controlled access to a database
b)
Hardware system used to create, maintain, and provide controlled access to a database
c)
Hardware system used to create, maintain, and provide uncontrolled access to a database
d)
Software system used to create, maintain, and provide uncontrolled access to a database
57.
A database application can perform which of the following activities?
a)
Add records
b)
Display / read records
c)
Update records
d)
All of the above
58.
Data administrator are responsible for ________
a)
Overall management of data resources in an organization
b)
Physical data design
c)
Managing technical issues in the database environment
d)
Writing application program
59.
Some advantages of the database approach include all, but:
a)
Minimal data redundancy
b)
Program-data dependency
c)
Improved data consistency
d)
Improved data sharing
60.
A relational database consists of a collection of
a)
Field
b)
Record
c)
Table
d)
Keys
61.
A_______ in a table represents a relationship among a set of values
a)
Field
b)
Foreign key
c)
Record
d)
Primary key
62.
The term attribute refers to a ________ of a table
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
63.
The term _______ is used to refer a row
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
64.
Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?
a)
NAME
b)
ID
c)
CITY
d)
ID, NAME
65.
Which one of the following should be taken as a primary key?
a)
Name
b)
DepartmentID
c)
Department
d)
Street
66.
which one of the following cannot be taken as a primary key?
a)
ID
b)
RegistrationNo
c)
DepartmentID
d)
Street
67.
A attribute in a relation is a foreign key if the _____ from one relation is used as an attribute in that relation.
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
68.
Which of the following gives a logical structure of the database graphically?
a)
Entity--relationship diagram
b)
Entity diagram
c)
Database diagram
d)
Architectural representation
69.
The entity relationship set is represented in E-R diagram as
a)
Double diamonds
b)
Undivided rectangles
c)
Dashed lines
d)
Diamond
70.
The rectangles divided into two parts represents
a)
Entity set
b)
Relationship set
c)
Attributes of a relationship set
d)
Primary key
71.
If you were collecting and storing information about your music collection, an album would be considered a(n) _____.
a)
Relation
b)
Entity
c)
Instance
d)
Attribute
72.
The records of a table can be of ________ order.
a)
Any
b)
Same
c)
Sorted
d)
Constant
73.
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
74.
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
75.
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
76.
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
77.
The whole database is called:
a)
The file
b)
The field
c)
The record
d)
The table
78.
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
79.
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
80.
What data type would be used to store the following item code:   0024
a)
Text
b)
Integer
c)
Real
d)
Boolean
81.
The school wants to sort the data by staff Surname.  How will they sort it?
a)
Ascending order
b)
Descending order
82.
A film club stores details of all the films it shows.  One of the fields is Genre (sample data: Action, Horror, Family, Romance etc).  What validation would be most suitable for this field?
a)
Length
b)
Presence
c)
Range
d)
Restricted Choice
83.
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

Similar Resources on Wayground

Year 7 End of Year Quiz

82 questions

Year 7 End of Year Quiz

quiz

Worksheet

•

6th Grade - University

TECH Database ALL

81 questions

TECH Database ALL

quiz

Worksheet

•

9th - 12th Grade

LATIHAN PENDALAMAN USEK C3 - PWPB - BASIS DATA

80 questions

LATIHAN PENDALAMAN USEK C3 - PWPB - BASIS DATA

quiz

Worksheet

•

12th Grade

AQA A-Level Grand Quiz

80 questions

AQA A-Level Grand Quiz

quiz

Worksheet

•

11th - 12th Grade

UN Akuntansi SMK

80 questions

UN Akuntansi SMK

quiz

Worksheet

•

12th Grade

thtontapbai19-35 năm 2024-2025

86 questions

thtontapbai19-35 năm 2024-2025

quiz

Worksheet

•

5th Grade - University

my personal quiz

82 questions

my personal quiz

quiz

Worksheet

•

9th - 12th Grade

Cisco Module 2: Clients and Servers in Computer Networks

88 questions

Cisco Module 2: Clients and Servers in Computer Networks

quiz

Worksheet

•

12th Grade