PrepAway - Latest Free Exam Questions & Answers

which of the following are valid methods for determining scalar functions (Choose all that apply.?

Under JDBC, which of the following are valid methods for determining scalar
functions (Choose all that apply.?

PrepAway - Latest Free Exam Questions & Answers

A.
getNumericFunctions(.

B.
getStringFunctions(.

C.
getSystemFunctions(.

D.
getTimeDateFunctions(.

Explanation:
According to the online Java tutorial provided by Sun at java.sun.com
Most databases provide scalar functions (sometimes referred to as built in functions.
that can be used to perform an operation on the specific value of a column, or even
to provide the value of a built-on-the-fly column. The JDBC specification supports
the various math, string, system, time and date, and type conversion functions
specified by the X/Open Call Level Interface (CLI., and JDBC Compliant drivers
must as well, if the underlying DBMS supports the functionality. The names of these
functions should match the X/Open names, although this is not always the case.
Scalar functions can be valuable for their functionality or to shift work to the
database from your application. JDBC provides these methods to determine the
scalar functions getNumericFunctions(., getStringFunctions(.,
getSystemFunctions(., getTimeDateFunctions(., and two versions of
supportsConvert(.. The getXXXFunctions(. methods return the function names in a
comma delimited String.


Leave a Reply