Computer Awareness Online Test - 3

1. Primitive operations common to all record management systems include
Print
Sort
Look-Up
All of the above

2. Each of data files has a _______ that describe the way the data is stored in the file.
File Structure
Records
Fields
Databases

3. What is the language used by most of the DBMS for helping their users to access data?
High level language
Query language
SQL
4GL

4. Data item characteristics that are important in data management include
Punctuation
Language
Spelling
Width

5. A locked file can be
Accessed by only one user
Modified by users with the correct password
Is used to hide sensitive information
Both (b) and (c)

6. If the record management system allows you to edit values before they are recorded on disk, you can
Correct spelling changes before they are recorded
Change the name of a field
Change the width of a field
All of the above

7. Which command is used to remove an index from the database in SQL?
DELETE INDEX
DROP INDEX
REMOVE INDEX
ROLL BACK INDEX

8. What is the name given to the database management system which is able to handle full text data, image data, audio and video?
Full media
Graphics media
Multimedia
Hypertext

9. When using a database management system, the first thing that you must do is to
Create a database file
Activate file editor
Load the software into your microcomputer
Keep a floppy disk in readiness

10. If the record management system allows you to edit values before they are recorded on disk, you can
Correct spelling changes before they are recorded
Change the name of a field
Change the width of a field
All of the above

Score =
Correct answers: