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.

Since, the sentence starts talking about the leader of the opposition, the connecting statement will be R as it carries a relative pronoun ‘who’ which relates the sentences. S follows as it states the disappointment of the leader and the next statement talked about the reason of disappointment. P would be the concluding statement as it goes with the flow describing how the leader decided to convince the assembly and thus makes a coherent paragraph.

The correct formation would be, ‘The leader of the opposition who had a reputation for speech making was very much disappointed on realising that he had failed to convince the assembly in the manner he had planned to convince them’.

Salinity is often high in enclosed seas, this is due to high temperature, rapid evaparation and little inflow of fresh water.

Bus Interface Unit and Execution unit, are the two different functional units in 8086.

Black soils are rich in montmorillonitic and beidellitic group of clay minerals and are poor in nitrogen, phosphorus and organic matter. Black soils are most suitable for the cotton crop hence it is also known as black cotton soil. Besides cotton, the soil is suitable for the cultivation of crops like wheat, groundnut, chillies, tobacco and jowar.

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.