8/2/2019 quiz ch 2 and 3

1/5

DML commands are used to create or modify database tables.

A) True

B) False

Correct Answer(s): False

The use of a column alias in the SELECT clause can be designated by the keyword ALIAS.

A) True

B) False

Correct Answer(s): False

The SELECT command can be used to display the structure of a database table.

A) True

B) False

Correct Answer(s): False

The ALL option can be used in the SELECT clause to indicate that all columns should be retrieved.

A) True

B) False

Correct Answer(s): False

The syntax for a SQL statement gives the basic structure required to execute the statement.

A) True

B) False

Correct Answer(s): True

SQL*Plus can only be accessed via an internet interface.

A) True

B) False

Correct Answer(s): False

The maximum width of a NUMBER column is 25 digits.

8/2/2019 quiz ch 2 and 3

2/5

A) True

B) False

Correct Answer(s): False

The TRUNCATE TABLE command can be used to delete a table from a database.

A) True

B) False

Correct Answer(s): False

A table must contain a minimum of two columns.

A) True

B) False

Correct Answer(s): False

Which of the following keywords can be used to indicate that a column alias should be included in the

results?

A) AS

B) FROM

C) SELECT

D) ALIAS

Correct Answer(s): A

3.

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

A) 1

B) 8

C) 12

D) none of the above

Correct Answer(s): D

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

8/2/2019 quiz ch 2 and 3

3/5

A) %

B) *

C) #

D) '

Correct Answer(s): C

Once a column has been set as UNUSED, which of the following is correct?

A) It is unavailable and will not be displayed in the table structure.

B) It will still appear in the results of subqueries until it is dropped.

C) It is unavailable, but will still be displayed in the table structure.

D) All DDL operations can be performed on it until it is actually dropped.

Correct Answer(s): A

Which of the following keywords cannot be used to modify an existing table?

A) ALTER TABLE...ADD

B) ALTER TABLE...DROP COLUMN

C) ALTER TABLE...MODIFY

D) ALTER TABLE...AS

Points Earned: 0.0/1.0

Correct Answer(s): D

Structure of the CUSTOMERS table

nar001-1.jpg

Which of the following commands will change the name of the LASTNAME column to LAST_NAME in the

CUSTOMERS table?

A) ALTER TABLE customers MODIFY lastname to last_name;

B) ALTER TABLE customers CHANGE lastname to last_name;

C) ALTER TABLE customers MODIFY (lastname, last_name);

8/2/2019 quiz ch 2 and 3

4/5

D) none of the above

Points Earned: 0.0/1.0

Correct Answer(s): D

Which of the following keywords uses a subquery to create a new table using existing database tables?

A) ALTER TABLE

B) GENERATE TABLE

C) CREATE TABLE...AS

D) CREATE TABLE...FROM

Correct Answer(s): C

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)

Correct Answer(s): C

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

A) DISPLAY

B) DESC

C) DSC

D) VIEW

Correct Answer(s): B

What is used to indicate the end of an SQL statement?

A) /

B) :

C) ;

8/2/2019 quiz ch 2 and 3

5/5

D) *

Correct Answer(s): C

Which of the following are case sensitive in Oracle11g?

A) keywords

B) column names

C) table names

D) none of the above

Points Earned: 1.0/1.0

Correct Answer(s): D