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

Question : 1

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

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

Creating a data file means

a) Designing base and defining the structure of the database

b) Getting the information about database

c) Selecting data from database

d) Deleting data from database

Question : 4

Which of the following is not a Access database object ?

a) table

b) form

c) query

d) datasheet

Question : 5

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

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