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.

#include<stdio.h>
int main(){

    int a[10],i,n,m,c=0,l,u,mid;

    printf("Enter the size of an array: ");
    scanf("%d",&n);

    printf("Enter the elements in ascending order: ");
    for(i=0;i<n;i++){
         scanf("%d",&a[i]);
    }

    printf("Enter the number to be search: ");
    scanf("%d",&m);

    l=0,u=n-1;
    while(l<=u){
         mid=(l+u)/2;
         if(m==a[mid]){
             c=1;
             break;
         }
         else if(m<a[mid]){
             u=mid-1;
         }
         else
             l=mid+1;
    }
    if(c==0)
         printf("The number is not found.");
    else
         printf("The number is found.");

    return 0;
}

Sample output:
Enter the size of an array: 5
Enter the elements in ascending order: 4 7 8 11 21
Enter the number to be search: 11
The number is found.

Conditions suitable for the formation of a tornado develop when varying temperatures and humidity come together and form thunderclouds. This refers to the presence of warm and moist condition in the lower atmosphere and cold and dry conditions in the upper atmosphere. The place where these varying masses of air meet is known as the dry-line. Such conditions, which are suitable for the formation of a tornado, are most often observed just before a low pressure system develops.

Once the ideal conditions occur, the warm air tries to rise in the atmosphere, while the cold air blocks it. This makes the air in between rotate horizontally. In the meanwhile, the land is heated by the Sun, and hence, the air near the ground becomes warm and starts rising. Continuous fueling by the heat energy from the Sun ensures that the warm air has an upper hand over cold air. As a result of this, the cold air at the top starts sinking and the warm air below starts rising in a spinning motion. As the amount of warm air increases, the formation gains height and becomes intense. The intensity of these devastating tornadoes is such that they can clear off anything that comes in their path.

This orbital velocity at the moon is less because orbital velocity = rg

where 'r ' is the orbital radius. i.e the distance of the body from the center of the earth and 'g' is the acceleration due to gravity on the body in question. In the case of the moon, both r and g are less than in the case of the earth.

The population is the smallest unit of living organisms that can undergo evolution.

1   2