SQL MCQ

Test your knowledge with important SQL MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more SQL 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
• Embedded SQL is which of the following?
  ক

  The process of making an application capable of generating specific SQL code on the fly.

  খ

  Hard-coded SQL statements in a trigger.

  গ

  Hard-coded SQL statements in a program language such as Java.

  ঘ

  Hard-coded SQL statements in a procedure.
• Which of the following is not a relational database?
  ক

  4th Dimension

  খ

  Reflex

  গ

  dBASE IV

  ঘ

  FoxPro
• Which one of the following sorts rows in SQL?
  ক

  Sort By

  খ

  Align By

  গ

  Group By

  ঘ

  Order By