Oracle 12c: SQL - Chapter 3

A table name must begin with a(n) *number*.

When a column is deleted, the deletion is permanent.

An automatic column will generate a value at runtime and may reference values from other columns.

The INTERVAL datatype can be used to identify a specific interval, or amount, of time.

*DDL* commands are used to create or modify database objects.

The DELETE TABLE command can be used to remove a table from a database.

Every table name within a specific schema must be unique.

A table name can consist of numbers, letters, and blank spaces.

The *MODIFY* clause can be included in the ALTER TABLE command to add a default value to an existing column.

You cannot specify the width for a(n) *NUMBER* column.

The data contained in a dropped table can be retrieved if the *DROP* option was not used in the DROP TABLE command.

The ALPHANUMERIC datatype can be used to store characters and numbers to a maximum width of 2000.

Once a column as been set as *UNUSED*, it cannot be recovered.

The width of a NUMBER column cannot be *changed* once it contains data.

The *scale* of a NUMBER column indicates the total number of digits that can be stored in the column.

The default size of the CHAR column is *2*.

SELECT9 *is* a valid table name.

You cannot delete the last column in a table.

The CREATE TABLE cannot contain a subquery.

More than one column can be changed at a time with the *ALTER TABLE...MODIFY* command.

Only one column can be added to an existing table at one time.

The syntax of the *CREATE TABLE* command requires that the column list be enclosed in parentheses.

A database must be shut down before the ALTER TABLE command can be executed.

A column name can consist of up to 225 characters.

The DELETE TABLE command can be used to delete all the data stored in a table and release the storage space, yet retain the structure of the table.

Which of the following keywords is used to mark a column for deletion at a later time?

Which of the following commands will add a new column named FIRST ORDER DATE to the CUSTOMERS table to store the date that the customer first placed an order with the company?

Which keywords are used to complete the deletion of a column previously marked with SET UNUSED?

Which of the following is a valid column name?

Which of the following commands can be used to make structural changes to an existing table?

Which of the following keywords uses a subquery to create a new table using existing database tables?

A _______ column generates values automatically at runtime and may reference values from other columns.

If a new column is added to the PROMOTION table, where will the new column be listed?

Which command instructs Oracle 12c to create a new table?

Which of the following is displayed by the DESCRIBE command?

The maximum width of the NUMBER datatype is ____ digits.

In which format does Oracle 12c display a date value?

Which of the following datatypes refers to fixed-length character data, where n represents the maximum length of the column?

If a new table is being created based upon a subquery, the subquery must be enclosed in which of the following symbols?

Which command is used to rename a table you own?

If the MAXRETAIL column of the PROMOTION table has been set as unused, which of the following commands is valid?

When creating a table, which of the following statements is correct?

Which of the following commands will set the MINRETAIL column of the PROMOTION table as unused?

When using the ALTER TABLE...DROP COLUMN command, which of the following is not correct?

Which of the following commands will change the name of the LAST NAME column to LAST_NAME in the CUSTOMERS table?

Which of the following symbols cannot be used in a table name?

A(n) ____ simply identifies the type of data that Oracle 12c will be expected to store in a column.

Which command instructs Oracle 12c to create a new table from existing data?

Which of the following queries will allow hidden columns to be displayed?

Which of the following datatypes refers to variable-length character data, where n represents the maximum length of the column?