Which statement is true?
A. Stored functions can increase the efficiency of queries by performing functions in the query rather than in the application.
B. Stored functions can be called from the SELECT and WHERE clauses only.
C. Stored functions cannot manipulate new types of data, such as longitude and latitude.
D. Stored functions do not permit calculations that involve database links in a distributed environment.
Answer: A. Stored functions can increase the efficiency of queries by performing functions in the query rather than in the application.
You might also like to view...
If a tree has order 4, what does this mean?
What will be an ideal response?
Write a function that converts an uppercase letter to lowercase. Use the following function header:
char toLowerCase(char ch) If the character is not an uppercase letter, the method simply returns the character itself. For example, toLowerCase('B') returns b and toLowerCase('5') returns 5. See Exercise 2.7 on how to convert an uppercase letter to lowercase. Write a test program that prompts the user to enter a character, invokes the function, and displays its return value. ```