Which of the following command is used to display the departments of the instructor relation ?
A. Select * from instructor where Dept_name = Finance;
B. Select * from instructor ;
C. Select dept_name from instructor;
D. Select dept_name for instructor where Name=Jackson;
Answer:A
Which of the following command is used to display the departments of the instructor relation ?
A. Select * from instructor where Dept_name = Finance; B. Select * from instructor ; C. Select dept_name from instructor; D. Select dept_name for instructor where Name=Jackson;
Explanation:Only one field is necessary for the query and where clause is not needed for the selection.