Introduction to SQL & Special Operators

Question 1

The standard language for
relational database management
systems. It stands for Structured
Query Language.

Answer 1

SQL

Question 2

for defining database structure

Answer 2

DDL

Question 3

for retrieving and updating data

Answer 3

DML

Question 4

for controlled access to the database

Answer 4

DCL

Question 5

DDL Constructs

Answer 5

• CREATE TABLE, CREATE
  VIEWS, CREATE INDEX
• ALTER TABLE, DROP TABLE,
  DROP VIEWS

Question 6

DML Constructs

Answer 6

• INSERT
• UPDATE
• DELETE
• SELECT

Question 7

DCL Constructs

Answer 7

• GRANT
• REVOKE

Question 8

Determines whether the value of an
expression falls within a specified range
of values.

Answer 8

BETWEEN…AND

Question 9

Determines whether the value of an
expression is equal to any of several
values in a specified list.

Answer 9

IN

Question 10

Checks for missing data or null values.

Answer 10

IS NULL