wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

12 IPT revision

Total questions: 78

Worksheet time: 33mins

Name
Class
Date
1.

$789.00 is an example of which data type

a)

Text

b)

Currency

c)

Boolean

d)

Decimal

2.

Validation makes sure data is...

a)

Accurate

b)

Reliable

3.

What is a primary key?

a)

A field

b)

A record

c)

Two fields

d)

A unique reference

4.

Which option do you select for boolean data?

a)

Number

b)

Short Text

c)

Yes/No

d)

Date/Time

e)

Currency

5.
A column in a database.
a)
Field
b)
Record
c)
Entity
d)
Validation
6.
A row in a database.
a)
Record
b)
Field
c)
Entity
d)
Table
7.
A group of related records.
a)
Entity
b)
Validation
c)
Field
d)
Filter
8.
A rule to make sure that only reasonable and sensible data is entered.
a)
Filter
b)
Query
c)
Validation
d)
Verification
9.
Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of...
a)
Data Types
b)
Filters
c)
Sorts
d)
Validations
10.
A method of only displaying records in a table that match specific criteria...
a)
Filter
b)
Validation
c)
Sort
d)
Verification
11.
A database search that can be saved as a separate file.
a)
Query
b)
Validation
c)
Filter
d)
Verification
12.

What other object besides the Table can display the Datasheet View?

a)

Query

b)

Report

13.

True or False? The only Object a Form or Report can draw it's data from is a Table.

a)

True

b)

False

14.
______________ a collection of hardware, software, data, people, and procedures that work together to produce quality information.
a)
Information Technology
b)
Information System
c)
Network
d)
Database
15.
We can use___________________ to keep track of student statistics.
a)
Office System
b)
Payroll System
c)
Student Information System
d)
Learning Management System
16.
Transaction Processing Systems are used to record business meetings.  
a)
True
b)
False
17.
Which of the following can provide regular information about the daily activities of a    business to managers?
a)
Decision Support System
b)
Expert System
c)
Transaction Processing System
d)
Management Information System
18.
Transaction Processing System 
a)
maintains students’ database
b)
provides computer-based training
c)
handles distance learning program
d)
keeps track of daily transaction in a database
19.
________________is used to help managers make right decision in important areas of   business.  
a)
Decision Support System
b)
Management Information System
c)
Transaction Processing System
d)
Expert Systems
20.
Column A of Table 2 describes information system P .
Identify the type of information described in P?
a)
DSS
b)
ES
c)
MIS
d)
TPS
21.
Transaction Processing System 
a)
maintains students’ database
b)
provides computer-based training
c)
handles distance learning program
d)
keeps track of daily transaction in a database
22.
The components of an information system are human, hardware, software, procedures and …………….
a)
field
b)
data
c)
information system
d)
table
23.
Transaction Processing System is used to __________ business transactions.  
a)
repeat 
b)
record 
c)
reprint 
d)
register
24.
This Information System has these characteristic:
Interactive
Uses Simulation to predict short term outcome
Uses many Analysis tools
Respond to unique and complex queries
What Information System is this?
a)
Transaction Processing System
b)
Management Information System
c)
Decision Support System
d)

expert system

25.
SDLC stands for...
a)
System development life cycle. 
b)
Software development litigation cycle. 
c)
System development life conditions. 
d)
Software development life cycle. 
26.
Who should review the detailed design before it is developed?
a)
The developer. 
b)
The users. 
c)
As many stakeholders as possible. 
d)
The ICT support team. 
27.

Which of these is the correct order of the SDLC?

a)

Maintenance, Planning, Design, Analysis, Implementation

b)

Analysis, Planning, Design, Maintenance, Implementation

c)

Planning, Analysis, Design, Implementation, Maintenance

d)

Planning, Analysis, Implementation, Design, Maintenance

28.
What happens in the implementation phase?
a)
The code is tested against the specfication
b)
Making changes when the sotware has been created
c)
Planning the solution, look and feel of the software interface
d)
The deliverables of the implementation stage are created e.g. the code
29.

Which of those options are an example of a field?

a)

29918

b)

16-11-2001

c)

Name

d)

Male

30.

Where can a data entry form be most useful?

a)

ATM/Bank

b)

Grocery

c)

Online store

d)

Cafe

31.

Where can a data entry form be most useful?

a)

ATM/Bank

b)

Grocery

c)

Online store

d)

Cafe

32.

"The more fields entered and shown on the form, the easier it is to use it?" True or False

a)

True

b)

False

33.

Data entry forms can be designed on

a)

MS Word

b)

MS Publisher

c)

MS Access

d)

Ms Excel

34.

What are the first 3 stages of system life cycle?

a)

Analysis,observation and design

b)

Design, implementation and testing

c)

Analysis, design and observation

d)

Analysis, Design, Development and testing

35.

What does verified data do?

a)

Output accurate data

b)

Output good quality data

c)

Allow sources to be acknowledged

d)

Verify data

36.

What does a data submission do?

a)

Submit data

b)

Indicate source and data

c)

Indicate both source and references

d)

Verify data

37.

What is the Freedom of Information Act

a)

An act that sets information freeeeeeee

b)

An act that allows people to access documents held by ASIO

c)

An act that allows people to access documents held by the government

d)

An act that allows people to access data and documents held by the FBI

38.

What can the Freedom of Information Act do?

a)

Update out of date data through a minister or agency

b)

Change data

c)

Remove data

d)

Alter data through NESA

39.

What does APP stand for?

a)

Australian Privacy Principles

b)

Advanced Page Processing

c)

Applecare Protection Plan

d)

Asynchronous Pluggable Protocol

40.

What do the Australian Privacy Principles do?

a)

Outline how the government uses and manages personal information for the disclosure of government related identifiers

b)

Enforce privacy in relation to the government and its data

c)

Allow the data collected by the government to be private

d)

Allow data to be private for an individual

41.

What does data quality refer to?

a)

How reliable the information is in terms of its physical and logical validity

b)

If the data scored is correct

c)

How reliable and effective the data is in relation to the purpose

d)

How good the source of data is

42.

What does accuracy of data refer to?

a)

If the data stored is correct

b)

How good the source of data is

c)

How reliable and effective the data is to the purpose

d)

How reliable the information is in terms of its physical and logical validity

43.

What can access, ownership, and control of data do?

a)

Change the source of data

b)

Decrease reliability

c)

Change accuracy and quality of data

d)

Make the data more secure

44.

What is a data warehouse?

a)

A warehouse inside a database

b)

A warehouse full of databases

c)

A large store of data accumulated from a wide range of sources within a company which is used to guide management decisions

d)

A warehouse made of databases

45.

What is data mining?

a)

The process of examining large, pre-existing databases in order to generate new info

b)

The process of mining data

c)

The collection of data in order to find information

d)

The collection of data in order to make a new database

46.

What is OLAP

a)

Online Analytical Processing

b)

Online Transaction Processing

c)

Databases that allow transactions to be processed immediately by remote users

d)

A technique that provides statistical evidence to business decision makers based on past trends

47.

What is OLTP

a)

A technique that provides statistical evidence to business decision makers based on past trends

b)

Online Analytical Processing

c)

Online Transaction Processing

d)

Databases that allow transactions to be processes immediately by remote users

48.
What is the meaning of CPU?
a)
Central Processing Unit
b)
Crucial Processing Unit
c)
Critical Processing Unit
d)
Center Processing Unit
49.
The acronym for PC stands for
a)
Private Computer
b)
Personal Computer
c)
Personal Compact
d)
Privacy Computer
50.
This computer is a multiprocessing computer system that is smaller and slower than a mainframe.
a)
Supercomputer
b)
Personal Computer
c)
Minicomputer
d)
Embedded Computer
51.
Complex scientific research is usually done by
a)
Mainframe computer
b)
Supercomputer
c)
Minicomputer
d)
Microcomputer
52.
A laptop is an example of a personal computer
a)
TRUE
b)
FALSE
53.
Among the disadvantages of information technology is a violation of privacy. Which one of these is true on violation of privacy?
a)
Adults, teens and children around the world are using computers to share publicly t heir photos, videos, journals, music and other personal information.
b)
Individual suffering from technology overloads feels distressed when deprived of computers and mobile devices.
c)
Personal and confidential records were not protected properly, individuals have found their privacy violated and identities stolen.
d)
Sharing personal idea, photos and videos with others.
54.
Choose the best answer that defines information technology.
a)
Sharing personal idea, photos and videos with others.
b)
Involve having a current knowledge and understanding of computer.
c)
The use of hardware and software to store, retrieve and manipulate information.
d)
To enable us to play games or access other sources of information.
55.
Information Technology can be defined as the use of _____________ and ___________, to store, retrieve and manipulate information.
a)
hardware and tools
b)
hardware and software
c)
hardware and softcopy
d)
tools and software
56.
One of the advantages of Information Technology is
a)
Speed and power
b)
Strength and power
c)
Speed and accuracy
d)
Speed and Strength
57.
The fastest supercomputer nowadays is
a)
Cray Titan
b)
Cray Jaguar
c)
Sunway TaihuLight
d)
NUDT-Tianhe-2
58.
The above picture is an example of what categories of computer?
a)
Mainframe
b)
Supercomputer
c)
Hugecomputer
d)
Maincomputer
59.
What type of categories of computer for the above picture.
a)
Personal Computer
b)
Mobile Computer
c)
Mobile Devices
d)
Embedded Computer
60.
The picture above is the example of what category of computer?
a)
Supercomputer
b)
Mainframe
c)
Maincomputer
d)
Superframe
61.
One of the applications of IT is
a)
E-perolehan
b)
Maybank2u
c)
Travel
d)
Global Positioning System
62.
One of the disadvantages of Information Technology is
a)
High risk
b)
Deep impact
c)
Impact on population
d)
Impact on labour force
63.
Learning Management System is an application of IT in
a)
Finance
b)
Web blogging
c)
Education
d)
Web Based Learning
64.
IPad comes from one of this category of computer.
a)
Mobile computer
b)
Mobile phone
c)
Embedded computer
d)
Mobile tablet
65.
These are examples of IT application in finance.
a)
Online ticketing and GPS
b)
Online banking and EPS
c)
Online gaming and FPS
d)
Online storage and RPS
66.
With the advance of Information Technology, doctors nowadays are help by this kind of technology called? (Refer to the picture.)
a)
Telephone
b)
Telemedicine
c)
Telerobotic
d)
Telesurgery
67.
One of the applications of Information Technology is
a)
Health issue
b)
Health problem
c)
Health care
d)
Health smart
68.
One of the characteristics of mobile computer is
a)
big
b)
fast
c)
portable
d)
teleport
69.
Consumer electronics and home automation system are examples of what category of computer?
a)
Mobile device
b)
Embedded computer
c)
Mobile computer
d)
Mini computer
70.
Mainframe can also act as a ________ in a network.
a)
Manager
b)
Server
c)
Client
d)
Helper
71.
One of the examples of IT application in manufacturing is CAM. What does CAM stands for?
a)
Camera and monitor
b)
Computer and monitor
c)
Computer aided manufacturing
d)
Computer aided maturity
72.
Cochlea implant allows a deaf person to listen. What branch of applications in Information Technology does it come from?
a)
Health
b)
Science
c)
Education
d)
Manufacturing
73.
All of these are applications in Information Technology except
a)
Manufacturing
b)
Education
c)
Internet
d)
Finance
74.
You can read newspaper online which is one of the applications of Information Technology.
a)
e-book
b)
online newspaper
c)
publishing
d)
online blog
75.

It is the process of merging text, sound, still and animated images, and video in one application to display it to the user in an attractive and interesting way for achieving specific goal.

a)

Photoshop

b)

Multimedia

c)

Author

d)

Programmer

76.

He is responsible to design the multimedia elements and merging all its elements by using Multimedia Authoring

a)

Photographer

b)

Programmer

c)

Acoustic Engineer

d)

Author

77.

He is combining acoustic files and section and preparing them for use in applications

a)

Photographer

b)

Programmer

c)

Acoustic Engineer

d)

Author

78.

This is to specify the Idea of the application and correct planning for it

a)

Planning step

b)

preparation step

c)

Collecting step

d)

Execution step

Similar Resources on Wayground

Aplikasi presentasi

75 questions

Aplikasi presentasi

quiz

Worksheet

•

8th Grade - University

UH2 PBO Sem 2 2021/2022 SMKN9 Medan

75 questions

UH2 PBO Sem 2 2021/2022 SMKN9 Medan

quiz

Worksheet

•

11th Grade - University

Cybersecurity Pre-Test Questions

76 questions

Cybersecurity Pre-Test Questions

quiz

Worksheet

•

11th Grade - University

CompTIA A+ 1102

77 questions

CompTIA A+ 1102

quiz

Worksheet

•

9th Grade - Professio...

AQA A-Level Grand Quiz

80 questions

AQA A-Level Grand Quiz

quiz

Worksheet

•

11th - 12th Grade

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