Exam 3: Creating Tables

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

The data type DECIMAL(5,2)represents a number with ____________________ places to the left and two places to the right of the decimal.​

You can use the ____________________ data type to store date data.​

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

In SQL Server,execute the sp_columns command to list all the columns in a table.

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.​

The data type DECIMAL(5,2)represents a number with three places to the left and two places to the right of the decimal.​

Access does not use script files.

In Oracle,what is the script repository?​

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

The Oracle Database 11 g Express edition allows you to save a command so you can use it again without retyping it.​

In SQL,you cannot enter an apostrophe into a column whose type is character (CHAR).

The ____________________ command adds rows to a table.​

In Oracle,use the ____________________ command to list all columns in a table and their properties.​

Access does not support the ____ data type.​

In Access,use the Documenter tool to describe the tables in a database.​

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

The ____ data type is used to store integers.​

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

If you need to delete a row from a table,you can use the ____________________ command.​