True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
The START command can be used to indicate that a script file is to be
executed.
|
|
|
2.
|
The DATE option of the COLUMN command allows a specific format to be applied to
date values.
|
|
|
3.
|
The SET command is used to change the value assigned to an environment
variable.
|
|
|
4.
|
A header or footer can be left- or right-aligned or centered across the width of
a report.
|
|
|
5.
|
Include the SQL.NAME variable to display the name of the user on the
report.
|
|
|
6.
|
The SPOOL command is automatically terminated at the end of a report.
|
Modified True/False
Indicate
whether the statement is true or false. If false, change the identified word or phrase to make
the statement true.
|
|
|
7.
|
A report footer is defined by the BTITLE command.
_________________________
|
|
|
8.
|
The BREAK command can be used to print the name of a group only once for
each group. _________________________
|
|
|
9.
|
The CLEAR command is used to remove the changes generated through the
TTITLE command. _________________________
|
|
|
10.
|
The SPOOL TERMOFF command is used to end the spooling process.
_________________________
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
11.
|
The ____ command redirects output to a text file.
a. | DIRECT | c. | SPOOLTXT | b. | OUTPUT | d. | SPOOL |
|
|
|
12.
|
The ____ SQL*Plus variable establishes the maximum number of characters that can
appear on a single line of output.
a. | UNDERLINE | c. | PAGESIZE | b. | LINESIZE | d. | COLUMNSIZE |
|
|
|
13.
|
Which SQL*Plus variable establishes the maximum number of lines that can appear
on one page of output?
a. | LINESIZE | c. | PAGESIZE | b. | SCREENSIZE | d. | REPEATSIZE |
|
|
|
14.
|
Which of the following is not an example of formatting code available with the
FORMAT option of the COLUMN command?
|
|
|
15.
|
Which of the following formatting codes is used to specify that a character
column should be displayed with a column width of 5?
a. | Z5 | c. | A5 | b. | ***** | d. | - - - - - |
|
|
|
16.
|
Which of the following statements about the HEADING option of the COLUMN command
is incorrect?
a. | It provides a substitute heading for the display of the output. | b. | Unlike an alias, a
column name assigned by the HEADING option cannot be referenced in a SELECT
statement. | c. | Unlike an alias, a column name assigned by the HEADING option can contain line
breaks. | d. | The @ sign is used to indicate where a line break should occur in a column
heading. |
|
|
|
17.
|
Which of the following commands will allow a user to replace any null values
with the word "Unknown"?
a. | BREAK 'Unknown' | c. | NULL
'Unknown' | b. | NVL ( 'Unknown') | d. | FORMAT
'Unknown' |
|
|
|
18.
|
Which of the following options will left-align a report title?
a. | LALIGN | c. | LEFT | b. | LEFTAGN | d. | ALEFT |
|
|
|
Contents of Titlereport7.sql script file 
|
|
|
19.
|
Which of the following is an SQL*Plus variable included in the Titlereport7.sql
file?
a. | TTITLE | c. | SQL.USER | b. | COLUMN | d. | RIGHT |
|
|
|
20.
|
The ISBN column of the report created through execution of the Titlereport7.sql
script file can display a maximum of ____.
a. | 15 numbers, no characters are allowed | b. | 15 numbers and characters | c. | 15 characters, no
numbers are allowed | d. | none of the
above |
|
|
|
21.
|
Which of the column headings generated by the Titlereport7.sql script file will
be displayed in all upper-case characters?
a. | ISBN | c. | RETAIL | b. | TITLE | d. | COST |
|
|
|
Contents of the Shippingreport.sql script file 
|
|
|
22.
|
In the report generated by the Shippingreport.sql script file, the date values
displayed in the output are formatted by the ____ command.
a. | FORMAT | c. | NULL | b. | COLUMN | d. | none of the
above |
|
|
|
23.
|
In the report generated by the Shippingreport.sql script file, which of the
following symbols will cause the column headings to be displayed on two lines?
a. | - (dash) | c. | | (vertical bar) | b. | = (equal sign) | d. | ( )
(parentheses) |
|
Completion
Complete each
statement.
|
|
|
24.
|
Use a(n) ____________________ in the HEADING option of the COLUMN command to
indicate where a line break should occur.
|
|
|
25.
|
The ____________________ option of the TTITLE command indicates the number of
lines to skip before the actual report data is displayed.
|
Essay
|
|
|
26.
|
Explain the effect the following command will have on the RETAIL column of a
report.
COLUMN retail FORMAT 99999999.99 HEADING 'Retail|Price'
|