Simplified guide of MCQs for Exams, Interviews

Sub Topic: SQL

1 .  The SQL used by front-end application programs to request data from the DBMS is called _______

  • A. DML
  • B. DDL
  • C. VDL
  • D. SDL

Correct Answer:

DML


2 .  The command used to delete a particular column in a relation is ____________

  • A. UPDATE TABLE
  • B. TRUNCATE COLUMN
  • C. ALTER , DROP
  • D. DELETE COLUMN

Correct Answer:

ALTER , DROP


3 .  Which of the following operations requires the relations to be union compatible?

  • A. UNION
  • B. INTERSECTION
  • C. DIFFERENCE
  • D. ALL OF THESE

Correct Answer:

ALL OF THESE


4 .  The database language that allows us to access data in a database is called :

  • A. DCL
  • B. DML
  • C. DDL
  • D. None Of Above

Correct Answer:

DCL


5 .  Which of the following is a comparison operator in SQL?

  • A. Double equal sign ( == )
  • B. LIKE
  • C. BETWEEN
  • D. Single equal sign ( = )

Correct Answer:

Double equal sign ( == )


6 .  Which data manipulation command is used to combines the records from one or more tables?

  • A. SELECT
  • B. PROJECT
  • C. JOIN
  • D. PRODUCT

Correct Answer:

JOIN


7 .  Which of the following is not a valid SQL type?

  • A. DECIMAL
  • B. NUMERIC
  • C. FLOAT
  • D. CHARACTER

Correct Answer:

DECIMAL


8 .  SQL permits attribute names to be repeated in the same relation. (True or False)

  • A. FALSE
  • B. TRUE
  • C.
  • D.

Correct Answer:

FALSE


9 .  Which operator is used to compare a value to a specified list of values?

  • A. BETWEEN
  • B. ANY
  • C. IN
  • D. ALL

Correct Answer:

IN


10 .  A SQL query automatically eliminates duplicates (True / False) ?

  • A. TRUE
  • B. FALSE
  • C.
  • D.

Correct Answer:

FALSE