Database Freshers Online Exam Quiz
Database Freshers GK Quiz. Question and Answers related to Database Freshers. MCQ (Multiple Choice Questions with answers about Database Freshers
If a person all the people in Music department gets fired which of the following has to be performed on the instructor relation ?
Options
A : Delete Dept_name=Music in instructor;
B : Delete from instructor where Dept_name=Music;
C : Remove Dept_name= Music
D : All of the mentioned
Which function is used to find the count of distinct departments?
Options
A : Dist
B : Distinct
C : Count
D : Count,Dist
Which function is used to identify the title with Least scope?
Options
A : Min(Credits)
B : Max(Credits)
C : Min(title)
D : Min(Salary)
How can we select the elements which have common Dept_name in both the relation ?
Options
A : Select * from instructor i , course c where i.Dept_name=c.Dept_name;
B : Select Dept name from instructor ,Course ;
C : Select * from instructor i , course c ;
D : Select Dept_name from instructor where Dept_name = NULL;
Which of the following command is used to display the departments of the instructor relation?
Options
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;