DDL commands

The _____ command is used to modify columns in a table

• DROP

• INSERT

• ALTER

• CREATE

To build a new table from scratch, use the _____ command.

• INSERT

• ALTER

• CREATE

• DROP

The _____ command is used to completely remove a table from the database.

• INSERT

• ALTER

• DROP

• CREATE

This command creates the new MySQL database.

• new database database_name

• create database database_name

• create database_name

• create table_name

Data Definition Language commands are used to modify the _____ of a database.

• data

• security

• users

• structure

Which of these is the best definition of a database?

• Columns and rows that contain data in records

• Primary and foreign keys that help tables relate to one another

• a structured collection of data in tables

• A large table of information

Which SQL statement would return ALL records from the artist table?

• SELECT *.*

• SELECT artistName FROM tblArtist WHERE artistName='Journey'

• SELECT * FROM tblArtist

• SELECT * FROM tblArtist WHERE artistID = 17