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

Question : 1

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

Question : 2

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

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

The data in a record is of the following types

a) four text fields and three numeric fields

b) two integer fields and five text fields

c) three text fields and four numeric fields

d) none of the above

Question : 5

What is the term to ask the computer to pt information in order numerically or alphabetically ?

a) Crop

b) Report

c) Sort

d) Organize

Question : 6

You want to keep track of addresses, phone numbers, parent/guardian names as well as class attendance, average and grades. Every so often you want to send reports home that select failing grades and excessive absences. The following of the Microsoft Office suit used in this course is best suited for this kind of information

a) Excel

b) PowerPoint

c) Access

d) Word