Tag: databases

Questions Related to databases

is related to

  1. Index

  2. Page allocation

  3. Trigger creation

  4. None of the above


Correct Option: A
  1. Index

  2. Page deallocation

  3. Trigger creation

  4. None of the above


Correct Option: A

What does SQL stand for??

  1. Strong Question Language

  2. Structured Query Language

  3. Structured Question Language

  4. None of the Above


Correct Option: B
  1. SELECT, FROM , WHERE,GROUP BY, ORDER BY, HAVING?

  2. SELECT, FROM, WHERE, ORDER BY, HAVING,GROUP BY

  3. SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING

  4. SELECT, FROM , WHERE,GROUP BY, HAVING, ORDER BY


Correct Option: D
  1. UNION only selects distinct values, UNION ALL selects all values (excluding ?duplicates)?

  2. UNION ALL only selects distinct values, UNION selects all values (including ?duplicates)?

  3. UNION only selects distinct values, UNION ALL selects all values (including ?duplicates)?

  4. UNION ALL only selects distinct values, UNION selects all values (excluding ?duplicates)?


Correct Option: C