1. Introduction to SQL

Question 1

Purpose of SQL

Answer 1

A generic language that any relational DB can understand and execute.

Question 2

Key-Value DBs, Column-based DBs, Graph DBs, Document DBs are all examples of _ DBs

Answer 2

NoSQL (non-relational)

Question 3

CREATE TABLE, ALTER TABLE, DROP TABLE commands fall under _ family of SQL commands

Answer 3

DDL (Data Definition Language)

Question 4

INSERT INTO, UPDATE SET, DELETE FROM commands fall under _ family of SQL commands.

Answer 4

DML (Data Manipulation Language)

Question 5

SELECT command falls under _ family of SQL commands.

Answer 5

DQL (Data Query Language)

Question 6

1. _ is created or altered or dropped.
2. _ is inserted or updated or deleted.

(Row/Table)

Answer 6

1. Table
2. Row