Final Practice Query Exam 3 Verified Solutions

You issue the following statement in Oracle: SELECT * FROM EMP WHERE DEPT IN (SELECT DEPT FROM VALID_DEPTS WHERE DEPT_HEAD = 'SALLY' ORDER BY DEPT); Which of the following choices best indicates how Oracle will respond to this SQL statement? {Ans: Oracle returns an error In this situation, you cannot use the ORDER BY clause in a subquery. Oracle will return an error. Thus, no data will be returned from any table, so all other choices are wrong.}You have a script you plan to run using SQL*Plus that contains several SQL statements that manage milk inventory in several different tables based on various bits of information. You want the output to go into a file for review later. Which command would you use? {Ans: SPOOL The SPOOL command makes SQL*Plus write an output file containing all information transacted in the session, from the time you turn spooling on and identify the output file to the time you either turn spooling off or end the session. PROMPT causes SQL*Plus to prompt you to enter data using a specialized request message of your own devising, while ECHO cause an error because it is not a valid command in SQL*Plus. Finally,