Managing Databases with Oracle
Which of the following is not true of SQL views?

Oracle views can by queried.
The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.
Oracle views are created using the standard SQL-92 CREATE VIEW command.
Oracle views cannot use the ORDER BY clause in view definitions.

ANSWER DOWNLOAD EXAMIANS APP

Managing Databases with Oracle
In creating a procedure, you may get a message if you have compile errors. Which of the following is true?

To see the errors, enter SHOW ERRORS in SQL*Plus.
If there are no syntax errors, you will receive the message "NO ERRORS."
The line numbers reported match the line numbers you see in your text editor.
SQL*Plus will automatically show the errors to you.

ANSWER DOWNLOAD EXAMIANS APP