CIST1220 QUIZ 8

What command can be used to show information about the structure of a table?

C) DESCRIBE

Which of the following commands is used to issue a query?

C) SELECT

Once data has been created in a RDBMS, the ony way of getting it out again is by writing a Java or C program. No other languages can be used to access that data. True or False?

B) False

A script file containing SQL statements can be executed from SQL*Plus.

A) True

A user can indicate that all columns of a table should be displayed in the results of a SELECT statement by including an asterisk (*) in the SELECT clause.

A) True

Which of the following symbols can be used to combine data from different columns into one column of output?

A) ||

Structure of the ORDERS table nar003-1.jpg Which of the following statements can be used to view the structure of the ORDERS table?

B) DESCRIBE ORDERS

Combining the contents of two or more columns is known as projection.

B) False

A column alias must be contained within double quotation marks (" ") if it contains which of the following?

D) all of the above

The entire column heading for a column will be displayed, regardless of the assigned width of the column, if the column is defined as a(n) ____ column.

D) numeric