Deck 5: Database Management and Access

Question 1

A repository for data, usually covering some specific topic is called

A)Data acquisition
B)Data bank
C)Real time
D)Database

Answer 1

Data bank

Question 2

A notation for defining the form and structure of data is known as

A)Data description language
B)Binary language
C)Data channels
D)Data definition language

Answer 2

Data definition language

Question 3

A data item, which is not broken down into smaller units, is

A)Data element
B)Elementary data item
C)Data entry
D)Database management

Answer 3

Elementary data item

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 repository for data, usually covering specific topic is

A)Database
B)Data requisition
C)Data bank
D)Data collection

Question 6

A set of programs that handle firm's data base responsibilities is called a

A)Database Management System (DBMS)
B)Database Processing System (DBPS)
C)Data Management System (DMS)
D)All of above

Question 7

Which of the following is not a relational database?

A)dBase IV
B)4th Dimension
C)FoxPro
D)Reflex

Question 8

Which is used to provide the sight information to the right person at the right time for proper decision making ?

A)DBMS
B)MIS
C)ISO
D)PSO

Question 9

Dbase-III was developed by

A)Dec
B)IBM
C)Ashton-tate
D)All of the above

Question 10

Which of the following database objects asks a question of information in a database and then displays the result?

A)Tables
B)Reports
C)Queries
D)Forms

Question 11

What data type should you choose for a zip code field in a table?

A)Text
B)Number
C)Memo
D)All of above

Question 12

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 13

What happens when you add the asterisk (() from any field list ot a query?

A)The table will not include any fields from the table
B)The query sorts the table's record in the order you specify
C)The query will include every field from the table*
D)The query uses the records from the table without displaying them

Question 14

The modify operation is likely to be done after

A)delete
B)look up
C)insert
D)all of above

Question 15

The criteria BETWEEN 1/1/99 and 12/31/99 would which is proper

A)Display records between the dates 1/2/ 99 and 1/1/00
B)Display records between the dates 1/1/ 99 and 12/31/99
C)Display records whose dates equaled 1/1/99 or 12/31/99
D)All of the above

Question 16

DDP stands for

A)Distributed Double Processing
B)Double Decimal Processing
C)Distributed Data Programming
D)Distributed Data Processing

Question 17

To see sales amount figures totaled, into which drop area would you drag that field?

A)Drop column fields here
B)Drop row fields here
C)Drop data items here
D)None of the above

Question 18

Which access feature do you use to develop applications that host access data on the web?

A)Dynamic web data
B)Data access pates
C)Html data pages
D)None of the above

Question 19

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 20

A data structure consisting of several fields, some or all of which are instances of the same data structure, is called

A)Field
B)Bead
C)Database
D)Data collection

Question 21

A group of characters used to identiry a given low level instruction is

A)File
B)Record
C)Key field
D)Label

Question 22

One or more characters used to identify a data field in a computer program is

A)File name
B)Database
C)Label
D)Group

Question 23

In Form view, which command displays records alphabetically?

A)Find
B)Advanced Filter/Sort
C)Sort
D)All of the above

Question 24

Where do report and forms get their information form?

A)Forms
B)Modules
C)Tables
D)Queries

Question 25

The number of logical records in a physical record is

A)group
B)blocking factor
C)sector
D)field