Deck 11: Databases

Question 1

These types of databases are also called information utilities or data banks.

A)Distributed
B)Individual
C)Shared
D)Commercial

Answer 1

D

Question 2

A network database utilizes these special connections between nodes that allow multiple connections between records.

A)Connectors
B)Links
C)Strings
D)Pointers

Answer 2

D

Question 3

This occurs when data is processed at the same time the transaction occurs.

A)Batch processing
B)Group processing
C)Real-time processing
D)Consignment processing

Answer 3

C

Question 4

This subsystem defines the logical structure of the database, such as a field names and data types.

A)Data manipulation
B)Application generation
C)Data administration
D)Data definition

Question 5

These databases store not only data but also instructions to manipulate the data.

A)Hierarchical
B)Network
C)Object-oriented
D)Multidimensional

Question 6

Which view of data deals with how the data is actually formatted and located?

A)Physical view
B)Logical view
C)Information view
D)Technical view

Question 7

If Mr.Smith's bike has been sent to his new address, but the bill to his old one, it can most likely be attributed to a lack of data:

A)integrity
B)maintenance
C)redundancy
D)administration

Question 8

The data and the DBMS are stored either on the user's hard-disk drive or on a LAN file server in these databases.

A)Company
B)Individual
C)Commercial
D)Web

Question 9

This occurs when transactions are collected and processed all at once.

A)Batch processing
B)Group processing
C)Real-time processing
D)Consignment processing

Question 10

Which of the following is not an advantage of using a database?

A)Security
B)Reliability
C)Sharing
D)Data Integrity

Question 11

Having several instances of the same data is called data:

A)repetition
B)duplication
C)doubling
D)redundancy

Question 12

This type of database is organized into many tables with common data items (key fields) linking the tables to one another.

A)Hierarchical
B)Multidimensional
C)Relational
D)Network

Question 13

A collection of related fields such as a person's name, address, and age.

A)Character
B)Record
C)Field
D)File

Question 14

In the object-oriented database model, this term is the equivalent to a field in a relational model.

A)Entity
B)Class
C)Method
D)Attribute

Question 15

Which of the following is an advantage of using multidimensional databases?

A)Smaller hard disk usage
B)Network ability
C)Simpler relationships
D)Conceptualization

Question 16

In this subsystem, a user can create data entry forms.

A)Data administration
B)DBMS engine
C)Data definition
D)Application generation

Question 17

A field that uniquely identifies each record.

A)ID
B)Primary key
C)Common
D)Numeric

Question 18

In this database model, the fields or records are structured in nodes.

A)Relational
B)Hierarchical
C)Multidimensional
D)Object-oriented

Question 19

Analysis tools that support viewing all or selected parts of data, querying the database, and generating reports include query-by-example as well as:

A)SQL
B)HTML
C)XML
D)VBA

Question 20

A data field that represents a description or characteristic of some entity.

A)Character
B)Attribute
C)Record
D)Entity

Question 21

A record is a collection of related tables.

Question 22

If all the data in a database is not physically located in one place, it would be a(n)_____ database.

A)individual
B)Web
C)commercial
D)distributed

Question 23

Database tables can be related or connected to other tables by common key fields.

Question 24

In order to create, modify, and gain access to a database, special software called the database management system is required.

Question 25

The logical view of data focuses on meanings and content of the data.

Question 26

Querying the database and generating reports is assisted by the application generation subsystem.

Question 27

This commercial database offers news and information on legal, public records, and business issues.

A)CSi
B)Dialog Information Services
C)Dow Jones Interactive Publishing
D)LexisNexis

Question 28

In a network database, nodes may have a many-to-many relationship.

Question 29

The logical arrangement of data in a database is called the database model.

Question 30

Typically, one of the duties of a database administrator is to interact with the data administration subsystem.

Question 31

The ATM works on the principle of real-time processing.

Question 32

In a network database, a node can be traced down through different branches.

Question 33

Data consists of only numbers, letters, and symbols.

Question 34

The database in which data elements are organized using classes, objects, attributes, and methods is called the object-oriented database.

Question 35

Relational database tables require a common data item or key field.

Question 36

Access to these databases is offered to the public or selected outside individuals, for a fee.

A)Data warehouses
B)Commercial databases
C)Company databases
D)Distributed databases

Question 37

A hierarchical database uses many-to-many relationships.

Question 38

Information collected by an organization from a variety of external and internal databases is stored in this special type of database.

A)Data warehouse
B)Commercial database
C)Company database
D)Company warehouse

Question 39

Data redundancy can occur due to lack of data integrity.

Question 40

The combined information presented on this type of database can be used to change the whole merchandising strategy of a store.

A)Commercial
B)Individual
C)Company
D)Distributed

Question 41

The duties of a database administrator include the determining of which people have access to what kinds of data in the database, referred to as _____ rights.

Question 42

_____ processing is also known as online processing.

Question 43

In a(n) _____ database, any action on one element immediately affects the elements related to it.

Question 44

In a network database, a node may be reached through more than one path with the help of _____.

Question 45

A commercial database is generally an enormous database that an organization develops to cover particular subjects.

Question 46

A record represents a collection of attributes that describe a(n) _____.

Question 47

The company database may be stored on a central database server and managed by a database administrator.

Question 48

The analysis tools associated with the _____ subsystem include query-by-example and structured query languages (SQL).

Question 49

The scenario wherein many files about the same person exist across different departments within an organization is called data _____.

Question 50

The most basic logical element of data is a(n) _____.

Question 51

In a distributed database, all the data must be physically located in one place.

Question 52

In an object-oriented database, attributes are specific instances of a class that can contain both data and instructions to manipulate the data.

Question 53

The analysis tools associated with the data manipulation subsystem that support querying databases include _____ and structured query languages (SQL).

Question 54

Data _____ ensures that there aren't multiple sources of the same data.

Question 55

Each entry in a(n) _____ database has one parent node, with the parent node having several child nodes.

Question 56

A(n) _____ is a collection of related records.

Question 57

A(n) _____ represents a collection of attributes that describe an entity.

Question 58

A monthly bank credit card bill is the result of _____ processing.

Question 59

The data _____ or schema contains a description of the structure of data in the database.

Question 60

Individual databases are the foundation of management information systems.

Question 61

What is the difference between the individual database and the company database?

Question 62

How does a relational database differ from a hierarchical database?

Question 63

What are some measures that can be taken to ensure a database's security?

Question 64

Object-oriented databases organize data using objects, classes, entities, attributes, and _____.

Question 65

Users of a(n) _____ database have access through their microcomputers linked to local or wide area networks.

Question 66

Describe the workings of an object-oriented database.

Question 67

List and describe the five basic DBMS subsystems.

Question 68

Define the physical and logical views of data.

Question 69

Describe the structure and functionality of a hierarchical database.

Question 70

In a(n) _____ database, a node may be reached through more than one path with the help of pointers.

Question 71

LexisNexis is an example of a(n) _____ database.

Question 72

What are the advantages of having databases?

Question 73

Explain commercial databases with examples.

Question 74

A(n)_____ database, also called a microcomputer database, is a collection of integrated files primarily used by just one person.

Question 75

In a(n) _____ database, not all the data in a database is physically located in one place.

Question 76

In the _____ database, data elements are stored in different tables, each of which consists of rows and columns.

Question 77

A(n) _____ database includes multiple dimensions, sometimes called a data cube.

Question 78

Explain the components of data organization.