data base management system (DBMS) set 5 Detailed Explanation And More Example

Question : 1

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 : 2

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

Question : 3

A computer language for informing the DBMS regarding the data structure used is

a) PASCAL

b) DDL

c) PROLOG

d) FORTRAN

Question : 4

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 : 5

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 : 6

Need to see all the information from two tables on one form. Insert

a) A page break

b) A subform

c) A linked command button

d) None of the above