Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
90 Cards in this Set
- Front
- Back
1) The purpose of a database is to help people keep track of things |
Answer: TRUE
|
|
2) In a database, each table stores data about a different type of thing.
|
Answer: TRUE
|
|
3) In a database, each row in a spreadsheet has data about a particular instance.
|
Answer: FALSE
|
|
4) In every database, not just the databases discussed in this book, table names are capitalized.
|
Answer: FALSE
|
|
5) A database shows data in tables and the relationships among the rows in those tables.
|
Answer: TRUE
|
|
6) Data is recorded facts and figures; information is knowledge derived from data.
|
Answer: TRUE
|
|
7) Databases record data in such a way that they can produce information.
|
Answer: TRUE
|
|
8) Enterprise Resource Planning (ERP) is an example of a data mining application.
|
Answer: FALSE
|
|
9) Databases are a key component of e-commerce order entry, billing, shipping and customer support.
|
Answer: TRUE
|
|
10) The largest databases in e-commerce are the order entry databases.
|
Answer: FALSE
|
|
11) The e-commerce companies use Web activity databases to determine which items on a Web page are popular and successful. |
Answer: TRUE
|
|
12) Small databases typically have simple structures.
|
Answer: FALSE
|
|
13) A database system is typically defined as its four components: users, database applications, the DBMS and the databases.
|
Answer: TRUE
|
|
14) A database system as typically defined can be modified to include CODASYL.
|
Answer: FALSE
|
|
15) Applications are computer programs used directly by users.
|
Answer: TRUE
|
|
16) In a database system, applications write data to the database.
|
Answer: FALSE
|
|
17) Sequenced Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products.
|
Answer: FALSE
|
|
18) In database systems, indexes are held by the database.
|
Answer: TRUE
|
|
19) A database management system (DBMS) creates, processes and administers databases.
|
Answer: TRUE
|
|
20) The database management system (DBMS) is responsible for inserting, modifying, reading, and deleting data.
|
Answer: TRUE
|
|
21) The database application is responsible for concurrency control.
|
Answer: FALSE
|
|
22) The database management system (DBMS) is responsible for enforcing referential integrity constraints.
|
Answer: TRUE
|
|
23) Referential integrity constraints are rules about what data values are allowed in certain columns.
|
Answer: TRUE
|
|
24) A database is a self-describing collection of non-integrated tables.
|
Answer: FALSE
|
|
25) Integrated tables store both data and the relationships among the data.
|
Answer: TRUE
|
|
26) Microsoft Access is just a DBMS.
|
Answer: FALSE
|
|
27) Microsoft Access is a low-end product intended for individuals and small workgroups.
|
Answer: TRUE
|
|
28) The current DBMS engine in Microsoft Access is called ADE.
|
Answer: TRUE
|
|
29) In Microsoft Access, you can use the Oracle DBMS in place of the ADE DBMS.
|
Answer: FALSE
|
|
30) In an Enterprise-class database system, a database application interacts with the DBMS.
|
Answer: TRUE
|
|
31) In an Enterprise-class database system, a database application accesses the database data.
|
Answer: FALSE
|
|
32) In an Enterprise-class database system, business users interact directly with the DBMS, which directly accesses the database data.
|
Answer: FALSE
|
|
33) All database applications get and put database data by sending SQL statements to the DBMS.
|
Answer: TRUE
|
|
34) The DBMS ranked as having the "most power and features" in the text is IBM's DB2.
|
Answer: FALSE
|
|
35) The DBMS ranked as being the "most difficult to use" in the text is Oracle Corporation's Oracle Database.
|
Answer: TRUE
|
|
36) The DBMS ranked as being the "easiest to use" in the text is Microsoft's SQL Server.
|
Answer: FALSE
|
|
37) The DBMS ranked as having the "least power and features" in the text is Microsoft Access.
|
Answer: TRUE
|
|
38) A database is called "self-describing" because it reduces data duplication.
|
Answer: FALSE
|
|
39) The description of a database's structure that is stored within the database itself is called the "metadata."
|
Answer: TRUE
|
|
40) In a database processing system, indexes are held by the database management system (DBMS).
|
Answer: TRUE
|
|
41) Database design is important, and fortunately it is simple to do.
|
Answer: FALSE
|
|
42) A database design may be part of a new systems development project.
|
Answer: TRUE
|
|
43) A database design is rarely a redesign of an existing database.
|
Answer: FALSE
|
|
44) Information systems that stored groups of records in separate files were called file processing systems.
|
Answer: TRUE
|
|
45) Data Language/I (DL/I) structured data relationships as a tree structure.
|
Answer: TRUE
|
|
46) The CODASYL DBTG mode structured data relationships as a tree structure.
|
Answer: FALSE
|
|
47) The relational model was first proposed in 1970 by E. F. Codd at IBM.
|
Answer: TRUE
|
|
48) The 1977 edition of this text contained a chapter on the relational model, and that chapter was reviewed by E. F. Codd.
|
Answer: TRUE
|
|
49) dBase was the first PC-based DBMS to implement true relational algebra on a PC.
|
Answer: FALSE
|
|
50) Paradox is the only major survivor of the "bloodbath of PC DBMS products."
|
Answer: FALSE
|
|
51) Business organizations have resisted adopting object-oriented database systems because the cost of purchasing OODBMS packages is prohibitively high.
|
Answer: FALSE
|
|
52) Bill Gates has said that "XML is the lingua-franca of the Internet Age."
|
Answer: TRUE
|
|
53) XML Web services allow database processing to be shared across the Internet.
|
Answer: TRUE
|
|
54) The NoSQL movement should really be called a NoRelational movement.
|
Answer: TRUE
|
|
55) Twitter and Facebook use NoSQL databases.
|
Answer: TRUE
|
|
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. E) All of the above. |
Answer: A
|
|
57) A database stores:
A) data. B) relationships. C) metadata. D) A and B E) A, B, and C |
Answer: E
|
|
58) A database records:
A) facts. B) figures. C) information. D) A and B E) A, B, and C |
Answer: D
|
|
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) A or B E) Any of A, B, or C |
Answer: A
|
|
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) A or B E) Any of A, B, or C |
Answer: B
|
|
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) A or B E) Any of A, B, or C |
Answer: C
|
|
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) Relational Question Language (RQL) E) Relational Query Language (RQL) |
Answer: C
|
|
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 E) Data Business Management Service |
Answer: B
|
|
64) Microsoft Access includes:
A) a DBMS. B) an application generator. C) a Web server. D) A and B E) A, B, and C |
Answer: D
|
|
65) Microsoft Access may use which of the following DBMS engines? A) ADE B) SQL Server C) Oracle D) A and B E) A, B, and C |
Answer: D
|
|
66) Which of the following are basic components of an enterprise-class database system?
A) The user B) The database application C) The database management system (DBMS) D) The database E) All of the above |
Answer: E
|
|
67) In an enterprise-class database system, ________.
A) the database application(s) interact(s) with the DBMS B) the database application(s) access(es) the database data C) the DBMS accesses the database data D) A and B E) A and C |
Answer: E
|
|
68) In an enterprise-class database system, the database application ________.
A) creates queries B) creates forms C) creates reports D) A and B E) B and C |
Answer: E
|
|
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 E) All of the above |
Answer: B |
|
|
Answer: E
|
|
71) 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) data reading control D) concurrency control E) referential integrity constraints |
Answer: E
|
|
72) In database systems, the DBMS enforces rules about which user can perform which action when. The rules are known as ________.
A) data insertion control B) data modification control C) data reading control D) concurrency control E) referential integrity constraints |
Answer: D
|
|
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 E) All of the above |
Answer: C
|
|
74) A database consists of integrated tables, which store ________.
A) data B) relationships among the data C) forms D) A and B E) All of the above |
Answer: D
|
|
75) In database systems, the database ________.
A) holds user data B) holds metadata C) holds indexes D) holds stored procedures E) All of the above |
Answer: E
|
|
76) A database may contain ________.
A) tables B) metadata C) triggers D) stored procedures E) All of the above |
Answer: E
|
|
77) A database may be designed ________.
A) from existing data B) as a new systems development project C) as a redesign of an existing database D) A and B E) A, B, and C |
Answer: E
|
|
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) A and B E) A, B, and C |
Answer: A
|
|
79) 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) A and B E) A, B, and C |
Answer: B
|
|
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) A and B E) A, B, and C |
Answer: C
|
|
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 E) data migration |
Answer: A
|
|
82) Database professionals use a set of principles called ________ to guide and assess database design.
A) data marts B) normalization C) data models D) entity-relationship data modeling E) data migration |
Answer: B
|
|
83) A very popular development technique used by database professionals for database design is known as ________.
A) data marts B) normalization C) data models D) entity-relationship data modeling E) data migration |
Answer: D
|
|
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) data marts B) normalization C) data models D) entity-relationship data modeling E) data migration |
Answer: E
|
|
85) The predecessor(s) of database processing was (were) ________.
A) file managers B) hierarchical models C) network models D) the relational data model E) All of the above were predecessors of database processing. |
Answer: A
|
|
86) The relational model ________.
A) was first proposed in 1970 B) was developed by E. F. Codd C) was developed at IBM D) resulted in the DBMS product DB2 E) All of the above |
Answer: E
|
|
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 E) are really just programming languages with generalized file-processing capabilities |
Answer: B
|
|
88) Business organizations have resisted adopting object-oriented database management systems because ________. A) object-oriented programming uses simplified data structures that fit easily into relational databases B) the cost of purchasing OODBMS packages is prohibitively high C) the cost of converting data from relational databases to OODBMSs is too high D) most large organizations have older applications that are not based on object oriented programming E) C and D |
Answer: E
|
|
89) For database development, the most important Web-related technology to emerge in recent years is:
A) FTP. B) HTTP. C) XML. D) OODBMS. E) All of the above. |
Answer: C
|
|
90) For database development, a challenge to the relational model and the use of SQL. This challenge is known as:
A) the Web services movement. B) the NoSQL movement. C) the SOAP movement. D) the NoSOAP movement. E) the UDDI movement. |
Answer: C |