Database Logical MCQs

After you _____ a record, many data management the environments require you to issue a command to save the changes you made.

• Delete

• Update

• Sort

• None of the above

A report generator is used to

• Update files

• print files on paper

• data entry

• All of the above

Which of the following is a database administrator's function?

• database design

• backing up the database

• performance monitoring

• user coordination

• all of the above

Which command is used to remove a record from the database in SQL?

• CREATE

• READ

• UPDATE

• DELETE

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

• None

A database management system

• allows simultaneous access to multiple files

• can do more than a record management system

• is a collection of programs for managing data in a single file

• both (a) and (b)

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

A primary Key never accepts a NULL value

• True

• False

Updating a database means

• revising the file structure

• reorganizing the database

• modifying or adding record occurrences

• All of the above

The main idea behind computer files is that it is convenient to

• arrange them

• store information together

• create them

• access them