data base management system (DBMS) Practice Questions Answers Test with Solutions & More Shortcuts

Question : 6

Which of the following terms does not describe a database structure used by a DBMS to link data from several files?

a) Relational

b) Structural

c) Network

d) All of the above

Question : 7

Memo field in database file is used to

a) Store lengthy number

b) Store images

c) Store audio files

d) Store long textual information

Question : 8

What is the abbreviation used for a software package that permits the user to create, retrieve and maintain records in a database?

a) DASD

b) FMS

c) EMMS

d) DBMS

Question : 9

Different levels of access are assigned to personnel records in the health and fitness gym. Only the system manager is able to create delete or edit records. Certain other personnel are allowed to view all the records, whereas others are not permitted to view complete records. The levels of access are controlled by

a) Password

b) User id’s

c) Status

d) None of the above

Question : 10

What did the first Table Analyzer do?

a) Analyze the data in a set of flat files and automatically create a relational database system from that information

b) Provide a graphic way to design relational databases

c) Automate process of connecting tables to SQL Server

d) None