SQL Basics and SQL Data Definition MCQ

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

• Updates that violate __________ are disallowed.
  ক

  Integrity constraints

  খ

  Transaction control

  গ

  Authorization

  ঘ

  DDL constraints
• To remove a relation from an SQL database, we use the ______ command.
  ক

  Delete

  খ

  Purge

  গ

  Remove

  ঘ

  Drop table
• An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces.
  ক

  3, 20

  খ

  20, 4

  গ

  20, 20

  ঘ

  3, 4
• The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.
  ক

  Fixed, equal

  খ

  Equal, variable

  গ

  Fixed, variable

  ঘ

  Variable, equal
• Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
  ক

  DML(Data Manipulation Langauge)

  খ

  DDL(Data Definition Langauge)

  গ

  Query

  ঘ

  Relational Schema
• Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
  ক

  DML(Data Manipulation Langauge)

  খ

  DDL(Data Definition Langauge)

  গ

  Query

  ঘ

  Relational Schema