Exam 2: Creating and Modifying Database Tables

To check that the value entered into a CHAR column is either 'M' or 'F',you would use a check condition constraint.

Which of the following is not part of a DDL command?

When selecting the table_name column from the all_tables view which tables are displayed?

Which command is used to disable the constraint named faculty_loc_id_fk in the faculty table?

The Oracle Naming Standard states that objects must be from 1 to ____ characters long.

The ____________________ specifies the number of digits on the right side of the decimal point.

When you exit from a SQL*Plus session,the connection with the database is automatically closed.

If a column has a YEAR TO MONTH INTERVAL data type,then the value +02-11 specifies a positive time interval of 2 years and 11 months.

A(n)____________________ enables you to specify that a column value must be a specific value or fall within a range of values.

A(n)____________________ specifies the kind of data that the column stores.

When declaring a NUMBER data type,scale is the total number of digits both to the left and to the right of the decimal point.

To delete a table from the database,use the ____________________ command.

If you need to store a jpeg image in the database,which column declaration would you use?

Explain the Oracle naming standard.Provide example of legal and illegal names.

____________________ are restrictions on the data values that a column can store.

A primary key is defined using an integrity constraint.

One way to exit SQL*Plus is to type ____________________ at the SQL prompt.

You can change a column data type from VARCHAR2 to NUMBER.

Which of the following is not required to log in to an Oracle database using SQL*Plus?

The following declaration represents an integer: my_int number(4,2).