DDL Command MCQ

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

• Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:
  ক

  TRUNCATE command

  খ

  Create command

  গ

  Drop table command

  ঘ

  Alter table command
• Which command is used for removing a table and all its data from the database:
  ক

  Create command

  খ

  Drop table command

  গ

  Alter table command

  ঘ

  All of the Mentioned
• Which command defines its columns, integrity constraint in create table:
  ক

  Create command

  খ

  Drop table command

  গ

  Alter table command

  ঘ

  All of the Mentioned
• SQL has how many main commands for DDL:
  ক

  1

  খ

  2

  গ

  3

  ঘ

  4
• ___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
  ক

  Column

  খ

  Constraint

  গ

  Index

  ঘ

  Trigger
• ________clause is an additional filter that is applied to the result.
  ক

  Select

  খ

  Group-by

  গ

  Having

  ঘ

  Order by
• In SQL, which of the following is not a data definition language commands?
  ক

  RENAME

  খ

  REVOKE

  গ

  GRANT

  ঘ

  UPDATE
• In SQL, which command(s) is(are) used to change a table’s storage characteristics?
  ক

  ALTER TABLE

  খ

  MODIFY TABLE

  গ

  CHANGE TABLE

  ঘ

  All of the Mentioned
• Which of the following is/are the DDL statements?
  ক

  Create

  খ

  Drop

  গ

  Alter

  ঘ

  All of the Mentioned