Explore topic-wise MCQs in SQL Server.

This section includes 5 Mcqs, each offering curated multiple-choice questions to sharpen your SQL Server knowledge and support exam preparation. Choose a topic below to get started.

1.

Select * from student join takes using (ID);
The above query is equivalent to ____________

A. Select * from student inner join takes using (ID);
B. Select * from student outer join takes using (ID);
C. Select * from student left outer join takes using (ID);
D. All of the mentioned
Answer» B. Select * from student outer join takes using (ID);
Discussion
2.

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

A. Salary*1.1
B. ID
C. Where
D. Instructor
Answer» D. Instructor
Discussion
3.

Select ________ dept_name from instructor;
Here which of the following displays the unique values of the column?

A. All
B. From
C. Distinct
D. Name
Answer» D. Name
Discussion
4.

Select ID, GPA from student grades order by GPA ____________
Inorder to give only 10 rank on the whole we should use.

A. Limit 10
B. Upto 10
C. Only 10
D. Max 10
Answer» B. Upto 10
Discussion
5.

Select __________ from instructor where dept name= Comp. Sci. ;
Which of the following should be used to find the mean of the salary?

A. Mean(salary)
B. Avg(salary)
C. Sum(salary)
D. Count(salary)
Answer» C. Sum(salary)
Discussion