Finals

Question 1

SQL stands for

Answer 1

Structured Query Language

Question 2

SQL enables user to ________.

Answer 2

Create, read, update and delete

Question 3

Components included in SQL process

Answer 3

Engine, Query Engine, Query Dispatcher, Classic

Question 4

Advantages of SQL

Answer 4

High Speed
No Coding Needed
Well defined standards
Portablility
Interactive language
Multiple data view

Question 5

SQL Datatype is used to define the _________

Answer 5

Value that a column contains

Question 6

SQL is used to perform

Answer 6

Specific tasks
Functions
Queries of datas

Question 7

SQL can perform various task like

Answer 7

Create a table
Add data to the table
Drop the table
Modify the table
Set permissions for users

Question 8

5 types of SQL commands

Answer 8

DDL / DML / DCL / TCL /DQL

Question 9

DDL stands for

Answer 9

Data Definition Language

Question 10

DML

Answer 10

Data Manipulation Language

Question 11

DCL

Answer 11

Data Control Language

Question 12

TCL

Answer 12

Transaction Control Language

Question 13

DQL

Answer 13

Data Query Language

Question 14

RDBMS

Answer 14

Relation Database Management System

Question 15

Select Distinct statement is used ________

Answer 15

To return only distinct or different values