Question

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;

This question was posed to me in homework.

The above asked question is from Querying database part-2 DML in chapter Database Systems Design and Implementation of Database Management

Answer 1

The correct choice is (c) Select dept_name from instructor;

The explanation is: Only one field is necessary for the query and where clause is not needed for the selection.