This is an event (such as ordering a product) that creates or modifies data in a computerised or manual system.
What is a Transaction?
100
The main aim of this is to produce a high quality system that meets its objectives and requirements.
What is project management?
100
This is a:
collection of data organised into one table on a DB
What is a flat file DB?
100
These five fields are:
Text/numbers
Audio
Images/Animation
Video
Hypertext/hyperlinks
What is elements of a Multimedia system?
100
These are formal set of rules and procedurs that must be establishe for two devices to transfer data efficiently and successfully.
What are protocols.
200
The following examples are part of what?
1. Verification of data at entry time - the design of the layout should limit the possibility of errors.
2. Comparison of the data by the program to the expected range of data.
What is data validation?
200
Time, scope and money are:
What are the three sides of the project management triangle?
200
These are 6 columns of what?
Field name
Data type
Data Format
Field Size
Description
Example
What is a data dictionary?
200
These are suitable formats for which type of file?
.doc
.txt
.Pdf
.xls
.odt
.rtf
What are text files?
200
This is the protocol that allowes datta packes (datgrams) to move form sender to receiver.
What is Internet Protocols (IP).
300
These bellow are what in relation to a database?
Sequential files
Indexed Sequential Files
Hased files
What is data stored in a database
300
This is a horizontal bar chart used to graphically show schedules and track individual tasks within a project.
What is a Gantt chart?
300
These are commands:
'Select' means which fields to display
'From' means the tables you get the fields from
'Where' refers to the criteria given
'Order by' refers to the sorting method
Name the 4 SQL commands and what each of them means?
300
This equation is used:
x
-----------------------
8 x (1024)^2
What is converting bits to megabytes?
300
This refers to the number of signal events occuring each second along a communicatin channel and is equivalent to the number of symbols per second.
What is baud rate.
400
These are identifying and outlining types of what?
Full backup - grandfather (oldest), father, son (youngest)
Partial backup is of two main types - differential (full copy periodically plus a regular copy of all the files that have changes) and incremental (only the files that have changes are copied)
What is back up types.
400
The following are:
1. Understanding the Problem
2. Planning
3. Designing
4. Implementing
5. Testing, evaluating and maintaining
What is the Systems Development Life Cycle?
400
This is the process of organising data into tables so that the results of using the DB are unambiguous and as intended. Its aim is to reduce data redundancy.
Oultine what is normalisation?
400
This persons role is to:
To work through stages of the system development cycle.
to identify purpose, suitability, sensibility, design of system.
What is the role of a system designer?
400
IT has 7 layers
What is the OSI Model.
500
These are methods for what?
- Passwords and Biomentric methods (Fingerprints and retinal scans)
- Data encryption and firewalls to stop hackers.
What are the first and second levels of security methods?
500
These skills are:
Mirroring, paraphrasing, summarising, clarifying questions, motivational responses, conflict resolution, team building
What are communication skills?
500
These are part of what:
One to one (1:1) - one record from a table is associated with one record from another table
One to many (1:m) - means one record is associated with many records
Many to many (m:m) - means that many records can be associated with many records in another table.
What is a schematic diagram.
500
Binary for:
11111110
What is is the binary representation of 254?
500
These are steps in what?
1. The SMTP server establishes connection.
2. Performs a DNS lookup
3. DNS lookup detertmines the IP address
4. Message is sent over the internet to machine
5. The receiving maching server accepts message.