Sql Miscellaneous MCQ

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

• Which of the following do you need to consider when you make a table in SQL?
  ক

  Data types

  খ

  Primary keys

  গ

  Default values

  ঘ

  All of the above.
• The SQL WHERE clause:
  ক

  limits the row data are returned.

  খ

  limits the column data that are returned.

  গ

  Both A and B are correct.

  ঘ

  Neither A nor B are correct.
• What SQL command can be used to add columns to a table?
  ক

  ALTER TABLE TableName ADD ColumnName

  খ

  ALTER TABLE TableName ADD COLUMN ColumnName

  গ

  MODIFY TABLE TableName ADD ColumnName

  ঘ

  MODIFY TABLE TableName ADD COLUMN ColumnName
• What SQL command can be used to delete columns from a table?
  ক

  MODIFY TABLE TableName DROP ColumnName

  খ

  MODIFY TABLE TableName DROP COLUMN ColumnName

  গ

  ALTER TABLE TableName DROP ColumnName

  ঘ

  ALTER TABLE TableName DROP COLUMN ColumnName
• When using the SQL INSERT statement:
  ক

  rows cannot be copied in mass from one table to another only.

  খ

  rows can be modified according to criteria only.

  গ

  rows can either be inserted into a table one at a time or in groups.

  ঘ

  rows can be inserted into a table only one at a time only.
• What is an SQL virtual table that is constructed from other tables?
  ক

  view

  খ

  A relation

  গ

  Just another table

  ঘ

  Query results
• Which of the following is NOT a type of SQL constraint?
  ক

  PRIMARY KEY

  খ

  ALTERNATE KEY

  গ

  FOREIGN KEY

  ঘ

  UNIQUE