Week_1 Database System

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

B) constraint.

15) 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.

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

B) Organizational conflict

14) ________ 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

21) ________ 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

2) Older systems that often contain data of poor quality are called ________ systems. A) controlled B) legacy C) database D) mainframe

B) legacy

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

1) One application of data warehouses is: A) shipping of information. B) order processing. C) decision support. D) file updating.

C) decision support.

8) One disadvantage of file processing systems is: A) reduced data duplication. B) program-data independence. C) limited data sharing. D) enforcement of integrity constraints.

C) limited data sharing.

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

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

4) Which of the following types of data can be stored in a database? A) Voice B) Letters C) Numbers D) All of the above

D) All of the above

20) Which organizational function should set database standards? A) Management B) Application development C) Technical services D) None of the above

D) None of the above

13) A person, place, an object , an 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.

16) 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.

[True/False] Databases were developed as the first application of computers to data processing.

False

[True/False] Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance.

False

[True/False] With the traditional file processing approach, each application shares data files, thus enabling much data sharing.

False

[True/False] File processing systems have been replaced by database systems in most critical business applications today.

True

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

B) repository.

10) 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.

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

25) 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.

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

A) file descriptors being stored in each application.

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

A) logically

7) All of the following are properties of metadata EXCEPT: A) data definitions. B) processing logic. C) rules or constraints. D) data structures.

B) processing logic.

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

19) 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.

5) Data processed in a way that increases a user's knowledge is: A) text. B) graphics C) information. D) hyperlink.

C) information.

26) Databases may be more expensive to maintain than files because of: A) the need for specialized personnel. B) the complexity of the database environment. C) backup and recovery needs. D) all of the above.

D) all of the above.

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

D) data model.

23) 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.

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

D) none of the above.

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

D) repository.

[True/False] Development starts from scratch with the traditional file processing approach because new file formats, descriptions, and file access logic must be designed for each new program.

True

[True/False] In practice, databases today may contain either data or information.

True

[True/False] Information is processed data.

True

[True/False] Many of the disadvantages of file processing systems can also be limitations of databases.

True

[True/False] Metadata are data that describe the properties of other data.

True

[True/False] Unplanned duplicate data files are the rule rather than the exception in file processing systems.

True