Question 1

A spreadsheet is particularly suitable for accounting use because it automatically provides an audit trail

Accepted Answer

A) True 
 B)False

Question 2

Who usually writes computer viruses?

Accepted Answer

A)  Disgruntled workers 
B)  Terrorists 
C)  Hackers 
D)  Academic Experience 
E)  All of the above

Question 3

Which one of the following is not a function of an operating system?

Accepted Answer

A)  multiprocessing 
B)  multiprogramming 
C)  configuring the systems hardware 
D)  spell checking of documents 
E)  accessing files

Question 4

What is the essence of object-oriented programming?

Accepted Answer

A)  versatility 
B)  objectivity 
C)  inheritance 
D)  all of the above 
E)  removing the human from computer programming

Question 5

A record in a file will be uniquely identified by ? (chose from the list
below) in relational databases

Accepted Answer

A)  a protected field 
B)  a check digit 
C)  a key field 
D)  the field length 
E)  the file structure

Question 6

Due to its conceptual simplicity and powerful data manipulation
capabilities, the use of this type of database is increasing in popularity.

Accepted Answer

A)  network structure 
B)  tree structure 
C)  graphical structure 
D)  relational structure 
E)  a big one

Question 7

In database management systems the structure is a ______________
representation of the data.

Accepted Answer

A)  physical 
B)  logical 
C)  relational 
D)  tabular 
E)  hierarchical

Question 8

In the Information Systems Hierarchy. What are the levels from top to bottom?

Accepted Answer

A)  Management Planning and control systems, Transaction-processing
Systems, Strategic Planning Systems, Operational Planning and Control
Systems 
B)  Strategic Planning Systems, Management Planning and Control Systems, Operational Planning and Control Systems, Transaction-processing Systems. 
C)  Transaction-processing Systems, Operational Planning and Control
Systems, Management Planning and Control Systems, Strategic Planning
Systems 
D)  Strategic Planning Systems, Transaction-processing Systems, Management Planning and Control Systems, Operational Planning and Control Systems 
E)  Expert Systems, Executive Information Systems, Decision Support
systems, Management Information Systems, Data processing Systems

Question 9

On a tour of a factory, you are shown a computer system which produces invoice, each month. This invoicing system is an example of:

Accepted Answer

A)  A decision support system 
B)  A transactional processing system 
C)  An executive information system 
D)  An expert system 
E)  A management information system

Question 10

One of the uses of a spreadsheet model is to ask 'what if' questions and carry out analysis. Which of the following is a correct description of a
'what if' analysis?

Accepted Answer

A)  All the cells in a spreadsheet will be updated whenever an entry is changed 
B)  Numerical cells in a spreadsheet can be formatted in a variety of ways 
C)  The model can be emptied of data when circumstances require it to be changed 
D)  Changes in data input will cause the model to recalculate giving an indication of the possible results of the change 
E)  A management technique which is just a management fad

Question 11

The most widely used application on personal computers today is?

Accepted Answer

A)  databases 
B)  electronic spreadsheets 
C)  word processing 
D)  graphics 
E)  none of the above

Question 12

The development of Computer Programming Languages aim to
1. move programming to the 'end user'
2. automate the process of programming as much as possible
3. be reliable
4. be easy maintained
5. be portable
6. be transferable with other computers

Accepted Answer

A)  1, 2, 3, 5, and 6 
B)  2, 3, 4, 5, and 6 
C)  1, 2, 4, 5, and 6 
D)  3, 4, and 5 
E)  1, 2, 3, 4, 5, and 6

Question 13

If we were to add these two numbers together 5 + 9 we would get 14.
How would a computer show the number 14 in binary code?

Accepted Answer

A)  101 
B)  111 
C)  1100 
D)  1110 
E)  0101

Question 14

What provides the capability of writing, assembling, designing, and
printing high quality documents?

Accepted Answer

A)  word processing 
B)  desktop publishing 
C)  data processing 
D)  office automation 
E)  databases

Question 15

A file in database terms is:

Accepted Answer

A)  the field which uniquely identifies a record 
B)  a collection of related records 
C)  all the files of an organisation 
D)  a character of information 
E)  a collection of meaningful information

Question 16

Which of the following has limited facilities for mathematical notation but
has excellent facilities for character data processing and business use?

Accepted Answer

A)  FORTRAN 
B)  COBOL 
C)  PASCAL 
D)  ADA 
E)  VORGON

Question 17

Who can be regarded as inventing the first computer?

Accepted Answer

A)  John Eniac 
B)  Blasé Pascal 
C)  Charles Babbage 
D)  Charles Transistor 
E)  James Shockly

Question 18

Information Technology can be regarded as:
The collective technologies for the;

Accepted Answer

A)  acquisition, transmission, processing and dissemination of information. 
B)  acquisition, transmission, protection of information 
C)  capture, processing and deleting of information 
D)  processing and dissemination of information 
E)  the understanding of a computer

Question 19

The link between the logical view and the physical view of data is the:

Accepted Answer

A)  application program 
B)  DBMS 
C)  database 
D)  programming 
E)  Data Flow Diagrams

Question 20

Due to its conceptual simplicity and powerful data manipulation
capabilities, the use of this type of database is increasing in popularity.

Accepted Answer

A)  network structure 
B)  tree structure 
C)  graphical structure 
D)  relational structure 
E)  a big one

Exam 1: Computer Networks, Databases, and Programming Languages

A spreadsheet is particularly suitable for accounting use because it automatically provides an audit trail

Who usually writes computer viruses?

Which one of the following is not a function of an operating system?

What is the essence of object-oriented programming?

A record in a file will be uniquely identified by ? (chose from the list below) in relational databases

Due to its conceptual simplicity and powerful data manipulation capabilities, the use of this type of database is increasing in popularity.

In database management systems the structure is a ______________ representation of the data.

In the Information Systems Hierarchy. What are the levels from top to bottom?

On a tour of a factory, you are shown a computer system which produces invoice, each month. This invoicing system is an example of:

One of the uses of a spreadsheet model is to ask 'what if' questions and carry out analysis. Which of the following is a correct description of a 'what if' analysis?

The most widely used application on personal computers today is?

The development of Computer Programming Languages aim to 1. move programming to the 'end user' 2. automate the process of programming as much as possible 3. be reliable 4. be easy maintained 5. be portable 6. be transferable with other computers

If we were to add these two numbers together 5 + 9 we would get 14. How would a computer show the number 14 in binary code?

What provides the capability of writing, assembling, designing, and printing high quality documents?

A file in database terms is:

Which of the following has limited facilities for mathematical notation but has excellent facilities for character data processing and business use?

Who can be regarded as inventing the first computer?

Information Technology can be regarded as: The collective technologies for the;

The link between the logical view and the physical view of data is the:

Due to its conceptual simplicity and powerful data manipulation capabilities, the use of this type of database is increasing in popularity.