Database Concepts 8th Edition

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix A Getting Started with Microsoft SQL Server 2016 1) To start working with SQL Server 2016 in Windows 10, use the command Start | All Apps

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix B Getting Started with Oracle Database XE 1) Oracle Database XE uses Application Express to create new workspaces. Answer: TRUE Diff: 1 Page Ref: B-16 AACSB:

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix C Getting Started with MySQL 5.7 Community Server 1) Users log into MySQL Workbench using the Connect to MySQL Server dialog box. Answer: TRUE Diff: 1

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix E Advanced SQL 1) Importing Microsoft Excel data into a DMBS varies considerably from DBMS to DBMS. Answer: TRUE Diff: 2 Page Ref: E-54 AACSB: Information

12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 55) The SQL command SELECT is used to retrieve data from view instances. Answer: TRUE Diff: 1 Page Ref: E-35 AACSB: Information Technology Chapter Obj: To use SQL statements to create

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix F Getting Started with Systems Analysis and Design 1) There is no set format for a statement of work (SOW). Answer: TRUE Diff: 1 Page Ref:

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix G Getting Started with Microsoft Visio 2016 1) Microsoft Visio 2016 is a component of Microsoft Office 2016. Answer: TRUE Diff: 1 Page Ref: G-3 AACSB:

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix H The Access WorkbenchSection HMicrosoft Access 2016 Switchboards 1) A Microsoft Access 2016 switchboard provides networking capabilities in Microsoft Access 2016. Answer: FALSE Diff: 1 Page

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix I Getting Started with Web Servers, PHP, and the NetBeans IDE 1) The default WPI 5.0 installation provides full support for both the standard ODBC and

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix J Business Intelligence Systems 1) Business Intelligence (BI) systems are information systems that help users analyze and use data. Answer: TRUE Diff: 1 Page Ref: J-4

12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 49) Market basket analysis as described in the text uses the technique of conditional probabilities. Answer: TRUE Diff: 3 Page Ref: J-15 AACSB: Information Technology Chapter Obj: Learn the basic concepts of

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Appendix K Big Data 1) ________ is a set of approaches for taking portions of a database and moving them to a different server in a cluster.

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 1 Getting Started 1) Regarding Big Data, what does the term NoSQL really mean? A) No SQL used B) NortonOS Query Language C) Notational Query Language

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 2 The Relational Model 1) A key must be unique. Answer: FALSE Diff: 1 Page Ref: 74 AACSB: Information Technology Chapter Obj: Learn basic relational terminology

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 3 Structured Query Language 1) The result for SELECT statements in SQL is a relation unless the result is a single number. Answer: FALSE Diff: 1

12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 49) Microsoft Access SQL commands are run within the SQL View of a Query window. Answer: TRUE Diff: 1 Page Ref: 204 AACSB: Information Technology Chapter Obj: Learn basic SQL statements

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 5 Database Design 1) The technique for representing E-R relationships in the relational model is dependent on the minimum cardinality. Answer: FALSE Diff: 1 Page Ref:

12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 35) To create a 1:1 relationship between two tables in Microsoft Access, the Indexed property of the foreign key column must be set to ________. Answer: Yes (No Duplicates) Diff: 3

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 6 Database Administration 1) Additional DBA responsibilities do not include ________. A) problem and error reporting B) requests of changes to existing systems C) controlling database

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 7 Database Processing Applications 1) When using Microsoft Access and IIS, the Web pages that access the database cannot be written using PHP. Answer: FALSE Diff:

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 8 Data Warehouses, Business Intelligence Systems, and Big Data 1) NoSQL really stands for "Not only SQL." Answer: TRUE Diff: 1 Page Ref: 511 AACSB: Information

12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 12 Copyright 2018 Pearson Education, Inc. 48) A data mart differs from a data warehouse in these ways except ________. A) it has a smaller database B) it deals with a particular component or functional area of the

1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. 1 Copyright 2018 Pearson Education, Inc. Database Concepts, 8e (Kroenke) Chapter 4 Data Modeling and the Entity-Relationship Model 1) One or more entities can be associated together in relationships. Answer: TRUE Diff: 2 Page Ref: 267 AACSB: