Question 1

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

Accepted Answer

The answer of SQL statements can be run individually or...

Question 2

The MySQL Workbench EER diagrams are actually ________ E-R diagrams.

Accepted Answer

The answer of The MySQL Workbench EER diagrams are actually...

Question 3

Logging into the MySQL Community Server 5.6 DBMS is done using:

Accepted Answer

A) the Connect 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. 
A) the Connect 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.

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

The answer of Database objects are displayed in the ________...

Question 6

In order to use MySQL Workbench to create database designs,you must log into MySQL using:

Accepted Answer

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. 
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.

Question 7

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

Accepted Answer

The answer of Downloading and installing the MySQL connector/ODBC means...

Question 8

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

Accepted Answer

MySQL Conn

Question 9

An important reason for using MySQL 5.6 Community Server Edition is that it has ________.

Accepted Answer

full SQL c

Question 10

In the MySQL Table Editor,the abbreviation NN stands for NOT NULL.

Accepted Answer

A) True 
 B)False

Question 11

To place a table in a MySQL database design,start by clicking the:

Accepted Answer

A) Table button. 
B) Entity button. 
C) Place a New Table button. 
D) Place a New Entity button. 
E) None of the above 
A) Table button. 
B) Entity button. 
C) Place a New Table button. 
D) Place a New Entity button. 
E) None of the above

Question 12

In the MySQL Workbench,a 1:N identifying relationship between two tables that do not contain the needed primary and foreign keys is created using:

Accepted Answer

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 Columns button. 
E) None of the above is correct. 
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 Columns button. 
E) None of the above is correct.

Question 13

Describe how to create and run an SQL script in MySQL 5.6 Community Server Edition.

Accepted Answer

SQL scripts are created in a text editor

Question 14

To create a new MySQL Workbench EER model,you can use:

Accepted Answer

A) the New Model button on the Home page. 
B) the File | New Model command. 
C) the Start new EER command. 
D) A or B 
E) All of the above 
A) the New Model button on the Home page. 
B) the File | New Model command. 
C) the Start new EER command. 
D) A or B 
E) All of the above

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

The MySQL Workbench can be used to create:

Accepted Answer

A) data models. 
B) data designs. 
C) database models. 
D) database designs. 
E) database diagrams. 
A) data models. 
B) data designs. 
C) database models. 
D) database designs. 
E) database diagrams.

Question 17

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:

Accepted Answer

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 Columns button. 
E) None of the above is correct. 
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 Columns button. 
E) None of the above is correct.

Question 18

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

Accepted Answer

An SQL Script is a group of SQL statemen

Question 19

DBMS objects are displayed:

Accepted Answer

A) in the Navigator Pane. 
B) in the Object Browser. 
C) in the tabbed database window. 
D) in the tabbed document window. 
E) in the command tab. 
A) in the Navigator Pane. 
B) in the Object Browser. 
C) in the tabbed database window. 
D) in the tabbed document window. 
E) in the command tab.

Question 20

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

Accepted Answer

The MySQL Connector/ODBC is a downloadab

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

The MySQL Workbench EER diagrams are actually ________ E-R diagrams.

Logging into the MySQL Community Server 5.6 DBMS is done using:

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

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

In order to use MySQL Workbench to create database designs,you must log into MySQL using:

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

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

An important reason for using MySQL 5.6 Community Server Edition is that it has ________.

In the MySQL Table Editor,the abbreviation NN stands for NOT NULL.

To place a table in a MySQL database design,start by clicking the:

In the MySQL Workbench,a 1:N identifying relationship between two tables that do not contain the needed primary and foreign keys is created using:

Describe how to create and run an SQL script in MySQL 5.6 Community Server Edition.

To create a new MySQL Workbench EER model,you can use:

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

The MySQL Workbench can be used to create:

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:

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

DBMS objects are displayed:

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

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

Exam 11: Getting Started With Mysql 5.6 Community Server

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

The MySQL Workbench EER diagrams are actually ________ E-R diagrams.

Logging into the MySQL Community Server 5.6 DBMS is done using:

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

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

In order to use MySQL Workbench to create database designs,you must log into MySQL using:

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

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

An important reason for using MySQL 5.6 Community Server Edition is that it has ________.

In the MySQL Table Editor,the abbreviation NN stands for NOT NULL.

To place a table in a MySQL database design,start by clicking the:

In the MySQL Workbench,a 1:N identifying relationship between two tables that do not contain the needed primary and foreign keys is created using:

Describe how to create and run an SQL script in MySQL 5.6 Community Server Edition.

To create a new MySQL Workbench EER model,you can use:

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

The MySQL Workbench can be used to create:

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:

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

DBMS objects are displayed:

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

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters