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

Question : 1

An ad hoc query is a __________.

a) pre-planned question

b) pre-scheduled question

c) spur-of-the-moment question

d) question that will not return any results

e) None of these

Question : 2

Participants can see and hear each other in a/an

a) electronic mail system

b) message system

c) teleconference

d) bulletin board

e) None of these

Question : 3

Grouping and processing all of a firm’s transactions at one time is called

a) a database management system

b) batch processing

c) a real-time system

d) an on-line system

e) None of these

Question : 4

A collection of interrelated records is called a

a) management information system

b) spreadsheet

c) database

d) text file

e) None of these

Question : 5

A relation (from the relational database model) consists of a set of tuples, which implies that

a) relational model supports multi-valued attributes whose values can be represented in sets.

b) for any two tuples, the values associated with all of their attributes may be the same.

c) for any two tuples, the value associated with one or more of their attributes must differ.

d) all tuples in particular relation may have different attributes.

e) None of these

Question : 6

A data dictionary doesn’t provide information about

a) where data is located

b) the size of the disk storage disk

c) who owns or is responsible for the data

d) how the data is used

e) None of these