Questions

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.

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 study of flags is called Vexillology and the art of flag design is called as Vexillography. The man who studies flags is called as Vexillologist.

The term panda bond refers to an indenture issued in China, in Chinese renminbi, by a foreign bank or corporation. The Pakistan cabinet approved the issuance of the maiden renminbi-denominated 'Panda Bonds' during its meeting presided over by Prime Minister.