Exam 2: Creating and Modifying Database Tables

The ____ data type stores variable-length character data.

Fixed-length character data is stored in the ____________________ data type.

If a user enters only a time into a DATE column,what will the date portion be set to?

A TIMESTAMP data type is the same as a DATE data type,except that time zone can be specified.

The SQL command to create a database table is an example of DML.

According to the Oracle Naming Standard,'-' (hyphen)is a legal character.

Which of the following is a table constraint?

Adding a new column to a database table is a(n)____________________ action.

Oracle10g stores character data in VARCHAR2 and CHAR columns using ____ encoding.

You are trying to create a table using SQL*Plus but keep receiving an Oracle error message.You cannot understand the description of the error provided by the interpreter.You have also looked-up the error code at otn.oracle.com,but you still cannot fix your sql.Describe another means you could use to find the problem in your code.

____ constraints define specific data values or data ranges that must be inserted into columns and whether values must be unique or not NULL.

A NOT NULL constraint is an example of a table constraint.

If the column S_ID is the primary key of the STUDENT table,the constraint name would be pk_STUDENT_S_ID according to the constraint naming convention.

Which of the following is not automatically transferred to a new table name upon renaming a table?

It is possible to temporarily disable constraints in an Oracle database.

Almost all relational database vendors support the ____ ANSI standard.

____ commands are used to add new database objects.

The following declaration represents a floating-point number: my_number NUMBER.

Which of the following declarations would be most appropriate for storing a dollar value up to $1000?

A(n)____________________ column stores binary data of up to 4 GB in the database.