Exam 3: An Introduction to SQL

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

The ____ command activates the default database.

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

Should a user be allowed to enter null values for the primary key?

To create a new database, execute the ____________________ command.

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

When you enter a new row into a table or modify an existing row, the values for one or more columns can be unknown or unavailable.

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

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

What is the original name of SQL?

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.

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

The mysql prompt displays in the ____ Client window.

____ is an example of a text editor.

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

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

Table names cannot contain spaces.

SQL was developed as the data manipulation language for IBM's prototype relational model DBMS, System R.

To create a table, type the word TABLE followed by the name of the table to be created and then by the names and data types of the columns that will comprise the table.

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