Performing Multiple MCQ

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

• SELECT on a MERGE table is like _____________
  ক

  UNION ALL

  খ

  UNION

  গ

  UNION DISTINCT

  ঘ

  JOIN
• Which table is used to run a UNION-type query on MyISAM tables?
  ক

  TRADITIONAL

  খ

  MERGE

  গ

  SERVELET

  ঘ

  UNITE
• Suppose it is desired that UNION operation should return not more than 3 rows. Which keyword is used for this?
  ক

  LIMIT

  খ

  RESTRICT

  গ

  COUNT

  ঘ

  SORT
• Which clause is used to sort a UNION result as a whole?
  ক

  LIMIT

  খ

  ORDER BY

  গ

  GROUP BY

  ঘ

  SORT
• The UNION ALL has a higher precedence than UNION DISTINCT.
  ক

  True

  খ

  False
• Which keyword used with UNION retains duplicate rows?
  ক

  ALL

  খ

  NARROW

  গ

  STRICT

  ঘ

  DISTINCT
• Which keyword used with UNION does not retain duplicate rows?
  ক

  ALL

  খ

  NARROW

  গ

  STRICT

  ঘ

  DISTINCT
• To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword?
  ক

  COMBINE

  খ

  CONCAT

  গ

  JOIN

  ঘ

  UNION
• Which of these operators does not perform relative-value comparisons?
  ক

  =

  খ

  ==

  গ

  <=

  ঘ

  >=
• Which subquery cannot be executed by itself as a separate statement?
  ক

  Correlated

  খ

  Uncorrelated

  গ

  EXISTS

  ঘ

  NOT EXISTS
• An uncorrelated subquery does not contain any reference to the values from the outer query.
  ক

  True

  খ

  False
• Which operators test whether a subquery returns any rows?
  ক

  IN and NOT IN

  খ

  EXISTS and NOT EXISTS

  গ

  PRESENT

  ঘ

  ABSENT
• Which of these operators perform similar operations like ALL and ANY?
  ক

  SOME

  খ

  MANY

  গ

  SELECT

  ঘ

  GROUP
• The ALL subquery performs which operation?
  ক

  row

  খ

  column

  গ

  table

  ঘ

  database
• Which operators are used when a subquery returns multiple rows to be evaluated in comparison to the outer query?
  ক

  IN and NOT IN

  খ

  EXISTS and NOT EXISTS

  গ

  OUTER JOIN and INNER JOIN

  ঘ

  LEFT JOIN and RIGHT JOIN
• Usage of aggregates in WHERE clause is allowed.
  ক

  True

  খ

  False
• Which subquery returns a single value?
  ক

  scalar

  খ

  column

  গ

  row

  ঘ

  table
• The facility that allows nesting one select statement into another is called __________
  ক

  nesting

  খ

  binding

  গ

  subquerying

  ঘ

  encapsulating
• The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ___________
  ক

  CARTESIAN JOIN

  খ

  CROSS JOIN

  গ

  INNER JOIN

  ঘ

  RIGHT JOIN
• In which join all the rows from the left table appear in the output irrespective of the content of the other table?
  ক

  RIGHT JOIN

  খ

  LEFT JOIN

  গ

  INNER JOIN

  ঘ

  OUTER JOIN
• What is joining a table to itself called?
  ক

  COMPLETE

  খ

  SELF

  গ

  OBSOLETE

  ঘ

  CROSS
• The left and right joins are also known as __________
  ক

  INNER JOIN

  খ

  NATURAL JOIN

  গ

  OUTER JOIN

  ঘ

  CARTESIAN JOIN
• The comma operator can also be used to join tables.
  ক

  True

  খ

  False
• CROSS JOIN and JOIN are similar to __________
  ক

  INNER JOIN

  খ

  NATURAL JOIN

  গ

  OUTER JOIN

  ঘ

  CARTESIAN JOIN
• The clause that filters JOIN results is called _________
  ক

  WHERE

  খ

  SORT

  গ

  GROUP

  ঘ

  GROUP BY
• The join where all possible row combinations are produced is called _________
  ক

  INNER JOIN

  খ

  OUTER

  গ

  NATURAL

  ঘ

  CARTESIAN
• In inner join, result is produced by matching rows in one table with rows in another table.
  ক

  True

  খ

  False
• SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional?
  ক

  select_list

  খ

  table_list

  গ

  row_constraint

  ঘ

  grouping_columns