Deck 5: It Architectures

Question 1

A data model serves as a logical framework on which to base the physical design of a database.

Answer 1

True

Question 2

The multidimensional database structure is considered one of the key technologies of a new generation of Web-based applications.

Answer 2

False

Question 3

Multidimensional databases have become the least popular structure for analytical databases that support online analytical process (OLAP)applications,in which fast answers to complex queries are expected.

Answer 3

False

Question 4

An active data dictionary will prevent a data entry program from using a nonstandard definition of a customer record.

Question 5

Databases contain data elements that describe both entities and the relationships among entities.

Question 6

A petabyte equals about one thousand times the printed content of the Library of Congress.

Question 7

When independent of any other files related to it,a single table is referred to as a compressed file.

Question 8

Relational databases are more difficult for programmers to work with and more difficult to maintain than the hierarchical and network models.

Question 9

The network model can easily handle ad hoc requests for information,whereas the hierarchical model cannot.

Question 10

A master file is an integrated collection of logically related data elements.

Question 11

Files are frequently classified by the application for which they are primarily used,such as a payroll file or an inventory file.

Question 12

Database management packages based on the relational model can link data elements from various tables to provide information to users.

Question 13

Google recently made its desktop and paid-search products available to external developers.

Question 14

All of the relationships between the data elements in a relationally organized database need to be specified when the database is created.

Question 15

A major benefit of multidimensional databases is that they are a compact and easy-to-understand way to visualize and manipulate data elements that have many interrelationships.

Question 16

A database with a network data structure can easily handle a many-to-many data relationship,whereas a hierarchical model can not.

Question 17

Large organizations usually place control of enterprise-wide database development in the hands of database administrators (DBAs)and other database specialists.

Question 18

Variable-length records contain a variable number of fields with fixed field lengths.

Question 19

The rise of open-source software has challenged the notion that those who invest in software development hold onto it for competitive advantage.

Question 20

The project operation is used to create a subset of the columns contained in the temporary tables created by the select and join operations.

Question 21

A data field represents a(n)_______________ of some entity.

A)character
B)bit
C)attribute
D)byte

Question 22

In file processing systems,it was easy for data elements,such as stock numbers and customer addresses,to be defined differently by different end users and applications.

Question 23

DBMS packages play a major role in application development.

Question 24

One drawback to the database duplication process is that no changes can ever be made to any database other than the master.Otherwise,local changes will be overwritten during the duplication process.

Question 25

A large database system is often distributed into smaller databases based on some logical relationship between the data and the location of the databases.

Question 26

In file processing systems,application programs typically contain references to the specific format of the stored data.

Question 27

Astronomers use computers to calculate the size,speed,and trajectory of objects in space to determine if they pose a threat to the earth.

Question 28

Amazon lets others use and tinker with their platform,then pays the user for their research.

Question 29

A _______________ consists of a grouping of related characters.

A)character
B)field
C)attribute
D)byte

Question 30

Having data in independent files makes it easier to provide end users with information for ad hoc requests.

Question 31

Boolean logic was developed during the latter part of the 1900s.

Question 32

In a distributed database system,each location gains control of its local data,but loses access to data in other locations.

Question 33

In all information systems,data resources must be organized and structured in some logical manner,so that they can be:

A)Easily accessed
B)Processed efficiently
C)Retrieved quickly
D)All of the choices are correct.

Question 34

From a logical point of view,a _______________ is the smallest data element that can be observed and manipulated.

A)character
B)bit
C)attribute
D)byte

Question 35

Distributed databases require fewer resources when it comes to computing power and bandwidth.

Question 36

The Internet is nothing more than the world's largest database.

Question 37

Distributed databases can reside on network servers on the World Wide Web,on corporate intranets,or on corporate extranets.

Question 38

A _______________ represents a collection of attributes that describe a single instance of an entity.

A)character
B)bit
C)byte
D)record

Question 39

In a traditional file processing approach,each business application is designed to use one or more specialized data files containing only specific types of data records.

Question 40

Sellers who use eBay's API become at least 50% more productive than those who use the Web site itself.

Question 41

_______________ databases enable an end user to receive information easily in response to ad hoc requests.

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

Question 42

The _______________ model is the most widely used database structure today.

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

Question 43

Which database model allows many-to-many relationships among records so that a data element can be accessed by following one of several paths?

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

Question 44

Which database structure works effectively with complex data types,such as video clips,audio segments,and other subsets of Web pages,and is considered one of the key technologies of Web-based applications?

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

Question 45

Using a relational database,a user can temporarily combine two or more tables so that he/she can see relevant data in a form that looks like it is in one big table.This is the _______________ operation.

A)join
B)link
C)merge
D)select

Question 46

A group of related records is a _______________.

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

Question 47

The data stored in a database are _______________ the application programs using them.

A)an integral part of
B)dependent on
C)related to
D)independent of

Question 48

The object-oriented database model supports _______________.That is,new objects can be automatically created by replicating some or all of the characteristics of one or more parent objects.

A)inheritance
B)morphing
C)duplication
D)cloning

Question 49

Early mainframe DBMS packages used the _______________ structure,in which all records are dependent and arranged in multilevel structures,consisting of one root record and any number of subordinate levels.

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

Question 50

Software from AssociatesShop.com has allowed approximately _______________ Amazon associates to create customized storefronts that link back to Amazon.

A)5,000
B)25,000
C)75,000
D)900,000

Question 51

_______________ is the most commonly used database application for the PC.

A)Oracle 10g
B)Microsoft Access
C)DB2
D)SQL Server

Question 52

In a relational database,a row represents _______________ and a column represents _______________.

A)a record; a field
B)a table; a relation
C)a data element; a picture element
D)an attribute; an entity

Question 53

In the relational database model,data are viewed as _______________.

A)DOS-like tree structures,also called branches
B)multidimensional combinations of data and their programs,also called encapsulations
C)three-dimensional tables,also called relatives
D)two-dimensional tables,also called relations

Question 54

According to the text,YouTube is an excellent example of _______________.

A)a social networking Web site
B)competition for Facebook
C)how simple it is to use and enjoy a database
D)an object-oriented database

Question 55

A _______________ is an integrated collection of logically related data elements.

A)database
B)record
C)data warehouse
D)file

Question 56

A record represents a collection of _______________ that describe an entity.

A)characters
B)fields
C)files
D)attributes

Question 57

The major limitation of the relational model is _______________.

A)it is so complex that most database programmers cannot understand it
B)it makes too many errors when processing business transactions
C)it takes up too much space on storage devices
D)it cannot process large amounts of transactions as quickly and efficiently as the hierarchical and network models

Question 58

According to the Real World Case,a well-run data center with reduced complexity _______________.

A)makes your firm a target for a predatory merger
B)actually makes a merger more difficult
C)makes a merger easier
D)is what Amazon.com is looking for in prospective associates

Question 59

In a _______________ database structure,all of the relationships among records are one-to-many,because each data element is related to only one element above it.

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

Question 60

According to the text,just about all the data we use are stored _______________.

A)online
B)in some kind of database
C)inefficiently
D)on YouTube

Question 61

Database administrators and database design analysts work with end users and systems analysts to do all of the following except:

A)Model business processes and the data they require
B)Determine what data definitions should be included in the database
C)Determine what structure or relationships should exist among the data elements
D)Enter live data into the system until it has proven to be reliable

Question 62

Object technology allows designers to do all of the following except:

A)Develop product designs
B)Replicate product designs and then modify them to create new product designs
C)Save designs as objects in an object-oriented database
D)Substantially reduce the file size of designs

Question 63

ERD stands for _______________ which is used to _______________.

A)Encapsulated-Relation Diagram; model data before placing it in advanced databases
B)Entity Relationship Diagram; model the sources and destinations of various data in the business processes
C)Entity Relationship Diagram; model the relationships between entities in the business processes
D)EnRon Diagram; model processes that lead to disasters in business associations

Question 64

All of the following contribute to problems when using a file management approach except:

A)Data redundancy
B)Integration of data
C)Data independence
D)Lack of data integrity

Question 65

The data dictionary,or repository,contains _______________,which is _______________.

A)the database model; the model of the business processes
B)metadata; data about the data
C)data structures; access methods for the data
D)encapsulated data; the combined data and programs that work on the data

Question 66

According to the text,most data warehouses will run _______________ in a column format.

A)20 times faster
B)50 times faster
C)50 times slower
D)None of the choices are correct.

Question 67

The physical design stage of database development:

A)Develops a model of business processes
B)Translates conceptual models into the data models
C)Determines the data storage structures and access methods
D)Defines the information needs of end users in a business process

Question 68

Operational databases store the detailed data needed to support the business processes and operations of a company.They are also called _______________.

A)subject area databases
B)transaction databases
C)production databases
D)All of the choices are correct.

Question 69

A data warehouse contains data that have been processed in all the following ways except:

A)Separated
B)Cleaned
C)Transformed
D)Cataloged

Question 70

A central source of data that have been cleaned,transformed,and cataloged so that they can be used for business analysis,market research,and decision support is called a _______________.

A)data mart
B)data warehouse
C)transaction processing mart
D)data repository

Question 71

Which of the following is true of data marts?

A)They hold data from many different data warehouses.
B)They are a subset of a data warehouse.
C)They focus on many generalized aspects of a company.
D)None of the choices are correct.

Question 72

The _______________ stage of database development translates the conceptual models into the data model of a DBMS.

A)data planning
B)requirements specification
C)conceptual design
D)logical design

Question 73

What type of database are employees using when they access online data banks,whether those data banks are free or paid for through subscriptions?

A)Common databases
B)Distributed databases
C)External databases
D)Local databases

Question 74

In large organizations,a database is usually controlled by a DBA,which stands for:

A)Database Administrator.
B)Database Analyst.
C)Definition-Based Algorithm.
D)Direct Biased Agent.

Question 75

Which of the following is true of data in a data warehouse?

A)Data in operational databases is ever changing; data in data warehouses is static
B)Data in operational databases is static; data in data warehouses is ever changing
C)Data in operational databases can be cataloged; data in data warehouses cannot
D)None of the choices are correct.

Question 76

Database management involves the use of database management software to control how databases are _______________.

A)created
B)interrogated
C)maintained
D)All of the choices are correct.

Question 77

The primary challenge of a distributed database is:

A)Data accuracy
B)Data transmission speed
C)Storage costs
D)Data security

Question 78

According to one database pioneer,the future development of databases and data warehouses will depend on _______________.

A)rows
B)columns
C)transaction
D)All of the choices are correct.

Question 79

Which of the following is a legitimate use for data mining?

A)Performing "market-basket analysis" to identify new product bundles
B)Profiling customers
C)Finding the root cause of a quality or manufacturing problem
D)All of the choices are correct.

Question 80

Which of the following statements concerning the replication and duplication process for updating distributed databases is correct?

A)The two terms are interchangeable because the processes work the same way
B)Duplication is the more complicated process because it has to identify one database as a master and prevent changes being made to any database other than the master
C)Replication is the more complicated process because it must find changes in each distributed database and make appropriate changes to make each database identical
D)None of the choices is correct.