wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Computer Science Unit 1 Glossary

Total questions: 46

Worksheet time: 23mins

Name
Class
Date
1.

Field contents which cannot be further logically divided into other fields.

a)

Atomicity

b)

Relation

c)

Composite Key

d)

Data duplication

e)

Table

2.

A name which defines a field in a database table.

a)

Attribute

b)

System

c)

Validation

d)

Relationship

e)

Primary Key

3.
A system entry security measure based on user input, such as a digital signature, username and password, or forms of biometrics.
a)
Authentication
b)
System boundary
c)
Normalisation
d)
Data redundancy
e)
System boundary
4.
Database: data type exhibiting only two possible conditions – true or false
a)
Boolean
b)
Systems development life cycle (SDLC)
c)
Project
d)
Data type
e)
Systems development life cycle (SDLC)
5.
The relationship defined between two relational database entities.
a)
Cardinality
b)
Atomicity
c)
Project management
d)
Database
e)
Atomicity
6.

Data type, that is one byte in size, able to hold a single alphanumeric entry.

a)

Character

b)

Boolean

c)

Integer

d)

String

e)

Real

7.
Software tools use to assist in the development of software during the SDC, including code generation, and the creation of Gantt and PERT charts.
a)
Computer-aided software engineering (CASE)
b)
Authentication
c)
Query
d)
Entity
e)
Authentication
8.

A statement or expression for which there can only be a true or false outcome.

a)

Condition

b)

Declaration

c)

Exclamation

d)

Entity

e)

Interrogation

9.
Top level diagram that graphically defines the system boundary and the flow of data between the system and external entities.
a)
Context diagram
b)
Character
c)
Relationship
d)
Entity relationship (ER) diagram
e)
Cardinality
10.
Raw facts that represent real-world items which become information when organised. Singular – datum.
a)
Data
b)
Computer-aided software engineering (CASE)
c)
Report
d)
Form
e)
Character
11.
Data inconsistencies (update, deletion and insertion) that affect the integrity of the database.
a)
Data anomaly
b)
Condition
c)
Resolving
d)
Gantt chart
e)
Computer-aided software engineering (CASE)
12.
Metadata that describes the attributes of data to be stored in a database.
a)
Data dictionary
b)
Constant
c)
Software development cycle (SDC)
d)
Integrity
e)
Condition
13.
Data that is physically duplicated across a database.
a)
Data duplication
b)
Context diagram
c)
Software licence
d)
Primary
e)
Constant
14.

Visual representation describing the flow of data through a system.

a)

Data flow diagram (DFD)

b)

Data

c)

Standard operating environment (SOE)

d)

Foreign Key

e)

Entity Relationship diagram

15.
Duplication of the same attributes in a table; attribute data that can be derived from other existing data.
a)
Data redundancy
b)
Data anomaly
c)
String
d)
Composite Key
e)
Data
16.
The characteristics of data that can be stored in a cell, such as integer, real, Boolean and string.
a)
Data type
b)
Data dictionary
c)
Structured query language (SQL)
d)
Malware
e)
Data anomaly
17.
A collection of related data which allows input, editing and deletion, and can be queried for patterns, and produce reports and charts.
a)
Database
b)
Data duplication
c)
Syntax
d)
Normalisation
e)
Data dictionary
18.
Process of encoding data via the implementation of an encryption key.
a)
Encryption
b)
Data flow diagram (DFD)
c)
System
d)
Project
e)
Data duplication
19.

In Database analysis: this represents a table in a relational database.

a)

Entity

b)

Data redundancy

c)

Relationship

d)

Key

e)

Attribute

20.

In System Analysis (DFD and Context Diagrams) : the source or sink of the data which flows into or out of a system and over which the system has no control.

a)

Entity

b)

Data type

c)

Systems development life cycle (SDLC)

d)

Prototype

e)

Data redundancy

21.
A data modelling technique allowing the graphical representation of the relationships between the entities in the database.
a)
Entity relationship (ER) diagram
b)
Database
c)
Atomicity
d)
Query
e)
Data type
22.
User interface for data entry, modification and query.
a)
Form
b)
Encryption
c)
Attribute
d)
Redundant array of inexpensive devices (RAID)
e)
Database
23.

Relates to the accuracy and consistency of the data. Primary areas include referential, entity and domain.

a)

Integrity

b)

Entity

c)

Boolean

d)

Report

e)

Fragmentation

24.

In Databases: an attribute which uniquely identifies a record in a table.

a)

Primary Key

b)

Entity relationship (ER) diagram

c)

Cardinality

d)

Resolving

e)

Entity

25.
In Databases: an attribute in a table which refers back to a primary key in a related table.
a)
Foreign Key
b)
Form
c)
Character
d)
Software development cycle (SDC)
e)
Entity relationship (ER) diagram
26.

In Databases: a primary key consisting of two or more attributes.

a)

Composite Key

b)

Gantt chart

c)

Computer-aided software engineering (CASE)

d)

Software licence

e)

Form

27.
Malicious software designed to covertly access a system and cause harm.
a)
Malware
b)
Integrity
c)
Condition
d)
Standard operating environment (SOE)
e)
Gantt chart
28.
The process of identifying and eliminating data anomalies, duplication and redundancies, thereby improving data integrity and storage in a relational database.
a)
Normalisation
b)
Primary
c)
Constant
d)
String
e)
Integrity
29.
Stimuli in the format of a case study or narrative presented to students undertaking a task, assignment or exam.
a)
Project
b)
Foreign Key
c)
Context diagram
d)
Structured query language (SQL)
e)
Primary
30.
The management of a temporary task with defined start and end parameters that includes planning, budgeting, quality control, and/or human resources.
a)
Project management
b)
Composite Key
c)
Data
d)
Syntax
e)
Foreign Key
31.
A model of a system produced using the iterative method involving design, create, and evaluate. Used in contrast to a formal SDLC method.
a)
Prototype
b)
Malware
c)
Data anomaly
d)
System
e)
Composite Key
32.
A method of interrogating a database to extract information. Examples include QBE and SQL.
a)
Query
b)
Normalisation
c)
Data dictionary
d)
System boundary
e)
Malware
33.
Storage technology that divides and replicates data among multiple device drives.
a)
Redundant array of inexpensive devices (RAID)
b)
Project
c)
Data duplication
d)
Systems development life cycle (SDLC)
e)
Normalisation
34.

Another name for a table within a (relational) database.

a)

Relation

b)

Project management

c)

Data flow diagram (DFD)

d)

Atomicity

e)

Project

35.

In a relational database, this describes how two tables are related to each other via the use of primary and foreign keys.

a)

Relationship

b)

Prototype

c)

Data redundancy

d)

Attribute

e)

Project management

36.
The result of a query provided in a formalised format.
a)
Report
b)
Query
c)
Data type
d)
Authentication
e)
Prototype
37.
The process of converting a M:N cardinality into a 1:M and M:1 set of cardinalities.
a)
Resolving
b)
Redundant array of inexpensive devices (RAID)
c)
Database
d)
Boolean
e)
Query
38.
The formalised development structure imposed upon the creation of software.
a)
Software development cycle (SDC)
b)
Relation
c)
Encryption
d)
Cardinality
e)
Redundant array of inexpensive devices (RAID)
39.
A legal instrument governing the intellectual property rights of a software creator.
a)
Software licence
b)
Relationship
c)
Entity
d)
Character
e)
Relationship
40.
The specification of hardware, operating systems and application software to be holistically applied across an office or organisation.
a)
Standard operating environment (SOE)
b)
Report
c)
Entity
d)
Computer-aided software engineering (CASE)
e)
Report
41.
A sequence of characters (often in quotation marks) normally consisting of alpha-numerics, symbols and/or spaces.
a)
String
b)
Resolving
c)
Entity relationship (ER) diagram
d)
Condition
e)
Resolving
42.
A (command line) database language that allows interrogation and manipulation of data using the following format: Select: specifies names of fields to be used in the query From: specifies the tables the data is contained in Where: specifies the criteria to be used to extract the data.
a)
Structured query language (SQL)
b)
Software development cycle (SDC)
c)
Form
d)
Constant
e)
Software development cycle (SDC)
43.

The keywords and rules relating to a specific program language.

a)

Syntax

b)

Software licence

c)

Gantt chart

d)

Context diagram

e)

Jargon

44.
A set of elements or components that interact to accomplish a required outcome.
a)
System
b)
Standard operating environment (SOE)
c)
Integrity
d)
Data
e)
Standard operating environment (SOE)
45.
An imaginary line separating the internal system from the outside elements.
a)
System boundary
b)
String
c)
Primary
d)
Data anomaly
e)
String
46.
A linear system of defined stages each of which requires completion before commencement of the following stage. The SDLC is costly, time consuming, highly documented and with little to no user input.
a)
Systems development life cycle (SDLC)
b)
Structured query language (SQL)
c)
Foreign Key
d)
Data dictionary
e)
Structured query language (SQL)

Similar Resources on Wayground

XIRPL2_PASQUIZZ

50 questions

XIRPL2_PASQUIZZ

quiz

Worksheet

•

1st Grade - Professio...

QUIZ INFORMATIKA

50 questions

QUIZ INFORMATIKA

quiz

Worksheet

•

10th Grade

Administrasi Sistem Jaringan

50 questions

Administrasi Sistem Jaringan

quiz

Worksheet

•

11th Grade

Latihan UNBK TKJ 2019

50 questions

Latihan UNBK TKJ 2019

quiz

Worksheet

•

10th Grade - University

VOIP XII

50 questions

VOIP XII

quiz

Worksheet

•

1st Grade - University

SISTEM KOMPUTER

51 questions

SISTEM KOMPUTER

quiz

Worksheet

•

10th Grade

ASK PT3 LATIHAN PKP 01

50 questions

ASK PT3 LATIHAN PKP 01

quiz

Worksheet

•

7th - 10th Grade

Integrasi Aplikasi office

50 questions

Integrasi Aplikasi office

quiz

Worksheet

•

10th Grade