DML Command MCQ

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

• The three language components of a database management system (DBMS) like DDL, DCL, DML. Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DBMS usually deal with?
  ক

  DDL

  খ

  DML

  গ

  DDL and DCL

  ঘ

  DCL and DML
• A type of query that is placed within a WHERE or HAVING clause of another query is called
  ক

  Master query

  খ

  Sub query

  গ

  Super query

  ঘ

  Multi-query
• A table that displays data redundancies yields ____________ anomalies.
  ক

  Update

  খ

  Insertion

  গ

  Deletion

  ঘ

  All of the Mentioned
• Stack is also called __________
  ক

  First In First Out (LIFO)

  খ

  Last In First Out (FIFO)

  গ

  First In Last Out (FILO)

  ঘ

  First Come First Served (FCFS)
• In SQL, which command is used to add new rows to a table?
  ক

  Alter Table

  খ

  Add row

  গ

  Insert

  ঘ

  Append
• TRUNCATE statement in SQL is a –
  ক

  DML statement

  খ

  DDL statement

  গ

  DCL statement

  ঘ

  TCL statement
• Which of the following is not included in DML (Data Manipulation Language)
  ক

  INSERT

  খ

  UPDATE

  গ

  DELETE

  ঘ

  CREATE
• In SQL, which of the following is not a data Manipulation Language Commands?
  ক

  Delete

  খ

  Truncate

  গ

  Update

  ঘ

  Create
• The language used application programs to request data from the DBMS is referred to as __________
  ক

  DML

  খ

  DDL

  গ

  Query language

  ঘ

  All of the Mentioned