COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What will be the result of this query?SELECT dept ____ nameFROM DepartmentsWHERE dept ____ no BETWEEN ‘d003’ AND ‘d006’;
|
|
Select all department name whose department number is not between d003 and d006;
|
|
|
select all department names whose department number is between d003 and d006;
|
|
|
select a list of all departments whose department number is between d003 and d006;
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -The above inner join query joins the Employee table and Department table and retrieves records from both the tables where Employee. DeptId = Department. DeptId . It only fetches records from both the tables where DeptId in the Employee table matches with the DeptId of the Department table.
Detailed explanation-2: -The asterisk tells the database to select all data in the table.
Detailed explanation-3: -Which of these query will display the the table given above ? Explanation: The field to be displayed is included in select and the table is included in the from clause.
There is 1 question to complete.