12
B) database management system
C) data business model system
D) relational model manager
64) Microsoft Access includes ________.
A) a DBMS
B) an application generator
C) a Web server
D) Both A and B are correct
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
66) Which of the following is not an XML Web service standard?
A) SOAP
B) WSDL
C) Ethernet
D) UDDI
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.
68) Which of the following database systems is not enterprise-class?
A) Microsoft SQL Server
B) Microsoft Access
C) Oracle Database
D) IBM DB2
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
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
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
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
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
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
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.
76) This database component is used to maintain database accuracy and enforce data constraints.
A) tables
B) metadata
C) triggers
D) stored procedures
77) This database component can be used as part of applications and for administration tasks.
A) tables
B) metadata
C) triggers
D) stored procedures
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
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
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
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
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
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
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
85) The predecessors of database processing were ________.
A) file managers
B) hierarchical models
C) network models
D) relational data models
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.
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
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
89) For database development, the most important Web-related technology to emerge in recent
years is ________.
A) FTP
B) HTTP
C) XML
D) OODBMS
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
91) What is the purpose of a database, and how does the database accomplish this purpose?
92) What are the four components of a database system?
93) Briefly describe the function of an application program in a database system.
94) What components are included in a database?
95) Why do we say a database is self-describing and why is this an advantage?
96) What is metadata and how does it relate to the definition of a database?
97) Briefly describe the function of the DBMS in a database system.
98) What are referential integrity constraints? Give an example.
99) What are the three types of database design situations?
100) Briefly describe the history of database processing.