Chapter 3
Which of the following symbols cannot be used in a table name?
%
The DROP COLUMN clause of the ALTER TABLE command can be used to drop a maximum of ____________________ column(s) at a time.
1
Which of the following commands will increase the size of the CITY column in the CUSTOMERS table from 12 to 20 and increase size of the LASTNAME column from 10 to 14?
ALTER TABLE customersMODIFY (city VARCHAR2(20), lastname VARCHAR2(14));
Which of the following is a valid SQL statement?
CREATE TABLE newname (colA NUMBER, colB DATE);
Which of the following SQL statements was most likely used to create the PROMOTION table?
CREATE TABLE promotion (gift VARCHAR2(15), minretail NUMBER(5, 2), maxretail NUMBER(5, 2));
Which of the following rules does not apply to column names in Oracle11 g?
Column names can contain an ampersand (&).
The default format for a DATE column is ____________________.
DD-MON-YY
Which of the following terms refers to commands that are used to create or modify database tables?
DDL
Which of the following SQL*Plus commands will display the structure of a table?
DESC
_________________________ commands are used to create database objects.
Data definition language
A column name can consist of up to 225 characters.
False
If the CREATE TABLE is being used to create a table from existing data, the SUBQUERY keyword must be used.
False
Only one column can be added to an existing table at one time.
False
The ALTER TABLE name can be used to rename a table.
False
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.
False
The TRUNCATE TABLE command can be used to delete a table from a database.
False
The default size of the CHAR column is 2.
False
The maximum width of a VARCHAR2 column is 2000 characters.
False
If you are creating a new table containing four columns from an existing table and want to change the name of one of the columns when it is created in the new table, add a column list containing ____ names in the CREATE TABLE clause.
Four
The ____________________ clause of the ALTER TABLE command can be used to change the size of a column.
Modify
Which of the following is a valid table name?
Mytable
What is the maximum width that can be assigned to a DATE column?
None of the above
Which of the following commands will change the name of the LASTNAME column to LAST_NAME in the CUSTOMERS table?
None of the above
A table must have at least ____________________ column(s).
One
When creating a table, which of the following statements is correct?
The column list must be enclosed in parentheses ( ).
A CHAR column cannot be resized to a width that is smaller than the data it already contains.
True
A table that has been dropped without the PURGE option can be retrieved using the FLASHBACK TABLE command.
True
Every table name within a specific schema must be unique.
True
Once a column as been set has UNUSED, it cannot be recovered.
True
The DROP TABLE command can be used to remove a table and all its data from a database.
True
The scale of a NUMBER column indicates the number of digits that can be displayed to the right of the decimal point.
True
The ____________________ TABLE command can be used to delete and release the storage space of all data contained in a database table, while still retaining the table's structure.
Truncate
Which of the following commands will display the structure of the CUSTOMERS table?
both a and b
A(n) ____ simply identifies the type of data that Oracle11 g will be expected to store in a column.
datatype
Once a table is ____________________, any associated indexes will be removed from the database.
dropped