Deck 11: Databases

Question 1

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

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

Answer 1

D

Question 2

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

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

Answer 2

B

Question 3

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 3

D

Question 4

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

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

Question 5

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

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

Question 6

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 7

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

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

Question 8

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

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

Question 9

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 specialized programming language called _______.

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

Question 10

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 11

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

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

Question 12

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

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

Question 13

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 14

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 15

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 16

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 17

A field that uniquely identifies each record.

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

Question 18

In _______, data from 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 19

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 20

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

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

Question 21

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

Question 22

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 23

Data redundancy can occur due to lack of data integrity.

Question 24

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

Question 25

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

Question 26

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

Question 27

A hierarchical database uses many-to-many relationships.

Question 28

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

Question 29

Relational database tables require a common data item.

Question 30

A record is a collection of related tables.

Question 31

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

Question 32

Data consists of only numbers, letters, and symbols.

Question 33

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 34

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 35

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

Question 36

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

Question 37

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 38

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 39

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

Question 40

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

Question 41

_______ processing is also known as online processing.

Question 42

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

Question 43

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

Question 44

The most basic logical element of data is a _______.

Question 45

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

Question 46

A ______ is a group of related characters.

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

Individual databases are the foundation of management information systems.

Question 52

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

Question 53

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

Question 54

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

Question 55

A _______ is a collection of related records.

Question 56

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

Question 57

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

Question 58

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 59

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

Question 60

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

Question 61

How does a relational database differ from a hierarchical database?

Question 62

List and describe the five basic DBMS subsystems.

Question 63

LexisNexis is an example of a _______ database.

Question 64

Explain commercial databases and provide examples.

Question 65

A _______ database, sometimes called a data cube, allows data to be viewed as a cube having three or more sides and consists of cells.

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

Explain the components of data organization.

Question 72

What are the advantages of having databases?

Question 73

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

Question 74

Compare and contrast the physical and logical views of data.

Question 75

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

Question 76

Describe the structure and functionality of a hierarchical database.

Question 77

Describe the workings of an object-oriented database.

Question 78

Differentiate between the individual database and the company database.