Simplified guide of MCQs for Exams, Interviews

Sub Topic: SQL

1 .  Which of the following is a legal expression in SQL?

  • A. SELECT NULL FROM SALES;
  • B. SELECT NAME FROM SALES;
  • C. SELECT * FROM SALES WHEN PRICE = NULL;
  • D. SELECT # FROM SALES;

Correct Answer:

SELECT NAME FROM SALES;


2 .  DCL provides commands to performactionslike

  • A. Change thestructureof Tables
  • B. Insert, Update or Delete Records and Values
  • C. Authorizing Access and othercontrolover Database
  • D. None of Above

Correct Answer:

Authorizing Access and othercontrolover Database


3 .  The COUNT function in SQL returns the number of ______________

  • A. Values
  • B. Distinct values
  • C. Group By
  • D. Columns

Correct Answer:

Values


4 .  Which data type can store unstructured data in a column?

  • A. RAW
  • B. CHAR
  • C. NUMERIC
  • D. VARCHAR

Correct Answer:

RAW


5 .  Which function is used to divides one numeric expression by another and get the remainder ?

  • A. POWER
  • B. MOD
  • C. ROUND
  • D. REMAINDER

Correct Answer:

MOD


6 .  What is the full form of DDL ?

  • A. Dynamic Data Language
  • B. Detailed Data Language
  • C. Data Definition Language
  • D. Data Derivation Language

Correct Answer:

Data Definition Language


7 .  A database language used for defining the whole databasestructureand schema is called :

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

Correct Answer:

DDL


8 .  The virtual table that its created by data from the result of an SQL Select statement is called _________

  • A. View
  • B. Synonym
  • C. Sequence
  • D. Transaction

Correct Answer:

View


9 .  Which statement in SQL allows us to change the definition of a table is?

  • A. ALTER
  • B. UPDATE
  • C. CREATE
  • D. SELECT

Correct Answer:

ALTER