SQL - Overview

Question 1

Identification

is a database computer language designed for the retrieval and management of data in a relational database.

Answer 1

SQL

Question 2

Identification

SQL stands for

Answer 2

Structured Query Language

Question 3

Identification

is a computer language for storing, manipulating
and retrieving data stored in a relational database

Answer 3

SQL

Question 4

History of SQL

is known as the father of relational databases. He described a relational model for databases.

Answer 4

Dr. Edgar F. “Ted” Codd (1970)

Question 5

History of SQL

Structured Query Language appeared in

Answer 5

1974

Question 6

History of SQL

IBM worked to develop Codd’s ideas and released a product named System/R in

Answer 6

1978

Question 7

History of SQL

IBM developed the first prototype of relational database and standardized by ANSI. The first relational database was released by Relational Software which later came to be known as Oracle.

Answer 7

1986

Question 8

Identification

The first relational database was released by_____ and later came to be known as _______.

Answer 8

Relational Software; Oracle

Question 9

SQL Process

Components included in the process of executing SQL commands

Answer 9

• Query Dispatcher
• Optimization Engines
• Classic Query Engine
• SQL Query Engine, etc.

Question 10

SQL Process

This engine handles all the non-SQL queries

Answer 10

classic query engine

Question 11

SQL Process

This engine won’t handle logical files

Answer 11

SQL query engine

Question 12

SQL Process

SQL architecture

Answer 12

SQL query > Query Language processor > DBMS engine > Physical Database

Question 13

SQL Commands

The standard SQL commands to interact with relational databases are

Answer 13

1. CREATE
2. SELECT
3. INSERT
4. UPDATE
5. DELETE
6. DROP

Question 14

SQL Command Classification

CREATE, ALTER and DROP are classified into what group of SQL command?

Answer 14

DDL - Data Definition Language

Question 15

SQL Command Classification

SELECT, INSERT, UPDATE, DELETE are classified into what group of SQL command?

Answer 15

DML - Data Manipulation Language

Question 16

SQL Command Classification

GRANT, REVOKE are classified into what group of SQL command?

Answer 16

DCL - Data Control Language

Question 17

SQL Commands

Creates a new table, a view of a table, or other object in the database.

Answer 17

CREATE

DDL - Data Definition Language

Question 18

SQL Commands

Modifies an existing database object, such as a table.

Answer 18

ALTER

DDL - Data Definition Language

Question 19

SQL Commands

Deletes an entire table, a view of a table or other objects in the database.

Answer 19

DROP

DDL - Data Definition Language

Question 20

SQL Commands

Retrieves certain records from one or more tables.

Answer 20

SELECT

DML - Data Manipulation Language

Question 21

SQL Commands

Creates a record

Answer 21

INSERT

DML - Data Manipulation Language

Question 22

SQL Commands

Modifies records.

Answer 22

UPDATE

DML - Data Manipulation Language

Question 23

SQL Commands

Deletes records.

Answer 23

DELETE

DML - Data Manipulation Language

Question 24

SQL Commands

Gives a privilege to user.

Answer 24

GRANT

DCL - Data Control Language

Question 25

SQL Commands

Takes back privileges granted from user.

Answer 25

REVOKE

DCL - Data Control Language