CIT 225 Final Exam

A subquery can return a result set, a column of one or more rows, or a single ______________________. - Answer- cell In many cases, a subquery can be restated as a/an _____________ - Answer- join A correlated subquery is a subquery that is executed once for each ______________________ in the outer query. - Answer- row, row processed When you code a subquery in a FROM clause, it returns a result set that can be referred to as an _____________________________ view. - Answer- inline If introduced as follows, the subquery can return which of the values listed below? WHERE vendor_id NOT IN (subquery) - Answer- a column of one or more rows If introduced as follows, the subquery can return which of the values listed below? WHERE 2 (subquery) - Answer- A Single Value If introduced as follows, the subquery can return which of the values listed below? FROM (subquery) - Answer- A Table What does the function that follows return? TO_CHAR(1234, '$99,999.99') - Answer- $1,234.00 To store an integer with an Oracle data type (not one of the ANSI standard synonyms), you use the ____________________ data type. - Answer- Number The DATE data type includes not only the date, but also a ________________________. - Answer- Time To convert numeric values to formatted numbers, you can use the ______________________ function. - Answer- TO_CHAR Which of the Following values can be stored in a column that's defined as NUMBER(6,2), except: - -246.29 - 0