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:
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