Chapter 9
| 1. | An iSQL*Plus substitution variable is preceded by what character(s) in a script? | |
| 2. | Identify the two iSQL*Plus commands that define the header and footer for a report. | |
| 3. | On which iSQL*Plus web page can you adjust the size of the iSQL*Plus window where you enter your iSQL*Plus commands or SQL statements? | |
| 4. | Write an iSQL*Plus footer command to display the text Page 22, right-justified on the line. | |
| 5. | Sums and averages can be displayed on an iSQL*Plus report using which iSQL*Plus command? | |
| 6. | Write a single iSQL*Plus COLUMN command to format the Salary column with a total of six digits, four to the left of the decimal point and two to the right. In the same COLUMN command, define the header to be Monthly Salary, with the words appearing on different lines in the column header. | |
| 7. | Which iSQL*Plus command controls the row count display after a SELECT statement is executed? | |
| 8. | Which iSQL*Plus command controls how duplicate column values are displayed on a report? | |
| 9. | The iSQL*Plus BREAK command is almost always specified in conjunction with what SQL SELECT statement clause? | |
| 10. | In both the TTITLE and BTITLE commands, what option must be used to specify more than one line in the header or footer? | |
Answers
| 1. | An iSQL*Plus substitution variable is preceded by either one or two ampersands (& or &&). |
| 2. | The TTITLE and BTITLE commands define the header and footer for an iSQL*Plus report. |
| 3. | The size of the iSQL*Plus Work Screen window can be adjusted on the Interface Options page. |
| 4. | This iSQL*Plus command will display the text Page 22, right-justified on the footer line of the report: btitle right ‘Page 22’ |
| 5. | Sums and averages can be displayed on an iSQL*Plus report by using the COMPUTE iSQL*Plus command. |
| 6. | The following iSQL*Plus command will format the Salary column with six digits, four to the left of the decimal point and two to the right. In addition, the header will be defined as Monthly Salary, with the words appearing on different lines in the column header: column Salary format 9999.99 heading ‘Monthly|Salary’ |
| 7. | The FEEDBACK command controls the row count display after a SELECT statement is executed. By default, the row count from a query is displayed if there are six or more rows in the query output. |
| 8. | The BREAK command will suppress duplicate values in a report for a specified column. |
| 9. | The BREAK command is almost always specified on a column that is in the ORDER BY clause of a SQL SELECT statement. |
| 10. | The SKIP option must be used in a BTITLE or TTITLE command to specify more than one line in the header or footer. |
