PrepAway - Latest Free Exam Questions & Answers

What is the correct way to use this function in a query?

An SQL function named DEPT_INFO was created as follows:

What is the correct way to use this function in a query?

PrepAway - Latest Free Exam Questions & Answers

A.
SELECT dept_info(dept_id, dept_name)

B.
SELECT dept_id, dept_name FROM dept_info()

C.
SELECT TABLE dept_id, dept_name FROM dept_info()

D.
SELECT dept_id, dept_name FROM TABLE(dept_info()) AS results

Explanation:


Leave a Reply