Exam 2: Creating and Modifying Database Tables

Which of the following pieces of information is not displayed by SQL*Plus when an error occurs?

A ____ is a character LOB,storing up to 4 GB of character data in the database.

_________________________ is a Web-based resource that Oracle Corporation provides free of charge;it is useful for looking up error codes.

A user schema contains all database objects created by a user.

A fixed-point number contains a specific number of decimal places.

______________________________ commands are used to insert,update,delete,and view data.

Given the column declaration name CHAR(5),if a user attempted to store the value "Jonathan" in the name column,only the first 5 characters would be stored.

A(n)____________________ constraint defines a primary or foreign key.

SQL command words are also known as ____.

Which command would be used to delete table x and all foreign key constraints to x?

Which of the following data dictionary views can only be seen by users with special privileges?

NVARCHAR2 and NCHAR store character data with ____________________ coding.

A(n)____________________ constraint restricts the data value with respect to all other values in the table.

The ____ TABLE command is used to modify an existing column's data declaration.

If an Oracle error is generated by the DBMS the error code will begin with ____________________.

To view a list of all tables in your own schema,use the command "select table_name from ____________________".

In an INTERVAL YEAR TO MONTH data type,which of the following indicates a positive time interval of 2 years and 11 months?

A(n)____ number would be best to store a currency value.

Deleting columns from a table is a(n)____ action.

The ____ constraint specifies whether the user must enter a column for a specific record,or whether the value can be NULL (indeterminate or unknown).