Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Murach MySQL Chapter 2

memorize.ai (lvl 286)

(0)

14 cards

()

Section 1

Preview this deck

When you have access to a table through MySQL Workbench, you can view both the column definitions for the table and the ___________________ in the table.

Front

1 / 14

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

7 years ago

Date created

Mar 1, 2020

Cards (14)

Section 1

(14 cards)

When you have access to a table through MySQL Workbench, you can view both the column definitions for the table and the ___________________ in the table.

Front

Data

Back

Which of the following is not true when you're using MySQL Workbench to test a script that contains more than one SQL statement?

Front

You cannot run all of the statements in the script at once.

Back

You can use the SQL Editor tab to enter and ______________________ one or more SQL statements.

Front

execute

Back

Which of the following is not a common error when entering and executing SQL statements?

Front

Forgetting to connect to a database

Back

______________________ is a command-line tool that you can use for running SQL statements.

Front

MYSQL Command line client

Back

To save your own code in MySQL Workbench so that you do not have to type it each time, you can create a new ___________________.

Front

snippet

Back

The MySQL Reference Manual can be found at the ______________ web site.

Front

MYSQL

Back

The database server can also be referred to as the database_________.

Front

Engine

Back

When you run a SQL statement that contains a coding error, MySQL Workbench displays an error message that does not include

Front

the likely cause of the error

Back

In a SQL Editor tab of MySQL Workbench, you can do all but one of the following. Which one is it?

Front

create a database diagram

Back

Before you can use MySQL Workbench to work with a SQL database, you need to open a __________________ to the database.

Front

connection

Back

A SQL script is a file that contains one or more ______________.

Front

SQL Statements

Back

In MySQL Workbench, you can start or stop the MySQL database server by clicking the Start Server button in the ________________window.

Front

navigator

Back

Each database includes tables, views, and routines. These are called database ___________.

Front

objects

Back