Test Bank for Database Concepts, 9th Edition

Preview (16 of 221 Pages)

100%

Purchase to unlock

Loading page image...

1Database Concepts, 9e(Kroenke)Extension A Working with MySQL1) MySQL is an open source DBMS that only runs on Unix and Linux operating systems.Answer: FALSEDiff: 1Page Ref:A-3AACSB: Information TechnologyChapter Obj.:Learn how to installMySQL Community Server 8.0Classification: Concept2) Microsoft Windows users should install MySQL Community Server 8.0 using the MySQLInstaller for Windows.Answer: TRUEDiff:1Page Ref:A-3AACSB: Information TechnologyChapterObj.: Learn howto install MySQL Community Server 8.0Classification: Concept3) The MySQL Workbench is included in the MySQL Community Server 8.0 installation.Answer: FALSEDiff: 1Page Ref:A-4AACSB: Information TechnologyChapter Obj.: Learn how to install MySQL WorkbenchClassification: Concept4) MySQL is configured using the MySQL Installer for Windows.Answer: TRUEDiff: 1Page Ref:A-4AACSB: Information TechnologyChapter Obj.: Learn how to install MySQL Community Server 8.0Classification: Concept5) For use with this book, it is recommended that MySQL be configured as a developer machine.Answer: TRUEDiff: 2Page Ref:A-4AACSB: Information TechnologyChapter Obj.: Learn how to install MySQL Community Server 8.0Classification: Concept6) The spreadsheet data must first be highlighted (selected) to be imported using the MySQL forExcel Add-In.Answer: TRUEDiff: 1Page Ref:A-50AACSB: Information TechnologyChapter Obj.: Learn how to import Microsoft Excel worksheet data into adatabaseClassification: Concept

Loading page image...

27) If you are using Microsoft Windows operating system, it is recommended that you downloadthe MySQL Installer for Windows.Answer: TRUEDiff: 1Page Ref:A-5AACSB: Information TechnologyChapter Obj.:Learn how to install MySQL Community Server 8.0Classification: Concept8) To start working with MySQL Community Server 8.0 in Windows, open MySQL Workbenchand then open the Local instance.Answer: TRUEDiff: 1Page Ref:A-23AACSB: Information TechnologyChapter Obj.: Learn how to create a database in MySQL 8.0Classification: Concept9) Users log into MySQL Workbench using the Connect to Database and Connect to MySQLServer dialog boxes.Answer: TRUEDiff: 1Page Ref:A-21AACSB:Information TechnologyChapter Obj.: Learn how to create database designs in the MySQL WorkbenchClassification: Concept10) MySQL Community Server 8.0 uses only operating system authentication.Answer: FALSEDiff: 2Page Ref:A-74AACSB: InformationTechnologyChapter Obj.: Learn how to use the database administrator functions of MySQL WorkbenchClassification: Concept11) Schema is the MySQL synonym for database.Answer: TRUEDiff: 1Page Ref:A-23AACSB: Information TechnologyChapter Obj.: Learn how to install MySQL Community Server 8.0Classification: Concept12) Database objects are displayed in the Object Explorer window in the MySQL Workbench.Answer: FALSEDiff: 1Page Ref:A-19AACSB: Information TechnologyChapter Obj.: Learn how to install MySQL WorkbenchClassification: Concept

Loading page image...

313) A new MySQL database is created using the New Database dialog box.Answer: FALSEDiff: 2Page Ref:A-23AACSB: Information TechnologyChapter Obj.:Learn how to create a database in MySQL 8.0Classification: Concept14) Users should create a Workspace folder to hold documents created with the MySQLWorkbench.Answer: TRUEDiff: 1Page Ref:A-19AACSB: Information TechnologyChapter Obj.: Learn how to create database designs in the MySQL WorkbenchClassification: Concept15) MySQL Workbench is the MySQL GUI application development utility.Answer: TRUEDiff: 1Page Ref:A-2AACSB: Information TechnologyChapter Obj.: Learn how to install MySQLWorkbenchClassification: Concept16) MySQL Workbench is the MySQL GUI database administration utility.Answer: TRUEDiff: 2Page Ref:A-74AACSB: Information TechnologyChapter Obj.: Learn how to use the database administrator functions of MySQL WorkbenchClassification: Concept17) The MySQLTable Editor is accessible from the MySQL Workbench.Answer: TRUEDiff: 2Page Ref:A-62AACSB: Information TechnologyChapter Obj.: Learn how to install MySQL WorkbenchClassification: Concept18)To run an SQL script, click the Execute button onthe Query Toolbar.Answer: FALSEDiff: 2Page Ref:A-45AACSB: Information TechnologyChapter Obj.: Learn how to submit SQL commands to query a databaseClassification: Concept

Loading page image...

419) To run an SQL script, click the "Execute SQL Script (or selected portion)" button on theMySQL Workbench.Answer: TRUEDiff: 1Page Ref:A-40AACSB: Information TechnologyChapter Obj.: Learn how to create and run SQL scripts in MySQL 8.0Classification: Concept20) To display an existing SQL script, click the "Open an SQL script file (in new query tab)"button.Answer: TRUEDiff: 1Page Ref:A-24AACSB: Information TechnologyChapter Obj.: Learn how to create and run SQL scripts in MySQL 8.0Classification: Concept21) In MySQL, surrogate keys that use asequence maintained by MySQL should be given a datatype of IDENTITY.Answer: FALSEDiff: 1Page Ref:A-39AACSB: Information TechnologyChapter Obj.:Learn how to submit SQL commands to create table structuresClassification: Concept22) In orderto create MySQL EER diagrams, users must log into MySQL using the Connect toDatabase and the Connect to MySQL Server dialog boxes.Answer: FALSEDiff: 1Page Ref:A-60AACSB: Information TechnologyChapter Obj.: Learn how to create database designsin the MySQL WorkbenchClassification: Concept23) To execute an SQL query, click the "Execute the selected portion of the script or everything,if there is no selection" button.Answer: TRUEDiff: 1Page Ref:A-40AACSB: Information TechnologyChapter Obj.: Learn how to create and run SQL scripts in MySQL 8.0Classification: Concept24) Users should create anEER Modelsfolder to hold EER models created with the MySQLWorkbench.Answer: TRUEDiff: 2Page Ref:A-19AACSB: Information TechnologyChapter Obj.: Learn how to create database designs in the MySQL WorkbenchClassification: Concept

Loading page image...

525) To create a new MySQL Workbench EER model, you can use theNew Modelbutton on theHome page.Answer: TRUEDiff: 1Page Ref:A-57AACSB: Information TechnologyChapter Obj.: Learn how to create database designs in the MySQL WorkbenchClassification: Concept26)To create a new MySQL Workbench EER model, you can use theFile | New Modelcommand.Answer: TRUEDiff: 2Page Ref:A-57AACSB: Information TechnologyChapter Obj.: Learn how to create database designs in the MySQL WorkbenchClassification: Concept27) MySQL Community Server requires that the .NET Framework version 4.5.1 be installed.Answer: FALSEDiff: 1Page Ref:A-5AACSB: Information TechnologyChapter Obj.: Learn how to install MySQL Community Server 8.0Classification: Concept28) MySQL Community Server uses a user account calledrootfor the name of the defaultMYSQL administrator account.Answer: TRUEDiff: 1Page Ref:A-4AACSB: Information TechnologyChapter Obj.: Learn how to install MySQL Community Server 8.0Classification: Concept29) The MySQL Workbench is included in the MySQL Community Server installation when theMySQL Installer for Windows is used.Answer: TRUEDiff: 1Page Ref:A-4AACSB: Information TechnologyChapter Obj.:Learn how to install MySQL WorkbenchClassification: Concept30) To add a table to a database design, click thePlace a New Tablebutton, move the cursor tothe diagram area and click the left mouse button.Answer: TRUEDiff: 1Page Ref:A-61AACSB: Information TechnologyChapter Obj.: Learn how to submit SQL commands to create table structuresClassification: Concept

Loading page image...

631) In the MySQL Table Editor, the abbreviationPKstands forpartial key.Answer: FALSEDiff: 1Page Ref:A-63AACSB: Information TechnologyChapter Obj.: Learn how to submit SQL commands to create table structuresClassification: Concept32) In the MySQL Table Editor, the abbreviationNNstands forNOT NULL.Answer: TRUEDiff: 1Page Ref:A-63AACSB: Information TechnologyChapter Obj.: Learn how to submit SQL commands to create table structuresClassification: Concept33) In the MySQL Table Editor, the abbreviationAIstands forAUTO_INCREMENT.Answer: TRUEDiff: 1Page Ref:A-63AACSB: Information TechnologyChapter Obj.:Learn how to submit SQL commands to create table structuresClassification: Concept34) In the MySQL Workbench, a 1:N non-identifying relationship between two tables thatalready contain the needed primary and foreign keys is created using the1:N Non-identifyingRelationshipbutton.Answer: FALSEDiff: 1Page Ref:A-68AACSB: Information TechnologyChapter Obj.: Learn how to submit SQL commands to create table structuresClassification: Concept35) In the MySQL Workbench, a 1:N non-identifying relationship between two tables thatalready contain the needed primary and foreign keys is created using thePlace a RelationshipUsing Existing Columnsbutton.Answer: TRUEDiff: 1Page Ref:A-68AACSB: Information TechnologyChapter Obj.: Learn how to submit SQL commands to create table structuresClassification: Concept

Loading page image...

736) MySQL uses the"Safe Updates"–Forbid UPDATEand DELETE statements with nokey inWHERE clause or no LIMIT clause–checkbox to control the behavior of UPDATE and DELETEstatements run from the MySQL Workbench.Answer: TRUEDiff: 2Page Ref:A-129AACSB: Information TechnologyChapter Obj.: Learn how to use advanced SQL features in MySQL 8.0Classification: Concept37) MySQL users are created on the Users and Privileges page in the MySQL Workbench.Answer: TRUEDiff: 1Page Ref:A-74AACSB: Information TechnologyChapter Obj.: Learn how to use the database administrator functions of MySQL WorkbenchClassification: Concept38) MySQL users are granted MySQL privileges for specific schemas only.Answer: FALSEDiff: 2Page Ref:A-73AACSB: Information TechnologyChapter Obj.:Learn how to use the database administrator functions of MySQL WorkbenchClassification: Concept39) MySQL users may be granted MySQL server administrative roles.Answer: TRUEDiff: 1Page Ref:A-74AACSB: Information TechnologyChapter Obj.: Learn how to use the database administrator functions of MySQL WorkbenchClassification: Concept40) MySQL users must be granted the right to have MySQL schema privileges before thespecific privileges themselves are granted.Answer: TRUEDiff: 2Page Ref:A-77AACSB: Information TechnologyChapter Obj.: Learn how to use the database administrator functions of MySQL WorkbenchClassification: Concept41) The MySQL Schema PrivilegesSelect "ALL"button marks all MySQL privileges forassignment to the user.Answer: FALSEDiff: 1Page Ref:A-74AACSB: Information TechnologyChapter Obj.: Learn how to use the database administrator functions of MySQL WorkbenchClassification: Concept

Loading page image...

842)MySQL users should always be given the GRANT OPTION for each schema.Answer: FALSEDiff: 1Page Ref:A-78AACSB: Information TechnologyChapter Obj.: Learn how to use the database administrator functions of MySQL WorkbenchClassification: Concept43)MySQL databases are backed up using the MySQL Backup System.Answer: FALSEDiff: 2Page Ref:A-79AACSB: Information TechnologyChapter Obj.: Learn how to use the database administrator functions of MySQL WorkbenchClassification: Concept44) MySQL uses the termdata export dumpas a synonym for backup.Answer: TRUEDiff: 1Page Ref:A-79AACSB: Information TechnologyChapter Obj.: Learn how to use the database administrator functions of MySQL WorkbenchClassification: Concept45) MySQL backups are run on theAdministration-DataExporttab of theData Exportpage.Answer: TRUEDiff: 1Page Ref:A-81AACSB: Information TechnologyChapter Obj.: Learn how to use the database administrator functions of MySQL WorkbenchClassification: Concept46)A MySQL data backup is accomplished by using the "Data Export" feature.Answer: TRUEDiff: 1Page Ref:A-81AACSB: Information TechnologyChapter Obj.:Learn how to use the database administrator functions of MySQL WorkbenchClassification: Concept47) MySQL restores are run on theRestore from Disktab of theData Export and Restorepage.Answer: FALSEDiff: 2Page Ref:A-81AACSB: Information TechnologyChapter Obj.: Learn how to use the database administrator functions of MySQL WorkbenchClassification: Concept

Loading page image...

948) Logging into a MySQL DBMS is done using ________.A) the Connect to Server commandB) the Connect to Server dialog boxC) the Connectto MySQL Server commandD) the Connect to MySQL Server dialog boxE) None of the above is correctAnswer: DDiff: 2Page Ref:A-21AACSB: Information TechnologyChapter Obj.: Learn how to install MySQL Community Server 8.0Classification: Concept49)To access documentation about the MySQL Workbench, use the ________.A) Help | MySQL Workbench commandB) Help | Help Index commandC) Help | MySQL Website commandD) Help | MySQL.com Website commandE) Help | Documentation commandAnswer: BDiff: 2Page Ref:A-47AACSB: Information TechnologyChapter Obj.: Learn how to install MySQL WorkbenchClassification: Concept50) SQL query results are displayed ________.A) in a tabbed Result Grid windowB) in a tabbed Results1 windowC) in a tabbed Document windowD) in a tabbed Messages windowE) in a tabbed Finished windowAnswer: ADiff: 2Page Ref:A-46AACSB: Information TechnologyChapter Obj.: Learn how to submit SQL commands to query a databaseClassification: Concept51) To access documentation at the MySQL Web site ________.A) use the Help | MySQL Workbench commandB) use the Help | Help Index commandC) use the Help | MySQL Website commandD) use the Help | MySQL.com Website commandE) go directly to the Web site http://dev.mysql.com/docAnswer: EDiff: 2Page Ref:A-47AACSB: Information TechnologyChapter Obj.: Learn how to install MySQL Community Server 8.0Classification: Concept

Loading page image...

1052) In the MySQL TableEditor, the abbreviation forNOT NULLis ________.A) PKB) NNC) UQD) BINE) AIAnswer: BDiff: 2Page Ref:A-63AACSB: Information TechnologyChapter Obj.: Learn how to create a database in MySQL 8.0Classification: Concept53) In the MySQL Table Editor, the abbreviation forPrimary Keyis ________.A) PKB) NNC) UQD) BINE) AIAnswer: ADiff: 2Page Ref:A-63AACSB: Information TechnologyChapter Obj.: Learn how to create a database in MySQL 8.0Classification: Concept54) In the MySQLTable Editor, the abbreviation forAUTO_INCREMENTis ________.A) PKB) NNC)UQD) BINE) AIAnswer: EDiff: 2Page Ref:A-63AACSB: Information TechnologyChapter Obj.: Learn how to create a database in MySQL 8.0Classification: Concept

Loading page image...

1155) Inthe MySQL Workbench, a 1:N non-identifying relationship between two tables thatalready contain the needed primary and foreign keys is created using ________.A) the1:N Identifying RelationshipbuttonB) the1:N Non-identifying RelationshipbuttonC) theN:M Identifying RelationshipbuttonD) thePlace a Relationship Using Existing ColumnsbuttonE) None of the above is correct.Answer: DDiff: 2Page Ref:A-68AACSB: Information TechnologyChapter Obj.: Learn how to create a database in MySQL 8.0Classification: Concept56) The MySQL Installer for Windows requires the ________ operating system.A) Suse LinuxB) Red Hat LinuxC) AndroidD) Microsoft WindowsAnswer: DDiff: 1Page Ref:A-4AACSB: Information TechnologyChapter Obj.: Learn how to install MySQL Community Server 8.0Classification: Concept57)The main MySQL GUI utility is ________.A) MySQL Management StudioB) MySQL DeveloperC) My SQL WorkbenchD) Both A and B are correctAnswer: CDiff: 1Page Ref:A-2AACSB: InformationTechnologyChapter Obj.: Learn how to install MySQL Community Server8.0Classification: Concept58) In the MySQL Workbench, a 1:N non-identifying relationship between two tables that do notcontain the needed primary and foreign keys is created using________.A) the1:N Identifying RelationshipbuttonB) the1:N Non-identifying RelationshipbuttonC) theN:M Identifying RelationshipbuttonD) thePlace a Relationship Using Existing ColumnsbuttonE) None of the above is correctAnswer: DDiff: 2Page Ref:A-68AACSB: Information TechnologyChapter Obj.: Learn how tocreate a database in MySQL 8.0Classification: Concept

Loading page image...

1259) Logging into the MySQL DBMS is done using ________.A) the Connect to Server commandB) the Connect to Server dialog boxC) the Local instance MySQL56 commandD)the Local instance MySQL56 dialog boxAnswer: DDiff:2Page Ref:A-75AACSB: Information TechnologyChapter Obj.: Learn how to use the database administrator functions of MySQL WorkbenchClassification: Concept60) The MySQL Workbench can be used tocreate ________.A) data modelsB) data designsC) database modelsD) database designsE) database diagramsAnswer: DDiff: 1Page Ref:A-4AACSB: Information TechnologyChapter Obj.: Learn how to create a database in MySQL 8.0Classification: Concept61) A new MySQL database is created using ________.A) the New Database dialog tabB) the Create Database commandC) the new schema dialog tabD) the Create a new buttonAnswer: DDiff: 2Page Ref:A-23AACSB: Information TechnologyChapter Obj.: Learn how to use the database administrator functions of MySQL WorkbenchClassification: Concept62) The active MySQL database is specified using ________.A) the Set Schema commandB) the Set Database commandC) the Make Default Schema commandD) the Set as Default Schema commandAnswer: DDiff: 2Page Ref:A-28AACSB: Information TechnologyChapter Obj.: Learn how to create database designs in the MySQL WorkbenchClassification: Concept

Loading page image...

1363) In order to use MySQL Workbench to create database designs, you must log into MySQLusing ________.A) the Connect to Database dialog boxB) the Connect to MySQL Server dialog boxC) the MySQL | Connect to Server commandD) Both A and B are used together.E) None ofthe above is correct-no loginis required.Answer: EDiff: 2Page Ref:A-19AACSB: Information TechnologyChapter Obj.: Learn how to create database designs in the MySQL WorkbenchClassification: Concept64) To create a new data model and E-R diagram, you can use ________.A) theNew Modelbutton on the Home pageB) theFile | New ModelcommandC) theStart new EERcommandD) Either A or BE) the EER express commandAnswer: DDiff: 2Page Ref:A-57AACSB: Information TechnologyChapter Obj.:Learn how to create database designs in the MySQL WorkbenchClassification: Concept65) SQL statements can be run individually or as part of a related group of SQL statementsknown as a ________.A) ResultB) ResultsetC) ScriptD) ScriptsetAnswer: CDiff: 1Page Ref:A-23AACSB: Information TechnologyChapter Obj.: Learn how to create and run SQL scripts in MySQL 8.0Classification: Concept

Loading page image...

1466) To run a single SQL command in MySQL Community Server 8.0 ________.A) click the "Execute" button in theMySQL WorkbenchB) click the "Execute SQL in Connected Server" button in the MySQL WorkbenchC) click the "Execute SQL Script in Connected Server" button in the MySQL WorkbenchD) click the "Execute SQL Statement under the keyboard cursor" button inthe MySQLWorkbenchAnswer: DDiff: 2Page Ref:A-28AACSB: Information TechnologyChapter Obj.: Learn how to create database designs in the MySQL WorkbenchClassification: Concept67)The SQL query data results are displayed ________.A) in the Navigator windowB) in a tabbed Result GridC) in a Messages windowD) in a tabbed Action Output windowAnswer: DDiff: 3Page Ref:A-41AACSB: Information TechnologyChapter Obj.: Learn how to create database designs in the MySQL WorkbenchClassification: Concept68) When importing data from Excel, what SQL statement is needed to add constraints to yournewly created tables?A) SQL ALTER TABLEB) SQL CHANGE TABLEC) SQL ADD CONSTRAINTD) SQLADD ALLE) SQL OPEN TABLEAnswer: ADiff: 2Page Ref:A-39AACSB: Information TechnologyChapter Obj.: Learn how to import Microsoft Excel worksheet data into a databaseClassification: Concept69) MySQL Community Server requires the prior installation of ________.A) the .NET Framework version 3.0B) the.NET Framework version 3.5C) the .NET Framework version 3.5 SP1D) the .NET Framework version 4.5.1E) None of the above—the .NET Framework is not required.Answer: BDiff: 2Page Ref:A-5AACSB: Information TechnologyChapter Obj.: Learn how to install MySQL Community Server 8.0Classification: Concept

Loading page image...

1570) The E-R diagrams created in the MySQL Workbench use ________.A) IE Crow's Foot notationB) IDEF1X notationC) UML notationD) Microsoft Visio 2010 Arrow notationE) None of the above is correct.Answer: ADiff: 2Page Ref:A-73AACSB: Information TechnologyChapter Obj.: Learn how to install MySQL Community Server 8.0Classification: Concept71) The MySQL GUI tool is replaced by________.A) MySQL Query BrowserB) MySQL AdministratorC)My SQL WorkbenchD) MySQL for ExcelE) MySQL for AccessAnswer: CDiff: 2Page Ref:A-2AACSB: Information TechnologyChapter Obj.:Learn how to install MySQL WorkbenchClassification: Concept72) To run an SQL script or SQL command in MySQL ServerCommunity Edition ________.A) click the Execute button on the Query ToolbarB) click the Execute button on the Browser ToolbarC) clickthe Run button on the Query ToolbarD) click the Run button on the Browser ToolbarE) click the Execute SQL Script button on the ToolbarAnswer: EDiff: 2Page Ref:A-40AACSB: Information TechnologyChapter Obj.: Learn how to submit SQL commands to query a databaseClassification: Concept

Preview Mode

This document has 221 pages. Sign in to access the full document!

Report

Study Now!

Document Details

Related Documents

DevOps and Its Importance Study Notes

Veeam Certified Engineer VMCE-V12

Modules 1 - 3 Basic Network Connectivity and Commu

Notes CCNA

CCNA 200-301 Portable Command Guide 5th Edition 20

CCNA 200-301 Portable Command Guide 5th Edition 22

CCNA 200-301 Portable Command Guide 5th Edition 36

Foundations of Novell Networking Section 26

Modulo 7 DHCPv4

Build and troubleshooting Integration Challenge

Company

Explore

Study Tools