Database Concepts 6th Edition By kroenke – Test Bank

 

 

To Purchase this Complete Test Bank with Answers Click the link Below

 

https://tbzuiqe.com/product/database-concepts-6th-edition-by-kroenke-test-bank/

 

If face any problem or Further information contact us At tbzuiqe@gmail.com

 

Sample Test

Database Concepts, 6e (Kroenke/Auer)

Appendix C  MySQL 5.5 Community Server Edition

 

1) MySQL Community Server 5.5 requires that the .NET Framework version 2.0 be installed.

Answer:  FALSE

Diff: 1      Page Ref: C-4

 

2) The MySQL Workbench is included in the MySQL Community Server 5.5 installation when the MySQL Installer for Windows is used.

Answer:  TRUE

Diff: 1      Page Ref: C-5

 

3) An important reason for using MySQL Community Server 5.5 is that it has full SQL capabilities.

Answer:  TRUE

Diff: 1      Page Ref: C-4

 

4) To start working with MySQL Server Community Edition, use the command Start | All Programs | MySQL | MySQL Workbench 5.2 CE.

Answer:  TRUE

Diff: 1      Page Ref: C-6

 

5) Users log into MySQL Community Server 5.5 using the Connect to MySQL Server dialog box.

Answer:  TRUE

Diff: 1      Page Ref: C-8

 

6) MySQL Community Server 5.5 uses DBMS authentication.

Answer:  TRUE

Diff: 1      Page Ref: C-8

 

7) Database objects are displayed in the Object Browser window in the MySQL Workbench.

Answer:  TRUE

Diff: 2      Page Ref: C-9

 

8) A new MySQL database is created using the New Database dialog box.

Answer:  FALSE

Diff: 2      Page Ref: C-9-C-10

 

9) SQL statements can be run individually or as part of a related group of SQL statements known as a script.

Answer:  TRUE

Diff: 1      Page Ref: C-12

 

10) To run an SQL script, click the Execute button on the Query Toolbar.

Answer:  FALSE

Diff: 2      Page Ref: C-15 Fig C-14

 

11) To create a new SQL query, click the New Query button.

Answer:  FALSE

Diff: 1      Page Ref: C-18-C-19

12) SQL query results are displayed in a tabbed results window.

Answer:  TRUE

Diff: 1      Page Ref: C-19

 

13) MySQL Community Server 5.5 requires the prior installation of:

1.    A) the .NET Framework version 1.0.

2.    B) the .NET Framework version 2.0.

3.    C) the .NET Framework version 3.0.

4.    D) the .NET Framework version 3.5 SP1.

5.    E) None of the above – the .NET Framework is not required.

Answer:  E

Diff: 2      Page Ref: C-5

 

14) The MySQL GUI tool is:

1.    A) MySQL Query Browser.

2.    B) MySQL Administrator.

3.    C) My SQL Workbench.

4.    D) Both A and B

5.    E) All of the above

Answer:  C

Diff: 2      Page Ref: C-5-C-6

 

15) Logging into the MySQL Community Server 5.5 DBMS is done using:

1.    A) the Connect to Server command.

2.    B) the Connect to Server dialog box.

3.    C) the Connect to MySQL Server command.

4.    D) the Connect to MySQL Server dialog box.

5.    E) None of the above is correct.

Answer:  D

Diff: 2      Page Ref: C-8

 

16) DBMS objects are displayed:

1.    A) in the Navigation Pane.

2.    B) in the Object Browser.

3.    C) in the tabbed database window.

4.    D) in the tabbed document window.

5.    E) in the command tab.

Answer:  B

Diff: 2      Page Ref: C-9

 

 

17) A new MySQL database is created using:

1.    A) the new _database dialog box.

2.    B) the Create Database command.

3.    C) the new _schema dialog box.

4.    D) the Create Schema command.

5.    E) the New Object dialog box.

Answer:  C

Diff: 2      Page Ref: C-10-C-12

18) SQL statements can be run individually or as part of a related group of SQL statements known as a(n):

1.    A) Result.

2.    B) Resultset.

3.    C) Script.

4.    D) Scriptset.

5.    E) Commandset.

Answer:  C

Diff: 1      Page Ref: C-12

 

19) To run an SQL script or SQL command in MySQL Server Community Edition:

1.    A) click the Execute button on the Query Toolbar.

2.    B) click the Execute button on the Browser Toolbar.

3.    C) click the Run button on the Query Toolbar.

4.    D) click the Run button on the Browser Toolbar.

5.    E) click the Execute SQL Script button on the Toolbar.

Answer:  E

Diff: 2      Page Ref: C-16

 

20) SQL query results are displayed:

1.    A) in a tabbed results window.

2.    B) in a tabbed Results1 window.

3.    C) in a tabbed Document window.

4.    D) in a tabbed Messages window.

5.    E) in a tabbed Finished window.

Answer:  A

Diff: 2      Page Ref: C-19

 

21) To access documentation about the MySQL Workbench, use the:

1.    A) Help | MySQL Workbench command.

2.    B) Help | Help Index command.

3.    C) Help | MySQL Website command.

4.    D) Help | MySQL.com Website command.

5.    E) Help | Documentation command.

Answer:  B

Diff: 2      Page Ref: C-19

 

 

22) To access documentation at the MySQL Web site, use the:

1.    A) Help | MySQL Workbench command.

2.    B) Help | Help Index command.

3.    C) Help | MySQL Website command.

4.    D) Help | MySQL.com Website command.

5.    E) Help | Documentation command.

Answer:  D

Diff: 2      Page Ref: C-19

23) The MySQL Workbench can be used to create:

1.    A) Data models.

2.    B) Data designs.

3.    C) Database models.

4.    D) Database designs.

5.    E) Database diagrams.

Answer:  D

Diff: 1      Page Ref: C-21

 

24) By default, the E-R diagrams created in the MySQL Workbench use:

1.    A) IE Crow’s Foot notation.

2.    B) IDEF1X notation.

3.    C) UML notation.

4.    D) Microsoft Visio 2010 Arrow notation.

5.    E) None of the above is correct.

Answer:  A

Diff: 2      Page Ref: C-29

 

25) MySQL ________ Community Server Edition was generally available when this text was written.

Answer:  5.5

Diff: 1      Page Ref: C-5

 

26) MySQL Workbench version ________ was generally available when this text was written.

Answer:  5.2.40

Diff: 1      Page Ref: C-5

 

27) In addition to downloading MySQL Community Server and the MySQL Workbench, it is recommended that the ________ also be downloaded.

Answer:  MySQL Connector/ODBC

Diff: 1      Page Ref: C-5

 

28) Downloading and installing the MySQL connector/ODBC means that the ________ driver will be available in the ODBC Data Source Administrator.

Answer:  MySQL ODBC 5.1

Diff: 2      Page Ref: C-20

 

 

29) An important reason for using MySQL 5.5 Community Server Edition is that it has ________.

Answer:  full SQL capabilities

Diff: 1      Page Ref: C-4

 

30) Users log into MySQL 5.5 Community Server Edition using the ________ dialog box.

Answer:  Connect to MySQL Server

Diff: 2      Page Ref: C-8

 

31) MySQL 5.5 Server Community Edition uses ________ authentication.

Answer:  DBMS

Diff: 2      Page Ref: C-6

32) Database objects are displayed in the ________ window in the MySQL Workbench.

Answer:  Object Browser

Diff: 2      Page Ref: C-8-C-9

 

33) A new MySQL Server database is know as a new ________.

Answer:  schema

Diff: 2      Page Ref: C-7-C-8

 

34) SQL statements can be run individually or as part of a related group of SQL statements known as a(n) ________.

Answer:  script

Diff: 1      Page Ref: C-12

 

35) To run an SQL script, click the ________ button on the MySQL Workbench toolbar.

Answer:  Execute SQL Script

Diff: 1      Page Ref: C-16

 

36) To create a new MySQL query, use the ________ command.

Answer:  File | Open SQL Script

Diff: 2      Page Ref: C-16

 

37) SQL query results are displayed in a tabbed ________ window.

Answer:  results

Diff: 1      Page Ref: C-18-C-19

 

38) The MySQL Workbench ERR diagrams are actually ________ E-R diagrams.

Answer:  database design

Diff: 2      Page Ref: C-20

 

 

39) Describe how to create a new database in MySQL 5.5 Community Server Edition.

Answer:  In MySQL 5.5 Community Server Edition, new databases are created in the MySQL Workbench. Click the Create a new schema in the connected server button in the Object Browser. The new _schema tabbed window is displayed. Enter the database name and click the Apply button. The Apply SQL Script to Database dialog box is displayed. Click the Apply SQL button and then, after the SQL script has run, click the Finish button. In the new_schema tabbed window, click the Close button. The new schema appears in the Object Browser.

Diff: 2      Page Ref: C-10-C-12

 

40) What is an SQL script, and why are SQL scripts useful?

Answer:  An SQL Script is a group of SQL statements that are run consecutively. Each of the SQL statements in the script could be run separately, but running them as a group is more efficient, and this is what makes SQL scripts useful. A good example is grouping all the SQL CREATE TABLE statements necessary to build a database structure into a single SQL script.

Diff: 2      Page Ref: C-12

41) Describe how to create and run an SQL script in MySQL 5.5 Community Server Edition.

Answer:  SQL scripts are created in a text editor and saved with an *.sql file extension. While a text editor, such as Microsoft Notepad, can be used, the most efficient editor for MySQL 5.5 Community Server Edition is the text editor built into the MySQL Workbench. In the MySQL Workbench, the SQL script text is edited, and then saved as an *.sql file. The “Execute SQL Script ” button is used to run the SQL script.

Diff: 2      Page Ref: C-12

 

42) Describe how to create and run an SQL query in MySQL 5.5 Community Server Edition.

Answer:  In MySQL 5.5 Community Server Edition, SQL queries are created and run in the MySQL Workbench. Use the File | New Query Tab command to open a new tabbed SQL Query window . Type the SQL query into the SQL Query text area , and then click the “Execute SQL Script” button on the MySQL Workbench toolbar to run the query. Results are displayed in the tabbed results window.

Diff: 2      Page Ref: C-18-C-19

 

43) Describe the MySQL Connector/ODBC and how to install it.

Answer:  The MySQL Connector/ODBC is a downloadable utility that provides the MySQL ODBC 5.1 driver. To install it, download it from the MySQL development Web site, and run the installation. After the installation, the MySQL ODBC 5.1 driver will appear in the ODBC Data Source Administrator. If using the Windows operating system, install it using the MySQL Installer for Windows only.

Diff: 2      Page Ref: C-20

 

Database Concepts, 6e (Kroenke/Auer)

Appendix E  SQL Views

 

1) An SQL virtual table is called a view.

Answer:  TRUE

Diff: 1      Page Ref: E-4

 

2) SQL views contain their own data.

Answer:  FALSE

Diff: 2      Page Ref: E-4

 

3) SQL views are constructed from SELECT statements.

Answer:  TRUE

Diff: 2      Page Ref: E-4

 

4) SQL statements used to construct views cannot contain the WHERE clause.

Answer:  FALSE

Diff: 2      Page Ref: E-4

 

5) The SQL command CREATE VIEW is used to create view structures.

Answer:  TRUE

Diff: 2      Page Ref: E-4

 

6) The SQL command SELECT is used to retrieve view instances.

Answer:  TRUE

Diff: 1      Page Ref: E-6

 

7) The SQL keyword ORDER BY can be used with SELECT statements that are retrieving view instances to sort the results of the SELECT.

Answer:  TRUE

Diff: 2      Page Ref: E-6

 

8) When an SQL SELECT statement is used to retrieve a view instance, the maximum number of columns that can be specified in the SELECT is the same as the number of columns in the table underlying the view.

Answer:  FALSE

Diff: 3      Page Ref: E6-E-8