Deck 3: Table Creation and Management

Question 1

The default size of a VARCHAR2 column is one character.

Answer 1

False

Question 2

A datatype identifies the type of data to be stored in a column.

Answer 2

True

Question 3

A column name can consist of up to 225 characters.

Answer 3

False

Question 4

If the CREATE TABLE is being used to create a table from existing data, the SUBQUERY keyword must be used.

Question 5

A database object is a defined, self-contained structure in Oracle11g.

Question 6

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

Question 7

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

Question 8

DML commands are used to create or modify database tables.

Question 9

The CREATE TABLE cannot contain a subquery.

Question 10

The MODIFY TABLE command can be used to change the size of a table.

Question 11

The scale of a NUMBER column indicates the number of digits that can be displayed to the right of the decimal point.

Question 12

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

Question 13

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

Question 14

Every table name within a specific schema must be unique.

Question 15

The maximum width of a VARCHAR2 column is 2000 characters.

Question 16

The structure of a table can be viewed by issuing the STRUCTURE command.

Question 17

A table name can be up to 30 characters in length.

Question 18

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

Question 19

The precision of a NUMBER does not include the decimal point itself in the total number of digits that can be stored in a column.

Question 20

The default format of a DATE column in Oracle11g is DD-MON-YY.

Question 21

A table name must begin with a(n) $\underline { \text { number. } }$ _________________________

Question 22

$\underline { \text { Seven bytes } }$ are allocated in a DATE column to store the century, year, month, day, hour, minute, and second of a date. _________________________

Question 23

The maximum width of a NUMBER column is $\underline { 25 }$ digits. _________________________

Question 24

The ALTER TABLE name can be used to rename a table.

Question 25

Data $\underline { \text { manipulation } }$ language commands are used to create or modify database tables. _________________________

Question 26

When a column is deleted, the deletion is permanent.

Question 27

SELECT9 $\underline { is }$ a valid table name. _________________________

Question 28

$\underline { \text { DDL } }$ commands are used to create or modify database objects. _________________________

Question 29

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

Question 30

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

Question 31

The maximum width of a(n) $\underline { \mathrm{CHAR} }$ column is 4000 characters. _________________________

Question 32

A CHAR column cannot be resized to a width that is smaller than the data it already contains.

Question 33

The $\underline { \text { CHAR } }$ datatype is used to store variable-length data that can consist of letters and numbers. _________________________

Question 34

You cannot delete the last column in a table.

Question 35

The $\underline { \text { scale } }$ of a NUMBER column indicates the total number of digits that can be stored in the column. _________________________

Question 36

The DROP TABLE command can be used to remove a table and all its data from a database.

Question 37

The RENAME command can be used to assign a table to a new schema.

Question 38

A table that has been dropped without the PURGE option can be retrieved using the FLASHBACK TABLE command.

Question 39

To retain the structure of a table, while deleting all its data and releasing their storage space, execute the TRUNC command.

Question 40

You cannot specify the width for a(n) $\underline { \text { NUMBER } }$ column. _________________________

Question 41

The data contained in a dropped table can be retrieved if the $\underline { \text { DROP } }$ option was not used in the DROP TABLE command. _________________________

Question 42

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

A) DELETE UNUSED COLUMNS
B) DROP UNUSED COLUMNS
C) UNSET UNUSED COLUMNS
D) DROP SET COLUMNS

Question 43

Once a column as been set as $\underline { \text { UNUSED } }$ it cannot be recovered. _________________________

Question 44

The $\underline { \text { MODIFY } }$ clause can be included in the ALTER TABLE command to add a default value to an existing column. _________________________

Question 45

Which of the following is a valid table name?

A) MYTABLE
B) DISTINCT
C) SELECT
D) CHAR

Question 46

The default size of the CHAR column is $\underline { 2. }$ _________________________

Question 47

The $\underline { \text { CREATE TABLE } }$ command is used to create a table in Oracle11g. _________________________

Question 48

The abbreviation for the DESCRIBE command is $\underline { \text { DES } }$ _________________________

Question 49

The $\underline { \text { CHANGE } }$ TABLE command can be used to modify an existing table. _________________________

Question 50

The syntax of the $\underline { \text { CREATE TABLE } }$ command requires that the column list be enclosed in parentheses. _________________________

Question 51

The DROP COLUMN clause of the ALTER TABLE command can only be used to $\underline { \text { delete } }$ one column at a time. _________________________

Question 52

The $\underline { \text { MODIFY } }$ clause can be used with the ALTER TABLE command to add a column to an existing table. _________________________

Question 53

The width of a NUMBER column cannot be $\underline { \text { changed } }$ once it contains data. _________________________

Question 54

A table must contain a minimum of $\underline { \text { two } }$ columns. _________________________

Question 55

The $\underline { \text { 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. _________________________

Question 56

More than one column can be changed at a time with the $\underline { \text { ALTER TABLE ...MODIFY } }$ command. _________________________

Question 57

Which of the following terms refers to commands that are used to create or modify database tables?

A) data manipulation language (DML)
B) data control language (DCL)
C) data definition language (DDL)
D) data formatting language (DFL)

Question 58

Which of the following is a valid column name?

A) VARCHAR2
B) DISTINCT
C) NEW_COLUMN
D) CHAR

Question 59

The $\underline { \text { TRUNCATE TABLE } }$ command can be used to delete a table from a database. _________________________

Question 60

Which of the following rules does not apply to column names in Oracle11g?

A) Column names can contain numbers.
B) Column names can be up to 30 characters in length.
C) Column names must begin with a letter.
D) Column names can contain an ampersand (&).

Question 61

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

A) CHAR(n)
B) VARCHAR(n)
C) VARCHAR2(n)
D) LONG

Question 62

In which format does Oracle10g display a date value?

A) DD-MON-YEAR
B) DAY-MM-YY
C) DD-MM-YY
D) DD-MON-YY

Question 63

When defining columns for a table in the CREATE TABLE command, the column list must be enclosed in which of the following symbols?

A) " "
B) ' '
C) ( )
D) | |

Question 64

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

A) _
B) %
C) #
D) none of the above

Question 65

Which of the following symbols can be used in a column name?

A) %
B) *
C) #
D) '

Question 66

Which of the following is a valid table name in Oracle11g?

A) jimm8 Y%c _5_H76ang
B) S_c#oT#2t_321sM#_i_T6h
C) 2LaN_n23_es#M#m
D) mAU$reE78_&_n1

Question 67

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

A) CHAR(n)
B) BFILE
C) VARCHAR2(n)
D) LONG

Question 68

If a column is defined as NUMBER(5,2), which of the following is True?

A) The column can store a total of 7 digits, with 5 on the left side of the decimal point, and 2 on the right.
B) The column can store a total of 7 digits, all of them on the right side of the decimal point.
C) The column can store a total of 5 digits, with 3 on the left side of the decimal point, and 2 on the right.
D) The column can store a total of 5 digits, all of them on the left side of the decimal point.

Question 69

Which of the following SQL*Plus commands will display the structure of a table?

A) DISPLAY
B) DESC
C) DSC
D) VIEW

Question 70

Which command instructs Oracle11g to create a new table from existing data?

A) CREATE NEW TABLE
B) CREATE TABLE...FROM
C) CREATE TABLE
D) CREATE TABLE...AS

Question 71

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

A) The schema of the table must be explicitly stated.
B) A user can have two tables with the same name, as long as the column names are different.
C) The column list must be enclosed in parentheses ( ).
D) Default values cannot be assigned to all columns in a table.

Question 72

The maximum width of the NUMBER datatype is ____ digits.

A) 7
B) 30
C) 38
D) 255

Question 73

The column definition of NUMBER(7, 4) indicates a precision of ____.

A) 7
B) 4
C) 11
D) 3

Question 74

Which of the following rules apply to table names in Oracle11g?

A) Names can contain blank spaces.
B) Names can be up to 225 characters in length.
C) Names can begin with a number.
D) Names can contain a number sign (#).

Question 75

When defining columns for a table, which of the following symbols is used to separate the column names in the column list?

A) " "
B) ,
C) ( )
D) | |

Question 76

Which command instructs Oracle11g to create a new table?

A) CREATE NEW TABLE
B) CREATE TABLE...FROM
C) CREATE TABLE
D) ALTER TABLE

Question 77

Which of the following is a valid SQL statement?

A) CREATE TABLE newname (colA NUMBER, colB DATE);
B) CREATE TABLE newname as SELECT * FROM books;
C) CREATE TABLE newname (colA, colB);
D) CREATE TABLE newname (colA DATE, colB VARCHAR2(3);

Question 78

Which of the following is displayed by the DESCRIBE command?

A) column names
B) not null requirements
C) datatypes
D) all of the above

Question 79

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

A) data definition
B) data format
C) datatype
D) data record

Question 80

What is the maximum width that can be assigned to a DATE column?

A) 1
B) 8
C) 12
D) none of the above