Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Chapter 3 SQL

memorize.ai (lvl 286)

(0)

50 cards

()

Section 1

Preview this deck

\.

Front

1 / 50

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (50)

Section 1

(50 cards)

\.

Front

To run a script file, type either SOURCE or ____________________ followed by the name of the file.

Back

asterisk

Front

To display all the rows and columns in a table, type the word SELECT, followed by a(n) ____, followed by the word FROM and then the name of the table containing the data you want to view.

Back

True

Front

In MySQL, you can display the data vertically rather than horizontally.

Back

create table

Front

The ____ command defines a table's structure by listing its columns, data types, and column lengths

Back

False

Front

To enter a null value into a table, you use a special format of the NULL command

Back

semicolon

Front

You indicate the end of a command by typing a(n) ____.

Back

\h

Front

The simplest way to obtain help in MySQL is to type ____ at the mysql> prompt.

Back

statement history

Front

In MySQL, the most recent command entered is stored in a special area of memory called the ____.

Back

single quotation marks

Front

For any column whose data type is CHAR, values must be enclosed in ____.

Back

False

Front

In SQL, there are special rules that specify that a particular word must begin in a particular position on the line.

Back

update

Front

Which of the following commands changes the value in a column?

Back

update

Front

You can use the ____________________ command to update a value in a table.

Back

query

Front

SQL is Structured ____________________ Language.

Back

int

Front

The ____ data type is used to store integers.

Back

not null

Front

To indicate columns that cannot contain null values, use the ____________________ clause in a CREATE TABLE statement.

Back

CTRL + A

Front

In MySQL, to move to the beginning of the current line, you need to press the ____ key(s).

Back

auto_increment

Front

If the word ____________________ follows the word INT, a column is created for which MySQL will automatically generate a new sequence number each time a new row is added.

Back

prompt

Front

In MySQL, you type commands at the mysql> ____.`

Back

decimal

Front

The correct data type for the BALANCE column in the CUSTOMER table is ____.

Back

18

Front

In MySQL, table names cannot exceed ____ characters.

Back

create database

Front

To create a new database, execute the ____________________ command.

Back

varchar

Front

The ____ data type stores only the actual character string.

Back

command line

Front

The mysql prompt displays in the ____ Client window.

Back

sequel

Front

What is the original name of SQL?

Back

.txt

Front

Script files must have a ____________________ file name extension.

Back

1970's

Front

SQL was developed in the mid-____.

Back

use

Front

The ____ command activates the default database.

Back

up arrow

Front

To move up a line in the statement history, use the ____________________ key(s).

Back

notepad

Front

____ is an example of a text editor.

Back

TBL_1

Front

Which of the following is a valid name for a table?

Back

YYYY-MM-DD

Front

In MySQL, dates have the form ____.

Back

semicolon

Front

When a script file contains more than one command, each command must end with a ____.

Back

True

Front

In SQL, you use the NOT NULL clause in a CREATE TABLE command to indicate columns that cannot contain null values.

Back

select

Front

To view the data in a table, you use the ____________________ command.

Back

True

Front

The CREATE DATABASE command is executed only once for a database.

Back

show columns

Front

To examine the structure of a table, use the ____________________ command.

Back

True

Front

The shortcut command to quit MySQL is \q.

Back

\G

Front

To display data vertically rather than horizontally, replace the semicolon at the end of the command with ____.

Back

insert

Front

The ____________________ command adds rows to a table.

Back

Backspace

Front

In MySQL, to delete the previous character, you need to press the ____ key(s).

Back

create table

Front

You use the ____________________ command to describe the layout of a table.

Back

script

Front

A file containing SQL commands is called a ____________________ file.

Back

use

Front

In MySQL, you use the ____________________ command to change the database to the one you want to use.

Back

False

Front

If you added a row that should not be in a table, use a REMOVE command to remove it.

Back

CTRL + E

Front

In MySQL, to move to the end of a line, you need to press the ____ key(s).

Back

False

Front

In MySQL, the data type STRING(n) stores a character string n characters long.

Back

help union

Front

To get more information about the union command, type ____________________ at the command prompt.

Back

False

Front

When adding rows to character columns, make sure you enclose the values in double quotation marks.

Back

False

Front

To edit an SQL command, type EDIT at the mysql prompt..

Back

drop

Front

You can delete the entire table using the ____________________ TABLE command.

Back