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

Question : 1

A report form

a) Appears on the computer monitor during data entry

b) Is used during report generation to format data

c) Both (A) and (B)

d) All of above

Question : 2

Pack command is used to

a) Remove records permanently

b) Remove records temporarily

c) Restore records permanently

d) Restore records temporarily

Question : 3

Facilities offered by databases are

a) The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports

b) Easy editing, spell check, perform calculations, library of mathematical functions, replication

c) The ability to rotate images, copy and paste, fill scale

d) None of above

Question : 4

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

a) PASCAL

b) DDL

c) PROLOG

d) FORTRAN

Question : 5

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

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