Deck 11: Databases

Question 1

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

Answer 1

D

Question 2

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

A)security
B)reliability
C)sharing
D)data integrity

Answer 2

B

Question 3

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

A)hierarchical
B)network
C)object-oriented
D)multidimensional

Answer 3

C

Question 4

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 5

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 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

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 8

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 9

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

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

Question 10

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

A)data administration
B)DBMS engine
C)data definition
D)application generation

Question 11

A field that uniquely identifies each record.

A)ID
B)primary key
C)common
D)numeric

Question 12

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 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

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

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

Question 15

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 16

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

A)character
B)record
C)field
D)file

Question 17

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

A)relational
B)hierarchical
C)multidimensional
D)object-oriented

Question 18

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 19

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

A)character
B)attribute
C)record
D)entity

Question 20

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 21

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

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

Question 22

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.

A)analysis
B)management
C)processing
D)application

Question 23

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 24

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

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

Question 25

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

A)attribute
B)generation
C)entity
D)dictionary

Question 26

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

A)query-by-example
B)data redundancy
C)attribute analysis
D)data definition

Question 27

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

A)CSi
B)ProQuest Dialog
C)Dow Jones Factiva
D)LexisNexis

Question 28

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

A)relational
B)object-oriented
C)multidimensional
D)hierarchical

Question 29

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

A)hierarchical
B)multidimensional
C)object-oriented
D)relational

Question 30

A(n)________ is a group of related characters.

A)record
B)field
C)entity
D)attribute

Question 31

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

A)strings
B)pointers
C)links
D)connectors

Question 32

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

A)application generation
B)data manipulation
C)attribute analysis
D)data administration

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

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

A)record
B)character
C)attribute
D)entity

Question 35

The most basic logical element of data is a ________.

A)bit
B)word
C)binary
D)character

Question 36

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

A)entity
B)field
C)table
D)attribute

Question 37

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 38

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

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

Question 39

________ processing is also known as online processing.

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

Question 40

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 41

Data consists of only numbers,letters,and symbols.

Question 42

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

Question 43

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

A)characters
B)methods
C)networks
D)entities

Question 44

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

Question 45

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

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

Question 46

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

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

Question 47

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

Question 48

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

Question 49

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

A)multidimensional
B)relational
C)hierarchical
D)object-oriented

Question 50

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

Question 51

Data redundancy can occur due to lack of data integrity.

Question 52

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

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

Question 53

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

Question 54

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

Question 55

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

A)multidimensional
B)object-oriented
C)network
D)relational

Question 56

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

A)network
B)hierarchical
C)object-oriented
D)relational

Question 57

A hierarchical database uses many-to-many relationships.

Question 58

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

Question 59

A record is a collection of related tables.

Question 60

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

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

Question 61

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

Question 62

Individual databases are the foundation of management information systems.

Question 63

What are the advantages of having databases?

Question 64

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

Question 65

Explain commercial databases and provide examples.

Question 66

Relational database tables require a common data item.

Question 67

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

Question 68

Compare and contrast the physical and logical views of data.

Question 69

How does a relational database differ from a hierarchical database?

Question 70

Describe the structure and functionality of a hierarchical database.

Question 71

Explain the components of data organization.

Question 72

List and describe the five basic DBMS subsystems.

Question 73

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

Question 74

Describe the workings of an object-oriented database.

Question 75

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

Question 76

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

Question 77

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

Question 78

Differentiate between the individual database and the company database.