Subqueries MCQ

Test your knowledge with important Subqueries MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Subqueries MCQs at Bissoy

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

  Where, from

  খ

  From, select

  গ

  Select, from

  ঘ

  From, where
• Select * from student join takes using (ID); The above query is equivalent to ____________
  ক

  Select * from student inner join takes using (ID);

  খ

  Select * from student outer join takes using (ID);

  গ

  Select * from student left outer join takes using (ID);

  ঘ

  All of the mentioned
• 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?
  ক

  Salary*1.1

  খ

  ID

  গ

  Where

  ঘ

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

  All

  খ

  From

  গ

  Distinct

  ঘ

  Name
• Which server can join the indexes when only multiple indexes combined can cover the query?
  ক

  SQL

  খ

  DBMS

  গ

  RDBMS

  ঘ

  All of the mentioned
• Which of the following is not the function of client?
  ক

  Compile queries

  খ

  Query optimization

  গ

  Receive queries

  ঘ

  Result formatting and presentation
• Select ID, GPA from student grades order by GPA ____________ Inorder to give only 10 rank on the whole we should use.
  ক

  Limit 10

  খ

  Upto 10

  গ

  Only 10

  ঘ

  Max 10
• The ________ connective tests for set membership, where the set is a collection of values produced by a select clause. The _________ connective tests for the absence of set membership.
  ক

  Or, in

  খ

  Not in, in

  গ

  In, not in

  ঘ

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

  Mean(salary)

  খ

  Avg(salary)

  গ

  Sum(salary)

  ঘ

  Count(salary)