CIS 3050-CH1

The three-schema approach includes which of the following schemas? A) Internal B) Logical C) Cross-functional D) Dissecting

A) Internal

Which of the following is NOT an advantage of database systems? A) Redundant data B) Program-data independence C) Better data quality D) Reduced program maintenance

A) Redundant data

In a file processing environment, descriptions for data and the logic for accessing the data are built into: A) application programs. B) database descriptors. C) fields. D) records.

A) application programs.

Specifying how data from a logical schema are stored in secondary memory is part of the: A) design B) maintenance C) analysis D) implementation

A) design

Program-data dependence is caused by: A) file descriptions being stored in each database application. B) data descriptions being stored on a server. C) data descriptions being written into programming code. D) data cohabiting with programs.

A) file descriptions being stored in each database application.

A database is an organized collection of ________ related data. A) logically B) physically C) loosely D) badly

A) logically

A major difference between data warehouses and transactional systems as compared to big data is: A) the data is unstructured in big data systems. B) the size of the CPU used. C) the programming required to access data. D) all of the above.

A) the data is unstructured in big data systems.

The period that can be considered a "proof of concept" time was the: A) 1950s B) 1960s C) 1970s. D) 1990s.

B) 1960s

E. F. Codd developed the relational model in the: A) 1960s. B) 1970s. C) 1980s. D) 1990s.

B) 1970s.

________ are established between entities in a well-structured database so that the desired information can be retrieved. A) Entities B) Relationships C) Lines D) Ties

B) Relationships

________ is a tool even non-programmers can use to access information from a database. A) ODBC B) Structured query language C) ASP D) Data manipulation query language

B) Structured query language

The traditional methodology used to develop, maintain, and replace information systems is called the: A) Enterprise Resource Model. B) Systems Development Life Cycle. C) Unified Model. D) Systems Deployment Life Cycle.

B) Systems Development Life Cycle.

A rule that CANNOT be violated by database users is called a: A) password. B) constraint. C) program. D) view.

B) constraint.

A knowledge base of information or facts about an enterprise is called a(n): A) enterprise information system. B) repository. C) systems information unit. D) database process.

B) repository.

Determining the structure of data and the relationships between data elements either right before or at the time of use of the data is called: A) tables on write. B) schema on write. C) on demand paging. D) caching.

B) schema on write.

A departmental multi-tiered client/server database is stored on a central device called a: A) client. B) server. C) remote PC. D) network.

B) server.

Because applications are often developed independently in file processing systems: A) the data is always non-redundant. B) unplanned duplicate data files are the rule rather than the exception. C) data can always be shared with others. D) there is a large volume of file I/O.

B) unplanned duplicate data files are the rule rather than the exception.

Languages, menus, and other facilities by which users interact with the database are collectively called an: A) client. B) user interface C) icon D) development environment

B) user interface

Which of the following is software used to create, maintain, and provide controlled access to databases? A) Network operating system B) User view C) Database management system (DBMS) D) Attribute

C) Database management system (DBMS)

Which of the following is NOT a cost and/or risk of the database approach? A) Specialized personnel B) Cost of conversion C) Improved responsiveness D) Organizational conflict

C) Improved responsiveness

An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called: A) CASE. B) CAD. C) RAD. D) MST.

C) RAD.

Which of the following is NOT an objective that drove the development and evolution of database technology? A) The need to provide greater independence between programs and data. B) The desire to manage increasing complex data types and structures. C) The desire to require programmers to write all file handling functionality. D) The need to provide ever more powerful platforms for decision support applications.

C) The desire to require programmers to write all file handling functionality.

A user view is: A) what a user sees when he or she looks out the window. B) a table or set of tables. C) a logical description of some portion of the database. D) a procedure stored on the server.

C) a logical description of some portion of the database.

The SDLC phase in which every data attribute is defined, every category of data is listed, and every business relationship between data entities is defined is called the ______ phase. A) planning B) design C) analysis D) implementation

C) analysis

The SDLC phase in which the detailed conceptual data model is created is the ________ phase. A) planning B) design C) analysis D) implementation

C) analysis

Database management involves all of the following EXCEPT: A) collecting data. B) organizing data. C) design web pages. D) managing data.

C) design web pages.

Legacy systems often contain data of ________ quality and are generally hosted on ________. A) poor; personal computers B) excellent; mainframes C) poor; mainframes D) excellent; workgroup computers

C) poor; mainframes

One of the most popular RAD methods is: A) automated design. B) structured walkthrough. C) prototyping. D) crafting.

C) prototyping.

Relational databases establish the relationships between entities by means of common fields included in a file called a(n): A) entity. B) relationship. C) relation. D) association.

C) relation.

A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n): A) index. B) data warehouse. C) repository. D) database management system.

C) repository.

____________ specify computer systems requirements A) programmers B) users C) system analysts D) database analysts

C) system analysts

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis. A) enterprise view B) reporting document C) user view D) user snapshot

C) user view

Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance. A) 40 percent B) 25 percent C) 60 percent D) 80 percent

D) 80 percent

Which organizational function should set database standards? A) Management B) Application development C) Technical services D) Database Administration

D) Database Administration

________ do NOT concentrate on determining the requirements for the database component of an information system. A) Database analysts B) Systems analysts C) Programmers D) End Users

D) End Users

The need for consensus on data definitions is an example of which type of risk in the database environment? A) Specialized personnel needs B) Organizational conflict C) Conversion costs D) Legacy systems

D) Legacy systems

A graphical system used to capture the nature and relationships among data is called a(n): A) XML data model. B) hypertext graphic. C) relational database. D) data model.

D) data model.

Database development begins with ________, which establishes the range and general contents of organizational databases. A) database design B) cross-functional analysis C) departmental data modeling D) enterprise data modeling

D) enterprise data modeling

A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n): A) relationship. B) object. C) attribute. D) entity.

D) entity.

The most common source of database failures in organizations is: A) lack of planning. B) inadequate budget. C) inadequate hardware. D) failure to implement a strong database administration function.

D) failure to implement a strong database administration function.

The SDLC phase in which database processing programs are created is the ________ phase. A) planning B) design C) analysis D) implementation

D) implementation

Metatdata typically describes all of the following EXCEPT: A) data definitions. B) length. C) allowable values. D) location on disk.

D) location on disk.

Data that describe the properties of other data are: A) relationships. B) logical. C) physical. D) metadata.

D) metadata.

According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored more than: A) 1 terabyte of data. B) 3 gigabytes of data. C) at least 100 petabytes of data. D) more than 7 billion exabytes of data.

D) more than 7 billion exabytes of data.

All of the following are primary purposes of a database management system (DBMS) EXCEPT: A) creating data. B) updating data. C) storing data. D) providing an integrated development environment.

D) providing an integrated development environment.

With the database approach, data descriptions are stored in a central location known as a: A) server. B) mainframe. C) PC. D) repository.

D) repository.