wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Database and Information system

Total questions: 45

Worksheet time: 24mins

Name
Class
Date
1.
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.
2.
A database does NOT consist of .........
a)
field
b)
table
c)
character
d)
report
3.
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
4.
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
5.
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
6.
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.
7.
One specific piece of information about a person or thing is called:
a)
Field
b)
File
c)
Record
d)
Table
8.

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

9.

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

10.
A unique identifying field.
a)
Primary Key
b)
Integer
c)
Verification
d)
Boolean
11.

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

12.

A DBMS is responsible for

a)

creating tables and linking them together

b)

adding data inside the database

c)

Modify or delete existing data

d)

all of the listed answers

13.
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
14.
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
15.
The whole database is called:
a)
The file
b)
The field
c)
The record
d)
The table
16.

A collection of fields and records in a specific category

a)

Record

b)

Table

c)

Field

17.

In a database about school form groups, you would need to create a different _____ for each year group

a)

Table

b)

Record

c)

Field

18.
Everything on one row is a record.
a)
True
b)
False
19.
Which language is used to develop and manage databases?
a)
sql
b)
java
c)
html
d)
dbms
20.
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
21.
A data type that can only hold 2 values e.g. Yes/No or True/False.
a)
Boolean
b)
Integer
c)
Real
d)
String
22.

Which of the following data models represents data in a tree-like structure?

a)

Relational model

b)

Network model

c)

Hierarchical model

d)

Object-oriented model

23.

Which of the following data models is based on the mathematical set theory and uses tables to store data?

a)

Relational model

b)

Network model

c)

Hierarchical model

d)

Object-oriented model

24.

How many types of DBMS architectures are there?

a)

1

b)

2

c)

3

d)

4

25.

What is a data model?

a)

A way of representing data in a database

b)

 A way of managing data in a database

c)

A way of accessing data in a database

d)

A way of backing up data in a database

26.

What is a schema?

a)

A way of representing the structure of a database

b)

A way of accessing data in a database

c)

A way of backing up data in a database

d)

A way of managing data in a database

27.

This picture represents which database model

a)

Hierarchial

b)

Network

c)

Entity Relationship

d)

Relational

28.

___________, ___________ & ___________ are fields.

a)

S. No, Product Code & Description

b)

1021, Beverages & Soft drinks, coffees, teas

c)

Dairy Products, Beverages & Seafood.

d)

All of these are fields.

29.

Which of the following are common database program?

a)

MS Access

b)

Excel

c)

InDesign

d)

OpenOffice Database

30.

______________ symbol indicates that a field is the Primary Key of the table.

a)
b)
c)
d)

All of these

31.

Which of the following is an example of a DBMS

a)

MS Word

b)

Microsoft Office

c)

Java

d)

Oracle

32.

Data about data is ______________

a)

Data Description

b)

Metadata

c)

Data redundancy

d)

Data inconsistency

33.

SQL stands for

(a)  

34.

A ............ is an organized collection of structured data.

a)

information

b)

file

c)

database

d)

DBMS

35.

Data redundancy may lead to data inconsistency.

a)

True

b)

False

36.
RDBMS
a)
Relational Database Basic Management System
b)
Relational Database Management System
c)
Required Database Management Setup
d)
None of these
37.

Q1. Information systems that monitor the elementary activities and transactions of the organizations are:

a)

a. Management-level system

b)

b. Operational-level system

c)

c. Knowledge-level system

d)

d. Strategic level system

38.

Which of the following individuals typically have less formal, advanced educational degrees and tend to process rather than create information?

a)

a. Knowledge workers

b)

b. Chief Executives

c)

c. System analysts

d)

d. Data operators

39.

A human data operator can be bypassed for basic data entry when using a(n) .

a)

a. Office automation system

b)

b. Management information system

c)

c. Transaction processing system

d)

d. Decision support system

40.

Information systems can facilitate supply chain management by:

a)

a. Tracking the status of orders.

b)

b. Rapidly communicating orders.

c)

c. Providing product specifications.

d)

d. all of the above

41.

Information is______________ that is valuable and meaningful to a specific user.

a)

raw data

b)

picture data

c)

primary data

d)

processed data

42.

Data mining is a process of ___________ useful data from a larger database.

a)

extracting

b)

adding

c)

deleting

d)

reducing

43.
This is simply a collection of related information about a specific topic.
a)
database
b)
data group
c)
data key
d)
databomb
44.

The hierarchical Data Model is the oldest type of model developed by _________

a)

TCS, 1991

b)

IBM, 1968

c)

HP,1970

d)

SQW, 1965

45.

In a hierarchical model, a parent node can have only one child node

a)

TRUE

b)

FALSE

Similar Resources on Wayground

Hospitality and Tourism Management- Midterm

45 questions

Hospitality and Tourism Management- Midterm

quiz

Worksheet

•

University

Email - Northstar

50 questions

Email - Northstar

quiz

Worksheet

•

University

HMPE4- FRONT OFFICE OPERATION

50 questions

HMPE4- FRONT OFFICE OPERATION

quiz

Worksheet

•

University

ACCTG 22 FINAL EXAM

50 questions

ACCTG 22 FINAL EXAM

quiz

Worksheet

•

University

MGT269 Pre Final Test

40 questions

MGT269 Pre Final Test

quiz

Worksheet

•

University

FINANCIAL MANAGEMENT - PART-1

50 questions

FINANCIAL MANAGEMENT - PART-1

quiz

Worksheet

•

University

teori ekonomi makro

40 questions

teori ekonomi makro

quiz

Worksheet

•

University