Deck 11: Databases

Question 1

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

Answer 1

D

Question 2

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

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

Answer 2

B

Question 3

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

Answer 3

A

Question 4

In _______, data is processed at the same time the transaction occurs.

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

Question 5

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 6

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 7

In _______, transactions are collected over time and then processed all at once.

A) batch processing
B) group processing
C) real-time processing
D) consignment processing

Question 8

Analysis tools that support viewing all or selected parts of data, querying the database, and generating reports include query-by-example as well as specialized programming language called _______.

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

Question 9

A field that uniquely identifies each record.

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

Question 10

This subsystem defines the logical structure of the database by using a data dictionary or schema.

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

Question 11

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

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

Question 12

Having several instances of the same data is called data _______.

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

Question 13

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

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

Question 14

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

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

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 type of database, the data and the DBMS are stored either on the user's hard-disk drive or on a LAN file server.

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

Question 17

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

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

Question 18

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

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

Question 19

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

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

Question 20

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

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

Question 21

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

Question 22

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

Question 23

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 24

A hierarchical database uses many-to-many relationships.

Question 25

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 26

Data redundancy can occur due to lack of data integrity.

Question 27

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

Question 28

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 29

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

Question 30

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

Question 31

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 32

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

Question 33

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

Question 34

A record is a collection of related tables.

Question 35

Relational database tables require a common data item.

Question 36

Data consists of only numbers, letters, and symbols.

Question 37

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

Question 38

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

Question 39

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 40

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

Question 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

_______ processing is also known as online processing.

Question 51

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

Question 52

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

Question 53

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

Question 54

The duties of a database administrator include determining which people have access to what kinds of data in the database; these are referred to as _______ rights.

Question 55

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

Question 56

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

Question 57

Individual databases are the foundation of management information systems.

Question 58

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

Question 59

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

Question 60

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

Question 61

How does a relational database differ from a hierarchical database?

Question 62

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

Question 63

Explain the components of data organization.

Question 64

List and describe the five basic DBMS subsystems.

Question 65

Users of a(n) _______ database have access through their personal computers linked to local or wide area networks.

Question 66

Differentiate between the individual database and the company database.

Question 67

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

Question 68

What are the advantages of having databases?

Question 69

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

Question 70

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

Question 71

Explain commercial databases and provide examples.

Question 72

Describe the workings of an object-oriented database.

Question 73

Compare and contrast the physical and logical views of data.

Question 74

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

Question 75

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

Question 76

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

Question 77

Describe the structure and functionality of a hierarchical database.

Question 78

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