Skip to content
Exam Guides

Test Bank for Database Concepts, 9th Edition

Test Bank for Database Concepts, 9th Edition offers everything you need for thorough exam preparation, including solved questions and MCQs.

Preview 16 of 221 pages

See the first 16 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    1 Database Concepts, 9e (Kroenke) Extension A Working with MySQL 1) MySQL is an open source DBMS that only runs on Unix and Linux operating systems. Answer: FALSE Diff: 1 Page Ref: A - 3 AACSB: Information Technology Chapter Obj.: Learn how to install MySQL Community Server 8.0 Classification: Concept 2) Microsoft Windows users should install MySQL Community Server 8.0 using the MySQL Installer for Windows. Answer: TRUE Diff: 1 Page Ref: A - 3 AACSB: Information Technology Chapter Obj.: Learn how to install MySQL Community Server 8.0 Classification: Concept 3) The MySQL Workbench is included in the MySQL Community Server 8.0 installation. Answer: FALSE Diff: 1 Page Ref: A - 4 AACSB: Information Technology Chapter Obj.: Learn ho w to install My SQL Workbench Classification: Concept 4) MySQL is configured using the MySQL Installer for Windows. Answer: TRUE Diff: 1 Page Ref: A - 4 AACSB: Information Technology Chapter Obj.: Learn how to install MySQL Community Server 8.0 Classification: Conc ept 5) For use with this book, it is recommended that MySQL be configured as a developer machine. Answer: TRUE Diff: 2 Page Ref: A - 4 AACSB: Information Technology Chapter Obj.: Learn how to install MySQL Community Server 8.0 Classi fication: Concept 6) The spreadsheet data must first be highlighted (selected) to be imported using the MySQL for Excel Add - In. Answer: TRUE Diff: 1 Page Ref: A - 50 AACSB: Information Technology Chapter Obj.: Learn how to import Microsoft Excel workshe et data into a database Classification: Concept

  2. Page 2
  3. Page 3
    Read page 3 as text

    2 7) If you are using Microsoft Windows operating system, it is recommended that you download the MySQL Installer for Windows. Answer: TRUE Diff: 1 Page Ref: A - 5 AACSB: Information Technology Chapter Obj.: Learn how t o install MySQL Community Server 8.0 Classification: Concept 8) To start working with MySQL Community Server 8.0 in Windows, open MySQL Workbench and then open the Local instance. Answer: TRUE Diff: 1 Page Ref: A - 23 AACSB: Information Techn ology Cha pter Obj.: Learn how to create a database in MySQL 8.0 Classification: Concept 9) Users log into MySQL Workbench using the Connect to Database and Connect to MySQL Server dialog boxes. Answer: TRUE Diff: 1 Page Ref: A - 21 AACSB: Information Technolo gy Chapter Obj.: Learn how to create database designs in the MySQL Workbench Classification: Concept 10) MySQL Community Server 8.0 uses only operating system authentication. Answer: FALSE Diff: 2 Page Ref: A - 74 AACSB: Information Technology Chapte r Obj.: Learn how to use the database administrator functions of MySQL Workbench Classification: Concept 11) Schema is the MySQL synonym for database. Answer: TRUE Diff: 1 Page Ref: A - 23 AACSB: Information Technology Chapter Obj.: Le arn how to ins tall MySQL Community Server 8.0 Classification: Concept 12) Database objects are displayed in the Object Explorer window in the MySQL Workbench. Answer: FALSE Diff: 1 Page Ref: A - 19 AACSB: Information Technology Chapter Obj.: Learn how t o install M ySQL Workbench Classification: Concept

  4. Page 4
    Read page 4 as text

    3 13) A new MySQL database is created using the New Database dialog box. Answer: FALSE Diff: 2 Page Ref: A - 23 AACSB: Information Technology Chapter Obj.: Learn how to create a database in MySQL 8.0 Classificati on: Concept 14) Users should create a Workspace folder to hold documents created with the MySQL Workbench. Answer: TRUE Diff: 1 Page Ref: A - 19 AACSB: Information Technology Chapter Obj.: Learn ho w to create database designs in the MySQL Workbench C lassification: Concept 15) MySQL Workbench is the MySQL GUI application development utility. Answer: TRUE Diff: 1 Page Ref: A - 2 AACSB: Information Technology Chapter Obj.: Learn how to install MySQL Workbench Classification: Concept 16) MySQL Wor kbench is the MySQL GUI database administration utility. Answer: TRUE Diff: 2 Page Ref: A - 74 AACSB: Information Technology Chapter Obj.: Learn how to use the database administrator functions of MySQL Wor kbench Classification: Concept 17) The MySQL Table Editor is accessible from the MySQL Workbench. Answer: TRUE Diff: 2 Page Ref: A - 62 AACSB: Information Technology Chapter Obj.: Learn how to install MySQL Workbench Classification: Concept 18) To run an SQL script, click the Execute button on the Query Toolbar. Answer: FALSE Diff: 2 Page Ref: A - 45 AACSB: Information Technology Chapter Obj.: Learn how to submit SQL commands to query a database Classification: Concept

  5. Page 5
    Read page 5 as text

    4 19) To run an SQL script , click the "Execute SQL Script (or selected p ortion)" button on the MySQL Workbench. Answer: TRUE Diff: 1 Page Ref: A - 40 AACSB: Information Technology Chapter Obj.: Learn how to create and run SQL scripts in MySQL 8.0 Classification: Concept 20) To d isplay an existing SQL script, click the "O pen an SQL script file (in new query tab)" button. Answer: TRUE Diff: 1 Page Ref: A - 24 AACSB: Information Technology Chapter Obj.: Learn how to create and run SQL scripts in MySQL 8.0 Classification: Concept 21) In MySQL, surrogate keys that use a sequence maintained by MySQL should be given a data type of IDENTITY. Answer: FALSE Di ff: 1 Page Ref: A - 39 AACSB: Information Technology Chapter Obj.: Learn how to submit SQL commands to create table structures Classification: Concept 22) In order to create MySQL EER diagrams, users must log into MySQL using the Connect to Database and the Connect to MySQL Server dialog boxes. Answer: FALSE Diff: 1 Page Ref: A - 60 AACSB: Information Technology Chapter Obj.: Learn how to create database designs in the MySQL Workbench Classification: Concept 23) To execute an SQL query, click the "Execute the selected portion of the script or everything, if there is n o selection" button. Answer: TRUE Diff: 1 Page Ref: A - 40 AACSB: Information Technology Chap ter Obj.: Learn how to create and run SQL scripts in MySQL 8.0 Classification: Concept 24) Users should create an EER Models folder to hold EER models created w ith the MySQL Workbench. Answer: TRUE Diff: 2 Page Ref: A - 19 AACSB: Information Technolo gy Chapter Obj.: Learn how to create database designs in the MySQL Workbench Classification: Concept

  6. Page 6
    Read page 6 as text

    5 25) To create a new MySQL Workbench EER model, you can use the New Model button on the Home page. Answer: TRUE Diff: 1 Page Ref: A - 57 AACSB: Inform ation Technology Chapter Obj.: Learn how to create database designs in the MySQL Workbench Classification: Concept 26) To create a new MySQL Workbench EER model, you can use the File | New Model command. Answer: TRUE Diff: 2 Page Ref: A - 57 AACSB: I nformation Technology Chapter Obj.: Learn how to create database designs in the MySQL Workbench Classification: Concept 27 ) MySQL Community Server requires that the .NET Framework version 4.5.1 be installed. Answer: FALSE Diff: 1 Page Ref: A - 5 AACSB : Information Technology Chapter Obj.: Learn how to install MySQL Community Server 8.0 Classification: Concept 28) MySQL Com munity Server uses a user account called root for the name of the default MYSQL administrator account. Answer: TRUE Diff: 1 Page Ref: A - 4 AACSB: Information Technology Chapter Obj.: Learn how to install MySQL Community Server 8.0 Classification: Concep t 29) The MySQL Workbench is included in the MySQL Community Server installation when the MySQL Installer for Windows is use d. Answer: TRUE Diff: 1 Page Ref: A - 4 AACSB: Information Technology Chapter Obj.: Learn how to install MySQL Workbench Classification: Concept 30) To add a table to a database design, click the Place a New Table button, move the cursor to the diagr am area and click the left mouse button. Answer: TRUE Diff: 1 Page Ref: A - 61 AACSB: In formation Technology Chapter Obj.: Learn how to submit SQL commands to create table structures Classification: Concept

  7. Page 7
    Read page 7 as text

    6 31) In the MySQL Table Editor, the abbrevia tion PK stands for partial key . Answer: FALSE Diff: 1 Page Ref: A - 63 AACSB: Information T echnology Chapter Obj.: Learn how to submit SQL commands to create table structures Classification: Concept 32) In the MySQL Table Editor, the abbreviation NN stands for NOT NULL . Answer: TRUE Diff: 1 Page Ref: A - 63 AACSB: Information Technology Chapt er Obj.: Learn how to submit SQL commands to create table structures Classification: Concept 33) In the MySQL Table Editor, the abbreviation AI stands for A UTO_INCREMENT . Answer: TRUE Diff: 1 Page Ref: A - 63 AACSB: Information Technology Chapter Obj.: Learn how to submit SQL commands to create table structures Classification: Concept 34) In the MySQL Workbench, a 1: N non - identifying relationship betwee n two tables that already contain the needed primary and foreign keys is created using the 1:N Non - identifying Relationship button. Answer: FALSE Diff: 1 Page Ref: A - 68 AACSB: Information Technology Chapter Obj.: Lea rn how to submit SQL commands to c reate table structures Classification: Concept 35) In the MySQL Workbench, a 1:N non - identifying relationship between two tables that already contain the needed primary and foreign keys is created using the Place a Relat ionship Using Existing Columns but ton. Answer: TRUE Diff: 1 Page Re f: A - 68 AACSB: Information Technology Chapter Obj.: Learn how to submit SQL commands to create table structures Classification: Concept

  8. Page 8
    Read page 8 as text

    7 36) MySQL uses the "Safe Updates" – Forbid UPDATE and DELETE statements with no key in WHERE clause or no LIMIT clause – checkbox to control the behavior of UPDATE and DELETE statements run from the MySQL Workbench. Answer: TRUE Diff: 2 Page Ref: A - 129 AACSB: Information Technology Chapter Obj.: Learn ho w to use advanced SQL featu res in MySQL 8.0 Classification: Concept 37) MySQL users are created on the Users and Privileges page in the MySQL Workbench. Answer: TRUE Diff: 1 Page Ref: A - 74 AACSB: Information Technology Chapter Obj.: Learn how to use t he database administrato r functions of MySQL Workbench Classification: Concept 38) MySQL users are granted MySQL privileges for specific schemas only. Answer: FALSE Diff: 2 Page Ref: A - 73 AACSB: Information Technology Chapter Obj.: Learn how to use the database administra tor functions of MySQL Workbench Classification: Concept 39) MySQL users may be granted MySQL server administrative roles. Answer: TRUE Diff: 1 Page Ref: A - 74 AACSB: Information Technology Chapter Obj.: Learn ho w to use the database administrator f unctions of MySQL Workbench Classification: Concept 40) MySQL users must be granted the right to have MySQL schema privileges before the specific privileges themselves are granted. Answer: TRUE Diff: 2 Page Ref: A - 77 AACSB: Information Technology Ch apter Obj.: Learn how to use the database administrator functions of MySQL Workbench Classification: Concept 41) The MySQL Schema Privileges Select "ALL" button marks all MySQL privileges for assignment to the user. Ans wer: FALSE Diff: 1 Page Ref: A - 74 AACSB: Information Technology Chapter Obj.: Learn how to use the database administrator functions of MySQL Workbench Classification: Concept

  9. Page 9
    Read page 9 as text

    8 42) MySQL users should always be given the GRANT OPTION for each schema. Answer: FALSE Diff: 1 Page Re f: A - 78 AACSB: Information Technology Chapter Obj.: Learn how to use the database administrator functions of MySQL Workbench Classification: Concept 43) MySQL databases are backed up using the MySQL Backup System. Answer: FALSE Diff: 2 Page Ref: A - 79 AACSB: Information Technology Chapter Obj.: Learn how to use the database administrator functions of MySQL Workbench Classification: Concept 44) MySQL us es the term data export dump as a synonym for backup. Answer: TRUE Diff: 1 Page Ref: A - 79 AA CSB: Information Technology Chapter Obj.: Learn how to use the database administrator functions of MySQL Workbench Classification: Concept 45) MySQL backups ar e run on the Administration - Data Export tab of the Data Export page. Answer: TRUE Diff: 1 Page Ref: A - 81 AACSB: Information Technology Chapter Obj.: Learn how to use the database administrator functions of MySQL Workbench Classification: Concept 46) A MySQL data backup is accomplished by using the "Data Export" feature. Answer: TRUE Dif f: 1 Page Ref: A - 81 AACSB: Information Technology Chapter Obj.: Learn how to use the database administrator functions of MySQL Workbench Classification: Concept 47) MySQL restores are run on the Restore from Disk tab of the Data Export and Restore p age. Answer: FALSE Diff: 2 Page Ref: A - 81 AACSB: Information Techno logy Chapter Obj.: Learn how to use the database administrator functions of MySQL Workbench Classification: Concept

  10. Page 10
    Read page 10 as text

    9 48) Logging into a MySQL DBMS is done using ________. A) the Con nect to Server command B) the Connect to Server dialog box C) the Connect to MySQL Server command D) the Connect to MySQL Server dialog box E) None of the above is correct Answer: D Diff: 2 Page Ref: A - 21 AACSB: Information Technology Chapter Obj.: L earn how to install MySQL Community Server 8.0 Classification: Concept 49) To access documentation about the MySQL Workbench, use the ________. A) Help | MySQL Workbench command B) Help | Help Index command C) Help | MySQL Website command D) Help | MySQL .com Website command E) Help | Documentation command Answer: B Diff: 2 Page Ref: A - 47 AACSB: Information Technology Chapter Obj.: Learn how to install MySQL Workbench Classification: Concept 50) SQL query results are displayed ________. A) in a tab bed Result Grid window B) in a tabbed Results1 window C) in a tabbed Docume nt window D) in a tabbed Messages window E) in a tabbed Finished window Answer: A Diff: 2 Page Ref: A - 46 AACSB: Information Technology Chapter Obj.: Learn how to submit SQL co mmands to query a database Classification: Concept 51) To access documentati on at the MySQL Web site ________. A) use the Help | MySQL Workbench command B) use the Help | Help Index command C) use the Help | MySQL Website command D) use the Help | MySQL. com Website command E) go directly to the Web site http://dev.mysql.com/doc An swer: E Diff: 2 Page Ref: A - 47 AACSB: Information Technology Chapter Obj.: Learn how to install MySQL Community Server 8.0 Classification: Concept

  11. Page 11
    Read page 11 as text

    10 52) In the MySQL Table Editor, the abbreviation for NOT NULL is ________. A) PK B) NN C) UQ D) BIN E) AI Answer: B Diff: 2 Page Ref: A - 63 AACSB: Information Technology Chapter Obj.: Learn how to create a database in MySQL 8.0 Classification: Concept 53) In the MySQL Tabl e Editor, the abbreviation for Primary Key is ________. A) PK B) NN C) UQ D) BI N E) AI Answer: A Diff: 2 Page Ref: A - 63 AACSB: Information Technology Chapter Obj.: Learn how to create a database in MySQL 8.0 Classification: Concept 54) In the MySQL Table Editor, the abbreviation for AUTO_INCREMENT is ________. A) PK B) NN C) UQ D) BIN E) AI Answer: E Diff: 2 Page Ref: A - 63 AACSB: Information Technology Chapter Obj.: Learn how to create a database in MySQL 8.0 Classification: Concept

  12. Page 12
    Read page 12 as text

    11 55) In the MySQL Workbench, a 1:N non - identifying relationship between two tables that alr eady contain the needed primary and foreign keys is created using ________. A) the 1:N Identifying Relationship button B) the 1:N Non - identifying Relationship button C) the N:M Identifying Relationship button D) the Place a Relationship Using Existing Colu mns button E) None of the above is correct. Answer: D Diff: 2 Page Ref: A - 68 AACSB: Information Technology Chapter Obj.: Learn how to create a database in MySQL 8.0 Cl assification: Concept 56) The MySQL Installer for Windows requires the ________ oper ating system. A) Suse Linux B) Red Hat Linux C) Android D) Microsoft Windows Answer: D Diff: 1 Page Ref: A - 4 AACSB: Information Technology Chapter Obj.: Learn how t o install MySQL Community Server 8.0 Classification: Concept 57) The main MySQL GUI utility is ________. A) MySQL Management Studio B) MySQL Developer C) My SQL Workbench D) Both A and B are correct Answer: C Diff: 1 Page Ref: A - 2 AACSB: Information Technology Chapter Obj.: Learn how to install MySQL Community Server 8.0 Classification: Concept 58) In the MySQL Workbench, a 1:N non - identifying relationship between two tables that do not contain the needed primary and foreign keys is created using ________. A) the 1:N Identifying Relationship button B) the 1:N Non - id entifying Relationship button C) the N:M Identifying Relationship button D) the Place a Relationship Using Existing Columns button E) None of the above is correct Answer: D Diff: 2 P age Ref: A - 68 AACSB: Information Technology Chapter Obj.: Learn how to create a database in MySQL 8.0 Classification: Concept

  13. Page 13
    Read page 13 as text

    12 59) Logging into the MySQL DBMS is done using ________. A) the Connect to Server command B) the Connect to Server dialog box C ) the Local instance MySQL56 command D) the Local instance MySQL56 dialog box Answer: D Diff: 2 Page Ref: A - 75 AACSB: Information Technology Chapter Obj.: Learn how to use the database administrator functions of MySQL Workbench Classification: Conce pt 60) The MySQL Workbench can be used to create ________. A) data models B) data designs C) database models D) database designs E) database diagrams Answer: D Diff: 1 Page Ref: A - 4 AACSB: Information Technology Chapter Obj.: Learn how to create a d atabase in MySQL 8.0 Classification: Concept 61) A new MySQL database is created using ________. A) the New Database dialog tab B) the Create Database command C) the new schema dialog tab D) the Create a new button Answer: D Diff: 2 Page Ref: A - 23 AA CSB: Information Technology Chapter Obj.: Learn how to use the database administrator functions of MySQL Workbench Classification: Concept 62) The active MySQL database is specified using ________. A) the Set Schema command B) the Set Database command C) the Make Default Schema co mmand D) the Set as Default Schema command Answer: D Diff: 2 Page Ref: A - 28 AACSB: Information Technology Chapter Obj.: Learn how to create database designs in the MySQL Workbench Classification: Concept

  14. Page 14
    Read page 14 as text

    13 63) In order t o use MySQL Workbench to create d atabase designs, you must log into MySQL using ________. A) the Connect to Database dialog box B) the Connect to MySQL Server dialog box C) the MySQL | Connect to Server command D) Both A and B are used together. E) None of the above is correct - no login is required. Answer: E Diff: 2 Page Ref: A - 19 AACSB: Information Technology Chapter Obj.: Learn how to create database designs in the MySQL Workbench Classification: Concept 64) To create a new data model and E - R di agram, you can use ________. A) the New Model button on the Home page B) the File | New Model command C) the Start new EER command D) Either A or B E) the EER express command Answer: D Diff: 2 Page Ref: A - 57 AACSB: Information Technology Chapter Obj.: Learn how to create database designs in the MySQL Workbench Classification: Concept 65) SQL statements can be run individually or as part of a related group of SQL statements known as a ________. A) Result B) Resultset C) Script D) Scriptset Answer: C Diff: 1 Page Ref: A - 23 AACSB: Information Technology Chapter Obj.: Learn how to create and run SQL scripts in MySQL 8.0 Classification: Concept

  15. Page 15
    Read page 15 as text

    14 66) To run a single SQL command in MySQL Community Server 8.0 ________. A) click the "Execute" button i n the MySQL Workbench B) click the "Execute SQL in Connected Server" button in the MySQL Workbench C) click the "Execute SQL Script in Connected Server" button in the MySQL Workbench D) click the "Execute SQL Statement under the keyboard cursor" button in the My SQL Workbench Answer: D Diff: 2 Page Ref: A - 28 AACSB: Information Technology Chapter Obj.: Learn how to create database designs in the MySQL Workbench Classification: Concept 67) The SQL query data results are displayed ________. A) in the Na vigator window B) in a tabbed Result Grid C) in a Messages window D) in a tabbed Action Output window Answer: D Diff: 3 Page Ref: A - 41 AACSB: Information Technology Chapter Obj.: Learn how t o create database designs in the MySQL Workbench Classificat ion: Concept 68) When importing data from Excel, what SQL statement is needed to add constraints to your newly created tables? A) SQL ALTER TABLE B) SQL CHANGE TABLE C) SQL ADD CONSTRAINT D) SQL ADD ALL E) SQL OPEN TABLE Answer: A Diff: 2 Page Ref: A - 39 AACSB: Information Technology Chapter Obj.: Learn how to import Microsoft Excel worksheet data into a database Classification: Concept 69) MySQL Community Server requires the prior installati on of ________. A) the .NET Framework version 3.0 B) the .NET Framework version 3.5 C) the .NET Framework version 3.5 SP1 D) the .NET Framework version 4.5.1 E) None of the above — the .NET Framework is not required. Answer: B Diff: 2 Page Ref: A - 5 AACSB: Information Technology Chapter Obj.: Learn how to ins tall MySQL Community Server 8.0 Classification: Concept

  16. Page 16
    Read page 16 as text

    15 70) The E - R diagrams created in the MySQL Workbench use ________. A) IE Crow's Foot notation B) IDEF1X notation C) UML notation D) Micro soft Visio 2010 Arrow notation E) None of the above is correct . Answer: A Diff: 2 Page Ref: A - 73 AACSB: Information Technology Chapter Obj.: Learn how to install MySQL Community Server 8.0 Classification: Concept 71) The MySQL GUI tool is replaced by ________. A) MySQL Query Browser B) MySQL Administrator C) My SQL Workbench D) MySQL for Excel E) MySQL for Access Answer: C Diff: 2 Page Ref: A - 2 AACSB: Information Technology Chapter Obj.: Learn how to install MySQL Workbench Classification: Concept 72) To run an SQL script or SQL command in MySQL Server Community Edition ________. A) click the Execute button on the Query Toolbar B) click the Execute button on the Browser Toolbar C) click the Run button on the Query Toolbar D) click the Run button on the Browser Toolbar E) click the Execute SQL Script but ton on the Toolbar Answer: E Diff: 2 Page Ref: A - 40 AACSB: Information Technology Chapter Obj.: Learn how to submit SQL commands to que ry a database Classification: Concept

205 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document

More Information Technology study materials

See all

Study this document with CramX

Once it is in your library, every tool can work from it.