Ch. 2

Question 1

Based upon the contents of the BOOKS table, which of the following columns will be displayed with a right-aligned column heading?

Contents of the BOOKS table

Answer 1

PUBID

Question 2

A(n) ____ has a predefined meaning in Oracle11g

Answer 2

KEYWORD

Question 3

If the results of a SELECT statement include more than one column of data, the column names must be separated in the SELECT clause by which of the following symbols?

Answer 3

, (COMMA)

Question 4

Which of the following types of columns will automatically left-align the column heading when it is displayed?

a. Character
b. Numeric
c. Date
d. Both a and c

Answer 4

d. Both a and c

Question 5

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

a. desc
b. AS
c. FROM
d. none of the above

Answer 5

b. AS

Question 6

A string literal must be enclosed in ____.

Answer 6

single quotation marks (‘ ‘)

Question 7

To indicate which database table contains the data to be selected by a query, the table name should be listed in the ____ clause

Answer 7

FROM

Question 8

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

Answer 8

SELECT

Question 9

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

Answer 9

concatenation

Question 10

What is the Command to view all the columns of a table?

Answer 10

SELECT *

FROM tablename;

Question 11

What is the command to view one column of a table?

Answer 11

SELECT columnname

FROM tablename;

Question 12

What is the command to view multiple columns of a table?

Answer 12

SELECT columnname,

columnname,…

FROM tablename;

Question 13

What is the command to asign an alias to a column during display?

Answer 13

SELECT coulnmnname AS alias

FROM tablename;

or

SELECT title titles

FROM books;

Question 14

What is the command to eliminate duplication in ouput?

Answer 14

SELECT DISTINCT columname

FROM tablename;

or

SELECT UNIQUE columname

FROM tablename;

Question 15

What is the command to perform concatenation of column contents during display?

Answer 15

SELECT columnname || columnname

FROM tablename;

Question 16

What is the command to view the structure of a table?

Answer 16

DESCRIBE tablename

Question 17

________ clause identify the columns for etrieval in a SELECT command.

Answer 17

SELECT

Question 18

_______ clause indentify the table containing selected columns.

Answer 18

FROM

Question 19

_____ preserve spaces, symbols, or letter case in an output column alias.

Answer 19

” “

Question 20

____ combine display of content from multiple columns into a single column.

Answer 20

|| (concatenation)

Question 21

_____ indicate the exact set of characters, including spaces, to be displayed.

Answer 21

’ ‘ (string literal)

Question 22

What is the command that lists the name of all tables in the current account?

Answer 22

SELECT table_name

FROM user_tables;