IBM
C2090-610 · Question #115
An SQL function named DEPT_INFO was created as follows: What is the correct way to use this function in a query?
The correct answer is D. SELECT dept_id, dept_name FROM TABLE(dept_info()) AS results. See the full explanation below for the reasoning.
Question
An SQL function named DEPT_INFO was created as follows:
What is the correct way to use this function in a query?
Exhibit
Options
- ASELECT dept_info(dept_id, dept_name)
- BSELECT dept_id, dept_name FROM dept_info()
- CSELECT TABLE dept_id, dept_name FROM dept_info()
- DSELECT dept_id, dept_name FROM TABLE(dept_info()) AS results
How the community answered
(45 responses)- A4% (2)
- B9% (4)
- C2% (1)
- D84% (38)
Community Discussion
No community discussion yet for this question.