Data Processing SS 3 Mock Exams

DATA PROCESSING

1. Data models describe ……… data for storage in data management systems (a) structured (b) unstructured (c) integer (d) alphabetic

2. Which of this is not an example of standard data model (a) ISO 10303 (b) ISO 15926 (c) IDEAS GROUP d) Good shepherd

3 key is a field in a relational table that matches a primary key of another

table (a) foreign (b) surrogate (c) primary (d) candidate

4 is graphical representation of entities and their relationships to each

other (a) Entity-Relationship Diagram (b) Entity-Relationship Picture (c) Entity- Relationship Data (d) Entity-Relationship Symbol

5. A roof covers a building describes …………relationship (a) one-to-one (b) one-to- many (c) many-to-many(d) none of the above

1. ………. is a database table that has been reduced to certain fields.a) Table b) An index c) Table model d) Network model

2. The copy of an index is always in …… form. a) duplicate b) field c) sorted d) domain

3. The index can take place only if the data records are sorted on the search

key field. a)unclustered b)insert c) update d) clustered

4. A can contain several unclusterd indexes a) data file b) primary c) check

d) index

5. Index contain a value and a)pointer b) sign c) update d) model

1. ………. is an index in which the search k lọey contains some candidate key. a) Unique index b) An index c) composite d) sparse index

2. …… can be created on a non- key attribute. a) primary index b) dense index c) secondary index d) sparse index

3. A sparse index contains one entry for each ……of records in the data file. a) page

b) table c) row d) column

4 is the one in which not all fields in the Search key are bound to constant. a)

dense index b) composite search key c) secondary index d) range query

5 is when the search key for an index contain several fields. a) primary index b)

composite search key c) secondary index d) unique index Maintenance is necessary on computer to avoid ……….

a) hardware failure b) stealing c) invasion d) crime

2. Excess heat accelerates the deterioration of the delicate in the system. a)

vacuum b) transistors c) circuits d) particles

3. Dust and dirt are the most common cause of a) leakage b) overheating c)

breakage d) spooling.

4 is used to remove dust, dirt and hair from the keyboard. a) Vacuum cleaner

b) Brush c) Old rag d) Paper towels

5. It is advisable to wear an to reduce transferring static electricity from your

body to the computer. a) hand glove b) anti – static wrist strip c) coat d) dust

cover

1. Which of the following is not a software maintenance? a) Virus b) Spyware c) Hard disk d) Registry removal

2. The software maintenance that involves developing and deploying solutions to problems is a) corrective b) adaptive c) preventive d) perfective

3. The software maintenance that takes care of the changes that occur in software maintenance is called a) adaptive b) corrective c) perfective d) preventive

4. Disk cleaning should be done ……….. a) hourly b) daily c) weekly d) yearly

5. Patches and update are regularly released by software companies to tackle security problems found in a) programs b) hardware c) people ware d)

peripheral

1 is the practice of keeping data protected from corruption and

unauthorized access. (a) Data measurement (b) Data security (c) Data protection (d) Data control

2. Which of these is not a type of security control ……?(a) access control (b) auditing

3 security mechanism uses mathematical schemes and algorithm to

scramble data into unreadable text. (a) Encryption (b) Auditing (c) Authentication

(d) Auditing

4 is the process of copying and archiving data so it may be used to restore

original after a data loss (a) Backup (b) Restore (c) Control (d) Saving

5 is the computer professional responsible for the configuration,

administration and maintenance of a database (a) Programmer (b) System administrator (c) Database administrator (d) System analyst

1. The process by which a database is moved back to a consistent and usable state is called (a) cash recovery (b) crash recovery (c) past recovery (d) undo

recovery

2. The recovery algorithm that uses no-force and steals approach is …………..

(a) ARIAS (b) ARIES (c) ARREARS (d) ARIS

3. ARIES works in Phases (a) 3 (b) 2 (c) 1 (d) 4

4. Which of these is not a crash recovery type …………

(a) ARIES (b) Media recovery (c) Check pointing (d) UNDO

5 Crash recovery uses backup files (a) Check point (b) ARIES (c) Media

recovery

(d) Atomicity

THEORY

1. Discuss the concept of ARIES in crash recovery.

2. Explain the difference between media recovery and check point.

3. Explain the difference between a system crash and a media failure.

THEORY

1. Explain two types of data security control.

2. Mention five (5) duties of a database administrator.

THEORY

1. List and explain the four software maintenance.

2. State four benefits of software maintenance

3. State three routine computer maintenance

THEORY

1. Explain the steps in cleaning the following: i) Mouse ii) Keyboard iii Monitor iv) DVD drive lens

2. State six tools used in cleaning computer hardware.

THEORY

1. Create a student table with the following fields: name, age, and scores of 5 records. Create an index using a composite keys name and age. (show the table and SQL statements)

2. Discuss the different types of indexing.

3. Differentiate between a unique index and a range query.

4. What is composite search key?

THEORY

1. Differentiate between clustered index and unclustered index.

2. State two reasons why clustered index is expensive to maintain.

3. What is an index?

THEORY

1. (a) Define the following terms (i) Entity (ii) Attribute (iii) Relationship

(b) What is cardinality?

2. (a) Define the following (i) Primary key (ii) Foreign key (iii) Composite primary key

(b) Explain the term Normal Form.

Spread the word if you find this helpful! Click on any social media icon to share

Tags:Examination Questions, ICT

Recommended Posts: