Questions

SQL statements are broadly classified into three. They are

1. DDL – Data Definition Language

DDL is used to define the structure that holds the data. For example, Create, Alter, Drop and Truncate table.

2. DML – Data Manipulation Language

DML is used for manipulation of the data itself. Typical operations are Insert, Delete, Update and retrieving the data from the table. The Select statement is considered as a limited version of the DML, since it can't change the data in the database. But it can perform operations on data retrieved from the DBMS, before the results are returned to the calling function.

3. DCL – Data Control Language

DCL is used to control the visibility of data like granting database access and set privileges to create tables, etc. Example - Grant, Revoke access permission to the user to access data in the database.

Data Control Language takes caare of security and authorization

The annual plan control is one of the four types of marketing control system. Annual plan control is essential in order to determine whether all the marketing efforts undertaken by the organisation has been really worthwhile or not. It aims to achieve sales volume,profits and all those objectives which have been set up in the beginning of the year. In an organisation,the top management and middle level management are responsible for the annual plan control. They have to keep a check on the activities undertaken to implement the plans.

A nanosecond (ns) is an SI unit of time equal to one thousand-millionth of a second or one billionth of a second.

• That is, 1/1,000,000,000 of a second, or 10^−9 seconds.

The study of trees is called Dendrology.

Adi Sankara