Multiple MCQ

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

• Which keyword is used to delete all the rows from the table?
  ক

  TRUNCATE

  খ

  REMOVE

  গ

  DELETE ALL

  ঘ

  CLEAR
• Which keyword in the UPDATE statement is used to assign values to columns?
  ক

  ASSIGN

  খ

  SET

  গ

  MARK

  ঘ

  GET
• UPDATE statement is a DML statement. What does DML stand for?
  ক

  Data Manipulation Language

  খ

  Data Manipulation Level

  গ

  Data Markup Language

  ঘ

  Data Markup Level
• Qualifying the name of column with the table name is not necessary in single-table updates.
  ক

  True

  খ

  False
• A multiple-table delete can apply any join.
  ক

  True

  খ

  False
• To perform a delete on a single-table, how is the name of a column qualified?
  ক

  qualification not necessary

  খ

  column name

  গ

  table name

  ঘ

  database name