Category: Computer Science

“This Query can be replaced by which one of the following? SELECT name, course_id
FROM instructor, teaches
WHERE instructor_ID= teaches_ID;”

administrator

“

This Query can be replaced by which one of the following? SELECT name, course_id
FROM instructor, teaches
WHERE instructor_ID= teaches_ID;
Select name, course_id from instructor natural join teaches;
Explanation: Join clause joins two tables by matching the common column.
Select name,course_id from teaches,instructor where instructor_id=course_id;
Select name, course_id from instructor;
Select course_id from instructor join teaches;
“

“The query given below will not give an error. Which one of the following has to be replaced to get the desired output? SELECT ID, name, dept name, salary * 1.1
WHERE instructor;”

administrator

“

The query given below will not give an error. Which one of the following has to be replaced to get the desired output? SELECT ID, name, dept name, salary * 1.1
WHERE instructor;
Where
Explanation: Where selects the rows on a particular condition. From gives the relation which involves the operation. Since Instructor is a relation it has to have from clause.
Instructor
ID
Salary*1.1
“

The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

administrator
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
Where, from
Explanation: Where selects the rows on a particular condition. From gives the relation which involves the operation.
From, select
Select, from
From, where
Page 162 of 174
1 … 160 161 162 163 164 … 174