What will be the output of the fallowing SELECT statement?SELECT count(*)FROM empWhere exist (select 'X' From deptwhere dept_name ='Stores' and dept.dept_id=emp.dept_id)A. select total number of employees belonging to department " stores "B. select all employees belonging to department "X"C. select all employees belonging to department "stores"D. select total number of employees belonging to department "X"

This question is related to Oracle Interview
  • Interview Candidate
  • 2
  • 3031

Showing Answers 1 - 2 of 2 Answers

krishna

  • Aug 11th, 2005
 

A. It selects the total no of emplyoyees in stores

NAGA

  • Aug 29th, 2006
 

This will not give any output

This will throw a error missing expression

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions