(Answer all questions in this section) 1. Which three statements concerning explicit data type conversions are
true? (Choose three.)
Mark or !eview (") #oints
(Choose all correct answers) $se the %&'$M*! unction to convert a character string o digits to a num+er. (,) $se the %&'-A%* %&'-A%* unction to convert a date value to a character string or num+er num+er.. $se the %&'CA! unction to convert a num+er or date value to a character string. (,) $se the %&'-A%* %&'-A%* unction to convert a character string to a date value. (,) $se the %&'$M*! unction to convert a num+er to a character string. Correct 2. Which /01 /tatement should you use to display the prices in this ormat2
%he %&'CA! unction can +e used to remove remove text rom column data that will +e returned +y the data+ase. %he %&'CA! unction can +e used to display display dates and num+ers according to ormatting conventions that are supported +y &racle. (,) %he %&'CA! unction can +e used to speciy speciy meaningul column names in an /01 statement8s result set. %he %&'CA! unction can only +e used on -ate -ate columns. Correct
4. >ou need to display the
55. Which /*1*C% statement would you use?
>ou need to store the ollowing date2 E-ecB9 Which statement a+out the date ormat or this value is true? oth the >> and !! date ormats will interpret the year as "9B9
Mark or !eview (") #oints
%he !! date ormat will interpret the year as "9B97 and the >> date ormat will interpret the year as 5B9 (,) %he !! date ormat will interpret the year as 5B97 and the >> date ormat will interpret the year as "9B9 oth the >> and !! date ormats will interpret the year as 5B9 Correct 7. With the ollowing data in
*mployees (last'name7 commission'pct7 manager'id) what is the result o the ollowing statement? -A%A2 Fing7 null7 null Fochhar7 null7 "55 argas7 null7 "D Glotkey7 .7 "55
Mark or !eview (") #oints
/*1*C% last'name7 1(commission'pct7 manager'id7 ") comm :!&M employees ;
true? 1 and 17 +ut not C&A1*/C*7 can +e used with group unctions to replace null values. 1 and C&A1*/C*7 +ut not 17 can +e used with group unctions to replace null values. C&A1*/C*7 +ut not 1 and 17 can +e used with group unctions to replace null values. 17 17 and C&A1*/C* can +e used with group unctions to replace null values. (,) Correct 12. Consider the ollowing data in the *mployees ta+le2 (last'name7