Q&A Hero

Q: What components are included in a database?

Q: Briefly describe the function of an application program in a database system.

Q: What are the four components of a database system?

Q: What is the purpose of a database, and how does the database accomplish this purpose?

Q: 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

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

Q: 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

Q: 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

Q: 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.

Q: The predecessor(s) of database processing was (were) ________. A) file managers B) hierarchical models C) network models D) the relational data model

Q: 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

Q: 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

Q: 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

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

Q: 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

Q: A database designed to implement requirements for a reporting application needed by the Sales department is a database being designed ________. A) from existing non-database data B) as a new systems development project C) as a redesign of an existing database D) Both A and B are correct

Q: 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

Q: This database component can be used as part of applications and for administration tasks. A) Tables B) Metadata C) Triggers D) Stored procedures

Q: This database component is used to maintain database accuracy and enforce data constraints. A) Tables B) Metadata C) Triggers D) Stored procedures

Q: 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.

Q: 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

Q: 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

Q: 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

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

Q: Which of the following statements is not true about client-server architecture? A) The client initiates a request. B) The server is usually a tablet or smartphone. C) The server usually runs the DBMS on it. D) Most Web applications are supported by client-server.

Q: 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

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

Q: 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.

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

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

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

Q: 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

Q: 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)

Q: 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

Q: 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

Q: 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

Q: 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

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

Q: 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

Q: Twitter and Facebook use NoSQL databases.

Q: The NoSQL movement should really be called a NoRelational movement.

Q: XML Web services allow database processing to be shared across the Internet.

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

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

Q: Paradox is the only major survivor of the "bloodbath of PC DBMS products."

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

Q: The 1977 edition of this text contained a chapter on the relational model, and that chapter was reviewed by E. F. Codd.

Q: The relational model was first proposed in 1970 by E. F. Codd at IBM.

Q: The CODASYL DBTG model structured data relationships as a tree structure.

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

Q: Each row in a database table is also known as a record.

Q: A database design is rarely a redesign of an existing database.

Q: A database design may be part of a new systems development project.

Q: Database design is important, and fortunately it is simple to do.

Q: Indexes are data structures that speed searching of database data.

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

Q: A database is called self-describing because it reduces data duplication.

Q: The DBMS ranked as having the "least power and features" in the text is Microsoft Access.

Q: The DBMS ranked as being the "easiest to use" in the text is Microsoft's SQL Server.

Q: The DBMS ranked as being the "most difficult to use" in the text is Oracle Corporation's Oracle Database.

Q: The DBMS ranked as having the "most power and features" in the text is IBM's DB2.

Q: All database applications get and put database data by sending SQL statements to the DBMS.

Q: In an Enterprise-class database system, business users interact directly with the DBMS, which directly accesses the database data.

Q: In an Enterprise-class database system, a database application accesses the database data.

Q: In an Enterprise-class database system, a database application interacts with the DBMS.

Q: In Microsoft Access, you can use ODBC to connect to SQL Server in place of the ADE database engine.

Q: The current DBMS engine in Microsoft Access is called ADE.

Q: Microsoft Access is a low-end product intended for individuals and small workgroups.

Q: Microsoft Access is just a DBMS.

Q: Integrated tables store both data and the relationships among the data.

Q: A database is a self-describing collection of non-integrated tables.

Q: Referential integrity constraints are rules about what data values are allowed in certain columns.

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

Q: The database application is responsible for concurrency control.

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

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

Q: In database systems, indexes are held in the database.

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

Q: Applications usually write data directly to the database.

Q: Applications are computer programs used directly by users.