Question 1

To create a MySQL index using SQL,the correct SQL statement is ________.

Accepted Answer

A) ALTER TABLE {TableName} ADD INDEX {IndexName} 
B) ALTER TABLE {TableName} INSERT INDEX {IndexName} 
C) CREATE INDEX {IndexName} ON TABLE {TableName} 
D) Both A and C are correct 
A) ALTER TABLE {TableName} ADD INDEX {IndexName} 
B) ALTER TABLE {TableName} INSERT INDEX {IndexName} 
C) CREATE INDEX {IndexName} ON TABLE {TableName} 
D) Both A and C are correct

Question 2

Schema is the MySQL synonym for database.

Accepted Answer

A) True 
 B)False

Question 3

The MySQL keyword used to retrieve a row of data while the cursor is operating is ________.

Accepted Answer

A) DECLARE CURSOR {CursorName} 
B) OPEN {CursorName} 
C) FETCH 
D) CLOSE {CursorName} 
A) DECLARE CURSOR {CursorName} 
B) OPEN {CursorName} 
C) FETCH 
D) CLOSE {CursorName}

Question 4

Which of the following MySQL configuration settings are recommended for use with this book?

Accepted Answer

A) Developer machine 
B) Multifunction machine 
C) Decision Support (DSS)/OLAP 
D) Custom setup that only installs the needed components 
A) Developer machine 
B) Multifunction machine 
C) Decision Support (DSS)/OLAP 
D) Custom setup that only installs the needed components

Question 5

What is the MySQL Command-Line Client?

Accepted Answer

The MySQL Command-Line Client is a chara

Question 6

The MySQL command line utility is ________.

Accepted Answer

A) MySQL*Plus 
B) the MySQL Command-Line Client 
C) MySQL-Shell 
D) MySQL-CMD 
A) MySQL*Plus 
B) the MySQL Command-Line Client 
C) MySQL-Shell 
D) MySQL-CMD

Question 7

MySQL uses the MySQL LAST_INSERT_ID()function to provide the value of the most recently created surrogate key.

Accepted Answer

A) True 
 B)False

Question 8

MySQL users are granted MySQL privileges for specific schemas only.

Accepted Answer

A) True 
 B)False

Question 9

The MySQL keyword to create a cursor is ________.

Accepted Answer

A) DECLARE CURSOR {CursorName} 
B) OPEN {CursorName} 
C) FETCH 
D) CLOSE {CursorName} 
A) DECLARE CURSOR {CursorName} 
B) OPEN {CursorName} 
C) FETCH 
D) CLOSE {CursorName}

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

To start working with MySQL Community Edition in Windows,use the command Start | All Programs | MySQL | MySQL Workbench CE 6.2.(or the version number you have installed).

Accepted Answer

A) True 
 B)False

Question 12

The MySQL Installer for Windows requires the ________ operating system.

Accepted Answer

A) Suse Linux 
B) Red Hat Linux 
C) Android 
D) Microsoft Windows 
A) Suse Linux 
B) Red Hat Linux 
C) Android 
D) Microsoft Windows

Question 13

MySQL supports AFTER triggers.

Accepted Answer

A) True 
 B)False

Question 14

Which trigger type(s)does MySQL support?

Accepted Answer

A) BEFORE 
B) AFTER 
C) INSTEAD OF 
D) Both A and B are correct 
A) BEFORE 
B) AFTER 
C) INSTEAD OF 
D) Both A and B are correct

Question 15

The MySQL Command Line Client is the MySQL command line utility.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following statements is not true concerning the MySQL for Excel Add-In?

Accepted Answer

A) It must be installed into MySQL before importing from Excel can be performed. 
B) The user must enter a password to connect to the MySQL instance. 
C) The data must first be normalized before importing. 
D) The user can modify some of the table characteristics before the actual data transfer. 
A) It must be installed into MySQL before importing from Excel can be performed. 
B) The user must enter a password to connect to the MySQL instance. 
C) The data must first be normalized before importing. 
D) The user can modify some of the table characteristics before the actual data transfer.

Question 17

Microsoft Windows users should install MySQL Community Edition using the MySQL Installer for Windows.

Accepted Answer

A) True 
 B)False

Question 18

What is MySQL?

Accepted Answer

MySQL is an open source DBMS that runs o

Question 19

MySQL uses the MySQL TODAYS_DATE()function to provide the value of the current date.

Accepted Answer

A) True 
 B)False

Question 20

What term does MySQL use as a synonym for backup?

Accepted Answer

A) Replica 
B) Export 
C) Data export 
D) Data export dump 
A) Replica 
B) Export 
C) Data export 
D) Data export dump

Exam 12: Managing Databases With Mysql 5.6

To create a MySQL index using SQL,the correct SQL statement is ________.

Schema is the MySQL synonym for database.

The MySQL keyword used to retrieve a row of data while the cursor is operating is ________.

Which of the following MySQL configuration settings are recommended for use with this book?

What is the MySQL Command-Line Client?

The MySQL command line utility is ________.

MySQL uses the MySQL LAST_INSERT_ID()function to provide the value of the most recently created surrogate key.

MySQL users are granted MySQL privileges for specific schemas only.

The MySQL keyword to create a cursor is ________.

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

To start working with MySQL Community Edition in Windows,use the command Start | All Programs | MySQL | MySQL Workbench CE 6.2.(or the version number you have installed).

The MySQL Installer for Windows requires the ________ operating system.

MySQL supports AFTER triggers.

Which trigger type(s)does MySQL support?

The MySQL Command Line Client is the MySQL command line utility.

Which of the following statements is not true concerning the MySQL for Excel Add-In?

Microsoft Windows users should install MySQL Community Edition using the MySQL Installer for Windows.

What is MySQL?

MySQL uses the MySQL TODAYS_DATE()function to provide the value of the current date.

What term does MySQL use as a synonym for backup?

Introduction

Introduction to Structured Query Language

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2014

Managing Databases With Oracle Database

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the IDEF1X Standard

E-R Diagrams and the UML Standard

Getting Started With Mysql Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers, PHP, and the Netbeans IDE

Business Intelligence Systems

Big Data

Filters