Chapter 1

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

78) A database designed using spreadsheets from the Sales department is a database being designed ________. A) from existing data B) as a new systems development project C) as a redesign of an existing database D) as a NoSQL database

A AACSB: Information Technology Difficulty: Moderate LO: To define and understand database design from existing data Classification: Application

81) Database professionals use ________ as specific data sources for studies and analyses. A) data marts B) normalization C) data models D) entity-relationship data modeling

A AACSB: Information Technology Difficulty: Moderate LO: To define and understand database design from existing data Classification: Concept

59) A sales contact manager used by a salesperson is an example of a(n) ________. A) single-user database application B) multiuser database application C) e-commerce database application D) data mining application

A AACSB: Information Technology Difficulty: Moderate LO: To survey some important and interesting database applications Classification: Concept

85) The predecessors of database processing were ________. A) file managers B) hierarchical models C) network models D) relational data models

A AACSB: Information Technology Difficulty: Moderate LO: To understand the history and development of database processing Classification: Concept

56) The purpose of a database is to ________. A) help people keep track of things B) store data in tables C) create tables of rows and columns D) maintain data on different things in different tables

A AACSB: Information Technology Difficulty: Moderate LO: To understand the nature and characteristics of databases Classification: Concept

95) Why do we say a database is self-describing and why is this an advantage?

A database is considered self-describing because it contains a description of its own structure within the database itself. This description is called the metadata, and it is stored in specialized tables in relational databases. The advantage is that the database is self-documenting, and that a knowledgeable user or a database designer can easily access the metadata. All DBMS vendors provide tools to access the metadata within their products. AACSB: Information Technology Difficulty: Moderate LO: To define the term metadata and provide examples of metadata Classification: Concept

98) What are referential integrity constraints? Give an example.

A referential integrity constraint is a rule that restricts certain actions on the database data. A referential integrity constraint is used to ensure that the values in a field in one table have matching tables in a corresponding field in another table. These constraints are enforced by the DBMS, which will not allow changes to the values of the database that would result in violations of this rule. For example, a database has an EMPLOYEE table and a VEHICLE table that are used to store data on employees and the vehicles that they are assigned to drive. The EMPLOYEE table has a column called EmployeeID that is used to distinguish one employee record from another. The VEHICLE table also has an EmployeeID column that is used to associate a vehicle with the appropriate employee. A referential integrity constraint could be used to prevent a vehicle from being assigned to an employee with an EmployeeID that does not appear in the EMPLOYEE table by requiring that all values in EmployeeID in the VEHICLE table have a matching value in EmployeeID in the EMPLOYEE table. AACSB: Information Technology Difficulty: Difficult LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Application

70) Hypertext Transport Protocol (HTTP) is a technology used to ________. A) connect servers to a client in a Client-Server architecture B) connect to web pages over the Internet C) connect applications to a DBMS D) connect hardware devices to a computer system

Answer: B AACSB: Difficulty: Moderate LO: To understand the history and development of database processing Classification:

79) A(n) _______________ is used by a senior manager to extract, summarize, and consolidate operational databases. A) data mining application B) digital dashboard C) e-commerce site application D) customer relationship management application

Answer: B AACSB: Information Technology Difficulty: Moderate LO: To survey some important and interesting database applications Classification: Concept

63) A program whose job is to create, process and administer databases is called a ________. A) database modeling system B) database management system C) data business model system D) relational model manager

B AACSB: Information Technology Difficulty: Easy LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept

74) A database consists of integrated tables, which store ________. A) reports B) data and relationships among the data C) forms D) Both A and C are correct

B AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept

82) Database professionals use a set of principles called ________ to guide and assess database design. A) database extraction B) normalization C) data models D) entity-relationship data modeling

B AACSB: Information Technology Difficulty: Moderate LO: To define and understand database design from existing data Classification: Concept

67) Which of the following statements is not true for an enterprise-class database system? A) The database application(s) interact(s) with the DBMS. B) The database application(s) directly access(es) the database data. C) The DBMS accesses the database data. D) The application generates SQL statements.

B AACSB: Information Technology Difficulty: Moderate LO: To describe the components of an enterprise-class database system and explain the functions they perform Classification: Application

68) Which of the following database systems is not enterprise-class? A) Microsoft SQL Server B) Microsoft Access C) Oracle Database D) IBM DB2

B AACSB: Information Technology Difficulty: Moderate LO: To describe the components of an enterprise-class database system and explain the functions they perform Classification: Concept

69) In an enterprise-class database system, reports are created by ________. A) the user B) the database application C) the database management system (DBMS) D) the database

B AACSB: Information Technology Difficulty: Moderate LO: To describe the components of an enterprise-class database system and explain the functions they perform Classification: Concept

60) A Customer Resource Management (CRM) system is an example of a(n) ________. A) single-user database application B) multiuser database application C) e-commerce database application D) digital dashboard

B AACSB: Information Technology Difficulty: Moderate LO: To survey some important and interesting database applications Classification: Concept

87) Modern microcomputer personal DBMS products ________. A) are supplied by several well-established manufacturers B) were essentially made obsolete by Microsoft Access C) have poor response time D) are not true DBMS products

B AACSB: Information Technology Difficulty: Moderate LO: To understand the history and development of database processing Classification: Concept

90) For database development, a challenge to the relational model and the use of SQL is known as ________. A) the Web services movement B) the NoSQL movement C) the SOAP movement D) the XML movement

B AACSB: Information Technology Difficulty: Moderate LO: To understand the history and development of database processing Classification: Concept

75) Which of the following statements is not true for primary keys in a relational database system? A) They can be used to create relationships between tables. B) They must contain numeric data. C) They uniquely identify a row in a table. D) They can be part of relational integrity constraints.

B AACSB: Information Technology Difficulty: Moderate LO: To understand the nature and characteristics of databases Classification: Concept

73) A database is considered self-describing because ________. A) all the users' data is in one place B) it reduces data duplication C) it contains a description of its own structure D) it contains a listing of all the programs that use it

C AACSB: Information Technology Difficulty: Easy LO: To define the term database and describe what is contained within the database Classification: Concept

61) An online drugstore such as Drugstore.com is an example of a(n) ________. A) single-user database application B) multiuser database application C) e-commerce database application D) enterprise resource planning system

C AACSB: Information Technology Difficulty: Easy LO: To survey some important and interesting database applications Classification: Concept

62) The industry standard supported by all major DBMSs that allows tables to be joined together is called ________. A) Sequential Query Language (SQL) B) Structured Question Language (SQL) C) Structured Query Language (SQL) D) Standard Question Language (SQL)

C AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept

80) A database designed to combine two databases used by the Sales department is a database being designed ________. A) from existing data B) as a new systems development project C) as a redesign of an existing database D) Both A and B are correct

C AACSB: Information Technology Difficulty: Moderate LO: To define and understand database design in database redesign Classification: Application

76) This database component is used to maintain database accuracy and enforce data constraints. A) tables B) metadata C) triggers D) stored procedures

C AACSB: Information Technology Difficulty: Moderate LO: To define the term database and describe what is contained within the database Classification: Concept

86) Which statement is not true about the relational model? A) It was first proposed in 1970. B) It was developed by E. F. Codd. C) It was developed at Oracle. D) It resulted in the DBMS product DB2.

C AACSB: Information Technology Difficulty: Moderate LO: To understand the history and development of database processing Classification: Concept

66) Which of the following is not an XML Web service standard? A) SOAP B) WSDL C) Ethernet D) UDDI

C AACSB: Information Technology Difficulty: Moderate LO: To understand the importance of databases in Internet Web applications and smartphone apps Classification: Concept

89) For database development, the most important Web-related technology to emerge in recent years is ________. A) FTP B) HTTP C) XML D) OODBMS

C AACSB: Information Technology Difficulty: Moderate LO: To understand the importance of databases in Internet Web applications and smartphone apps Classification: Concept

84) A very popular development technique used by database professionals to adopt a database design to a new or changing requirement is known as ________. A) normalization B) data models C) entity-relationship data modeling D) database migration

D AACSB: Information Technology Difficulty: Difficult LO: To define and understand database design in database redesign Classification: Concept

72) In database systems, the DBMS enforces rules about which user can perform which action when. The rules are known as ________. A) referential integrity constraints B) data modification control C) data reading control D) concurrency control

D AACSB: Information Technology Difficulty: Difficult LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept

58) Which of the following statements is true about Web 2.0? A) It requires the Android Operating System. B) It allows users to add content to Web sites. C) Twitter and Facebook are examples of Web 2.0 sites. D) Both B and C are correct

D AACSB: Information Technology Difficulty: Easy LO: To understand the importance of databases in Internet Web applications and smartphone apps Classification: Concept

83) A very popular development technique used by database professionals for database design is known as ________. A) database extraction B) normalization C) data models D) entity-relationship data modeling

D AACSB: Information Technology Difficulty: Moderate LO: To define and understand database design from existing data Classification: Concept

77) This database component can be used as part of applications and for administration tasks. A) tables B) metadata C) triggers D) stored procedures

D AACSB: Information Technology Difficulty: Moderate LO: To define the term database and describe what is contained within the database Classification: Concept

71) In database systems, the DBMS enforces rules about which data can be written in certain columns. These rules are known as ________. A) data insertion control B) data modification control C) concurrency control D) referential integrity constraints

D AACSB: Information Technology Difficulty: Moderate LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept

64) Microsoft Access includes ________. A) a DBMS B) an application generator C) a Web server D) Both A and B are correct

D AACSB: Information Technology Difficulty: Moderate LO: To describe the components of a Microsoft Access database system and explain the functions they perform Classification: Application

65) Microsoft Access may use which of the following DBMS engines? A) ADE B) SQL Server C) Oracle D) Both A and B are correct

D AACSB: Information Technology Difficulty: Moderate LO: To describe the components of a Microsoft Access database system and explain the functions they perform Classification: Concept

88) Business organizations have resisted adopting object-oriented database management systems because ________. A) the cost of purchasing OODBMS packages is prohibitively high B) the cost of converting data from relational databases to OODBMSs is too high C) most large organizations have older applications that are not based on object oriented programming D) Both B and C are correct

D AACSB: Information Technology Difficulty: Moderate LO: To understand the history and development of database processing Classification: Concept

57) A database stores ________. A) data B) relationships C) applications D) Both A and B are correct

D AACSB: Information Technology Difficulty: Moderate LO: To understand the nature and characteristics of databases Classification: Application

99) What are the three types of database design situations?

Database designs can be based on (1) existing data, (2) new systems development and (3) database redesign. Database designs from existing data may be based on data in spreadsheets or other data tables, or on data extracted from other databases. New systems development gathers user requirements for needed applications and designs a database to meet those requirements. Database redesign may be needed to migrate existing databases to a newer DBMS, or to integrate multiple existing databases. AACSB: Information Technology Difficulty: Moderate LO: To define and understand database design from existing data Classification: Concept

10) The largest databases in e-commerce are the order entry databases.

FALSE AACSB: Information Technology Difficulty: Difficult LO: To survey some important and interesting database applications Classification: Concept

46) The CODASYL DBTG model structured data relationships as a tree structure.

FALSE AACSB: Information Technology Difficulty: Difficult LO: To understand the history and development of database processing Classification: Concept

49) dBase was the first PC-based DBMS to implement true relational algebra on a PC.

FALSE AACSB: Information Technology Difficulty: Difficult LO: To understand the history and development of database processing Classification: Concept

41) Database design is important, and fortunately it is simple to do.

FALSE AACSB: Information Technology Difficulty: Easy LO: To define and understand database design from existing data Classification: Concept

43) A database design is rarely a redesign of an existing database.

FALSE AACSB: Information Technology Difficulty: Easy LO: To define and understand database design in database redesign Classification: Concept

26) Microsoft Access is just a DBMS.

FALSE AACSB: Information Technology Difficulty: Easy LO: To describe the components of a Microsoft Access database system and explain the functions they perform Classification: Concept

16) Applications usually write data directly to the database.

FALSE AACSB: Information Technology Difficulty: Easy LO: To gain a general understanding of tables and relationships Classification: Concept

12) A surrogate key is a key typically used in place of a foreign key.

FALSE AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept

24) A database is a self-describing collection of non-integrated tables.

FALSE AACSB: Information Technology Difficulty: Moderate LO: To define the term database and describe what is contained within the database Classification: Concept

38) A database is called self-describing because it reduces data duplication.

FALSE AACSB: Information Technology Difficulty: Moderate LO: To define the term metadata and provide examples of metadata Classification: Application

31) In an enterprise-class database system, a database application accesses the database data.

FALSE AACSB: Information Technology Difficulty: Moderate LO: To describe the components of an enterprise-class database system and explain the functions they perform Classification: Application

32) In an enterprise-class database system, business users interact directly with the DBMS, which directly accesses the database data.

FALSE AACSB: Information Technology Difficulty: Moderate LO: To describe the components of an enterprise-class database system and explain the functions they perform Classification: Concept

17) Sequenced Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products.

FALSE AACSB: Information Technology Difficulty: Moderate LO: To gain a general understanding of tables and relationships Classification: Concept

8) Enterprise Resource Planning (ERP) is an example of a data mining application.

FALSE AACSB: Information Technology Difficulty: Moderate LO: To survey some important and interesting database applications Classification: Concept

34) According to the text, IBM's DB2 is the DBMS with the most power and features.

FALSE AACSB: Information Technology Difficulty: Moderate LO: To understand the history and development of database processing Classification: Concept

50) Paradox is the only major survivor of the "bloodbath of PC DBMS products."

FALSE AACSB: Information Technology Difficulty: Moderate LO: To understand the history and development of database processing Classification: Concept

51) Business organizations have resisted adopting object-oriented database systems because the cost of purchasing OODBMS packages is prohibitively high.

FALSE AACSB: Information Technology Difficulty: Moderate LO: To understand the history and development of database processing Classification: Concept

4) In every database, not just the databases discussed in this book, table names are capitalized.

FALSE AACSB: Information Technology Difficulty: Moderate LO: To understand the nature and characteristics of databases Classification: Concept

36) According to the text, Microsoft's SQL Server is the easiest DBMS to use.

FALSE Difficulty: Moderate LO: To understand the history and development of database processing Classification: Concept

96) What is metadata and how does it relate to the definition of a database?

Metadata is data about the structure of the database itself. This includes data about the names of all tables and columns in the database, the data type of each column in each table, and the properties of the tables and the columns, etc. Metadata accounts for the self-describing aspect of the definition of a database as a "self-describing collection of integrated tables." AACSB: Information Technology Difficulty: Moderate LO: To define the term metadata and provide examples of metadata Classification: Concept

18) In database systems, indexes are held in the database.

TRUE AACSB: Information Technology Difficulty: Difficult LO: To define the term database and describe what is contained within the database Classification: Concept

45) Data Language/I (DL/I) structured data relationships as a tree structure.

TRUE AACSB: Information Technology Difficulty: Difficult LO: To understand the history and development of database processing Classification: Concept

42) A database design may be part of a new systems development project.

TRUE AACSB: Information Technology Difficulty: Easy LO: To define and understand database design as new systems development Classification: Application

23) Referential integrity constraints are rules about what data values are allowed in certain columns.

TRUE AACSB: Information Technology Difficulty: Easy LO: To define the term database and describe what is contained within the database Classification: Concept

19) A database management system (DBMS) creates, processes and administers databases.

TRUE AACSB: Information Technology Difficulty: Easy LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept

20) The database management system (DBMS) is responsible for inserting, modifying, reading, and deleting data.

TRUE AACSB: Information Technology Difficulty: Easy LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept

22) The database management system (DBMS) is responsible for enforcing referential integrity constraints.

TRUE AACSB: Information Technology Difficulty: Easy LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept

39) The description of a database's structure that is stored within the database itself is called the metadata.

TRUE AACSB: Information Technology Difficulty: Easy LO: To define the term metadata and provide examples of metadata Classification: Concept

27) Microsoft Access is a low-end product intended for individuals and small workgroups.

TRUE AACSB: Information Technology Difficulty: Easy LO: To describe the components of a Microsoft Access database system and explain the functions they perform Classification: Concept

28) The current DBMS engine in Microsoft Access is called ADE.

TRUE AACSB: Information Technology Difficulty: Easy LO: To describe the components of a Microsoft Access database system and explain the functions they perform Classification: Concept

15) Applications are computer programs used directly by users.

TRUE AACSB: Information Technology Difficulty: Easy LO: To gain a general understanding of tables and relationships Classification: Concept

5) A database shows data in tables as well as the relationships among the rows in those tables.

TRUE AACSB: Information Technology Difficulty: Easy LO: To gain a general understanding of tables and relationships Classification: Concept

47) The relational model was first proposed in 1970 by E. F. Codd at IBM.

TRUE AACSB: Information Technology Difficulty: Easy LO: To understand the history and development of database processing Classification: Concept

52) Bill Gates has said that "XML is the lingua-franca of the Internet Age."

TRUE AACSB: Information Technology Difficulty: Easy LO: To understand the history and development of database processing Classification: Concept

1) The purpose of a database is to help people keep track of things.