Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Chapter 6 MySQL

memorize.ai (lvl 286)

(0)

50 cards

()

Section 1

Preview this deck

create table

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

4 years ago

Date created

Mar 14, 2020

Cards (50)

Section 1

(50 cards)

create table

Front

You can use the ____ command to create a new table using data in an existing table.

Back

order by

Front

To sort rows in a specific order, use the ______ clause with the desired sort key(s).

Back

modify

Front

You can change the characteristics of existing columns by using the __ clause of the ALTER TABLE command

Back

show columns

Front

In MySQL, use the ___ command to show the layout of a table.

Back

commit

Front

During your current work session you can save your changes immediately by executing the _______ command.

Back

False

Front

When you use the CREATE TABLE command with the word LIKE to create a new table from an existing table, the new table has the same data as the original table

Back

False

Front

In a transaction, it is acceptable if some steps fail

Back

delete

Front

To delete data from the database, use the ____ command.

Back

False

Front

You can increase the length of a column but you cannot decrease the length of a column

Back

column

Front

The ADD clause consists of the word ADD followed by the name of the ___ to be added, followed by the characteristics.

Back

set

Front

The UPDATE command contains the word ____, followed by the name of the column to be updated, an equals sign, and the new value.

Back

delete

Front

You use the ____ command to remove rows from a table.

Back

commit

Front

The ____ command is permanent.

Back

False

Front

When necessary, include a WHERE clause into the UPDATE command to indicate the column on which the change is to take place.

Back

not null

Front

If you specified ___ for the column when you created the table, then changing a value in a column to null is prohibited.

Back

0

Front

In order to use the COMMIT command in MySQL, you need to change the value for AUTOCOMMIT to ____.

Back

True

Front

The data stored in tables is subject to constant change.

Back

transaction

Front

A(n) ________ is a logical unit of work.

Back

varchar

Front

In MySQL, use the ____ data type for variable-length character columns.

Back

rollback

Front

In a transaction, if any update cannot be completed, execute the __ command and discontinue the updates for the current transaction.

Back

False

Front

The DROP TABLE command creates an empty table

Back

all rows will be deleted from the table

Front

What happens if you run a DELETE command that does not contain a WHERE clause?

Back

autocommit

Front

In order to use the ROLLBACK commands in MySQL, you need to change the value for ____ to 0.

Back

rollback

Front

If you decide that you do not want to save the changes you have made during your current work session, you can reverse the changes by executing the _____ command.

Back

like

Front

The command CREATE TABLE LEVEL1_CUSTOMER ____ CUSTOMER; creates a new table from an existing table.

Back

where

Front

To make the same update for all rows in a table, omit the ____ clause.

Back

commit

Front

Before beginning the updates for a transaction, commit any previous updates by executing the_____ command.

Back

show columns

Front

In MySQL, use the ____ command to show the layout of a table.

Back

rollback;

Front

Which of the following commands executes a rollback?

Back

data

Front

The ROLLBACK command reverses changes made to the _____ only.

Back

table

Front

The format for the ALTER TABLE command is the words ALTER TABLE followed by the name of the _____ to be altered, followed by an appropriate clause.

Back

False

Front

The NULL value should be enclosed in single quotation marks

Back

False

Front

To verify that the correct change was made to data in a table, use the DISPLAY command

Back

show columns

Front

In MySQL, use the ____ command to show the revised structure of a table.

Back

transaction

Front

A(n) ____ can be viewed as a sequence of steps that accomplishes a single task.

Back

rollback

Front

If you have not run the COMMIT command, executing the ____ command will reverse all updates made during the current work session.

Back

commit

Front

If you have verified that the update you made is correct, you can use the ____ command to make the update permanent.

Back

modify

Front

You can use the ____ clause of the ALTER TABLE command to change a column that currently rejects null values so that it will accept null values.

Back

not null

Front

If you specified ____ for a column when you created a table, then changing a value in a column to null is prohibited.

Back

modify

Front

To change a column that currently rejects null values so that it accepts null values, use the ____ clause of the ALTER TABLE command

Back

select

Front

By placing a(n) _____ command in an INSERT command, you can add the query results to a table.

Back

True

Front

If you specify NOT NULL for a column when you create a table, you are prohibited from changing a value in the column to null.

Back

drop table

Front

You can use the ____ command to delete an entire table and its data.

Back

commit;

Front

Which of the following is a valid SQL command?

Back

drop

Front

You can delete a table that is no longer needed by using the ___ TABLE command.

Back

commit

Front

In a transaction, if you can complete all updates successfully, execute the ______ command after completing the final update.

Back

True

Front

It is possible to use calculations to update a value in a column.

Back

add

Front

To add a new column, use the _____ clause of the ALTER TABLE command.

Back

drop table level1_customer:

Front

Which of the following is a valid SQL command?

Back

alter table

Front

With SQL, you can change a table's structure by using the _______ command.

Back