Questions on Oracle 10g features

Reference: http://www.iselfschooling.com/mcd12_ora10g/Oracle10g_Answers.htm

Q: How do you use the V$FAST_START_TRANSACTIONS view to monitor (in real-time) normal transaction rollback and transaction recovery by SMON?
A:
SQL> SELECT * FROM v$fast_start_ transactions;

Q: How do you use the V$FAST_START_SERVERS view to display historical information about transaction recovery?
SQL> SELECT * FROM v$fast_start_servers;

Q: How do you use the DBA_ENABLED_TRACES view to display enabled and disabled trace?
A:
SQL> SELECT * FROM dba_enabled_traces;

Q: What is case-insensitive sorting in the Oracle 10g?
A: In the Oracle 10g database, you can use the ALTER SESSION command to change NLS_SORT for your session to use case-insensitive binary sorting.

Q: What is Quote Operator q?
A: Now, you can eliminate previous additional quotation string. See the following example:
SQL> UPDATE customers
SET comments =
q’X In this example, ‘X’ is used as the quotation mark delimiter. X’;
WHERE ID = 100;
SQL> COMMIT;

Q: What does the UTL_MAIL package?
A: You can send e-mail to a user. In order to use the package, you should have already run the utlmail.sql and prvtmail.plb scripts located in the $ORACLE_HOME/rdbms/admin directory.