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

Question : 1

The following command is used for sorting

a) list

b) browse

c) index

d) sort

Question : 2

Which of the following fields would not make a suitable primary key ?

a) A date field

b) An invoice number

c) An autoNumber field

d) A customer’s social security number

Question : 3

What is the common name for a column of data within an Access table?

a) Field

b) Record

c) Row

d) None of the above

Question : 4

Which of the following terms refers to the degree to which data in database system are accurate and correct?

a) Data security

b) Data validaity

c) Data independence

d) Data integrity

Question : 5

A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be

a) The pin code

b) The last name

c) A compound key consisting of the first name and the last name

d) All of the above

Question : 6

The way a particular application views the data from the database that the applicaton uses is a

a) Module

b) Relational model

c) Schema

d) Sub-schema