Question 1

A repository for data, usually covering some specific topic is called
A)Data acquisition
B)Data bank
C)Real time
D)Database

Accepted Answer

A data bank is a repository for data, usually covering some specific topic.

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

Accepted Answer

Data Definition Language (DDL) is the correct term for a notation that defines the form and structure of database objects like tables, schemas, and databases.

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

Accepted Answer

An elementary data item is the smallest unit of data that cannot be broken down into smaller parts. This term accurately describes a data item that is not divided into smaller units.

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

Accepted Answer

Data integrity refers to the accuracy and consistency of data stored in a database or a data warehouse. It ensures that the data is accurate, reliable, and consistent throughout its lifecycle.

Question 5

A repository for data, usually covering specific topic is
A)Database
B)Data requisition
C)Data bank
D)Data collection

Accepted Answer

A data bank is a repository for data, usually covering a specific topic, where data is stored and can be accessed or retrieved as needed.

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

Accepted Answer

The answer of A set of programs that handle firm's...

Question 7

Which of the following is not a relational database?
A)dBase IV
B)4th Dimension
C)FoxPro
D)Reflex

Accepted Answer

Reflex is not a relational database; it is known for being a flat-file database system, unlike the others listed which are relational databases.

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

Accepted Answer

MIS, or Management Information Systems, is designed to provide the right information to the right people at the right time to support decision-making processes.

Question 9

Dbase-III was developed by
A)Dec
B)IBM
C)Ashton-tate
D)All of the above

Accepted Answer

dBase III, a database management system, was developed by Ashton-Tate.

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

Accepted Answer

Queries are specifically designed to ask questions about information stored in a database and display the results. They can be used to filter, calculate, group, and sort data according to specific criteria.

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

Accepted Answer

Zip codes should be stored as text because they can contain leading zeros and are not used for calculations.

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

Accepted Answer

Since all people have the same last name and pin code, the only unique identifier left is the first name. However, to ensure uniqueness and clarity, combining the first name with the last name (even though it's the same for everyone) as a compound key is the most effective approach.

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

Accepted Answer

Adding an asterisk (*) to a query field list includes every field from the table in the query's results.

Question 14

The modify operation is likely to be done after
A)delete
B)look up
C)insert
D)all of above

Accepted Answer

The answer of The modify operation is likely to be...

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

Accepted Answer

The correct choice is B because it accurately represents the criteria of displaying records from January 1, 1999, through December 31, 1999, inclusive of both start and end dates.

Question 16

DDP stands for
A)Distributed Double Processing
B)Double Decimal Processing
C)Distributed Data Programming
D)Distributed Data Processing

Accepted Answer

Distributed Data Processing (DDP) refers to the use of multiple computer systems working together to process data. This approach can improve efficiency and reliability by distributing the workload across different locations or systems.

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

Accepted Answer

To see sales amount figures totaled, you would drag that field into the "Drop data items here" area. This is because the data items area is designed to handle the values that you want to perform calculations on, such as summing up sales amounts.

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

Accepted Answer

Data access pages are used to develop applications that host Access data on the web.

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

Accepted Answer

In database terminology, a column of data within a table is referred to as a "Field." Fields represent the categories of data that are stored in a table, such as a person's name, age, or address.

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

Accepted Answer

Bead is the correct term for a data structure consisting of several fields, where some or all of these fields are instances of the same data structure. This recursive property is characteristic of beads, allowing them to represent complex, hierarchical data structures.

Quiz 5: Database Management and Access

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

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

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

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

A repository for data, usually covering specific topic is

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

Which of the following is not a relational database?

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

Dbase-III was developed by

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

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

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

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

The modify operation is likely to be done after

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

DDP stands for

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

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

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

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