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.

1. char arr[NUMSLOTS(50)];

2. SET (arr, 20);

3. if (TEST (arr, 40))

Heat energy can be transferred by three major methods. They are 

1. Conduction,

2. Convection and

3. Radiation.

Conduction is the movement of heat through a substance by the collision of molecules

Convection occurs when particles with a lot of heat energy in a liquid or gas move and take the place of particles with less heat energy.

Radiation is the transfer of energy by means of photons in electromagnetic waves governed by the same laws. It occurs through a vacuum or any transparent medium.

The National Association of Software and Services Companies (Nasscom) appointed Raman Roy (Managing Director of Quatrro Global Services) as its chairman for 2017-2018.

 Rishad Premji (Chief Strategy Officer (CSO), Wipro Limited) has been appointed Vice Chairman. Raman Roy has replaced Mr. CP Gurnani.

According to Rayleigh's law, the intensity of scattered light varies inversely as the fourth power of its wavelength. Sunlight consists of seven colours. Of these, red has the maximum wavelength. During sunrise and sunset, the rays have to travel a larger part of the atmosphere because they are very close to the horizon.Therefore, light other than red is mostly scattered away. Most of the red light, which is the least scattered, enters our eyes. Hence, the sun and the sky appear red.

Many toxic gases along with water vapour are emitted in vocanic eruptions. All such toxic gases include hydrochloric acid, sulfur dioxide, carbon dioxide, hydrogen sulfide and carbon monoxide. Methane is not produced in the volcanic eruptions.