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

Question : 1

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

Question : 2

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

A collection of interrelated records is called a

a) management information system

b) spreadsheet

c) database

d) text file

e) None of these

Question : 4

A Field is a related group of __________.

a) Records

b) Files

c) Characters

d) Cables

e) None of the above

Question : 5

The method of file organization in which data records in a file are arranged in a specified order according to key filed is known as the

a) Direct access method

b) Queuing method

c) Predetermined method

d) Sequential access method

e) None of these

Question : 6

The table wizard

a) Quickly creates a default report

b) Displays a subset of the data in a database

c) Contains sample tables and fields you can use to create a table

d) Automatically edits your data as you enter it