SQL For Database Construction MCQ

Test your knowledge with important SQL For Database Construction MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more SQL For Database Construction MCQs on Bissoy. Bissoy App

• Views can be used to show the results of computed columns.
  ক

  True

  খ

  False
• When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.
  ক

  True

  খ

  False
• What is an advantage of placing computations in SQL views?
  ক

  To save users from having to write an expression.

  খ

  To ensure that the results are consistent.

  গ

  To accomplish both of the above.

  ঘ

  None of the above is correct - computations cannot be placed in a view.
• Which is NOT one of the most common types of SQL CHECK constraints?
  ক

  System date

  খ

  Range checks

  গ

  Lists of values

  ঘ

  Comparing one column value to another within the same table
• What SQL structure is used to limit column values of a table?
  ক

  The LIMIT constraint

  খ

  The CHECK constraint

  গ

  The VALUE constraint

  ঘ

  None of the above is correct.
• What is not an advantage of stored procedures?
  ক

  Greater security

  খ

  SQL can be optimized

  গ

  Code sharing

  ঘ

  Increased network traffic