How Can We Select The Elements Which Have Common Deptname In #513
How can we select the elements which have common Dept_name in both the relation ?
This multiple choice question (MCQ) is related to the book/course
gs gs117 Database Management System.
It can also be found in
gs gs117 Database Systems Design and Implementation - Querying DML - Quiz No.1.
How can we select the elements which have common Dept_name in both the relation ?
Select * from instructor i , course c where i.Dept_name=c.Dept_name;
Select Dept name from instructor ,Course ;
Select * from instructor i , course c ;
Select Dept_name from instructor where Dept_name = NULL;
Similar question(s) are as followings:
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117 Database Management System
Online Quizzes
