9.6. Review Questions

  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?

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset