Questions

Q:

What are the different types of SQL statements ?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

4 2383
Q:

Genes contain instructions for assembling what?

A) Amino acids B) Proteins
C) Nucleotides D) All of the above
 
Answer & Explanation Answer: B) Proteins

Explanation:

Genes which are segment of DNA of a cell contains instructions for assembling proteins.

Report Error

View Answer Report Error Discuss

Filed Under: Biology
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank Clerk , Bank PO

5 2383
Q:

Closely stacked flattened sacs (plants only)

A) Vacuoles B) Lysosomes
C) Golgi apparatus D) None of the above
 
Answer & Explanation Answer: C) Golgi apparatus

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Biology
Exam Prep: AIEEE
Job Role: Analyst , Bank Clerk

4 2382
Q:

Which best describes the meaning of the term theorem?

A) A conclusion proved by deductive reasoning B) A statement explaining the meaning of a geometric term
C) A conjecture based on inductive reasoning D) A statement that is accepted as true without proof
 
Answer & Explanation Answer: A) A conclusion proved by deductive reasoning

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE , TOEFL
Job Role: Analyst , Bank Clerk , Bank PO

0 2381
Q:

Write a c program for binary search.

Answer

#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.

Report Error

View answer Workspace Report Error Discuss

Subject: Programming

0 2381
Q:

One of the following companies does have business interest in both oil and shipping sectors. Identify this.

A) Tata Group B) Reliance Group
C) Essar Group D) ONGC
 
Answer & Explanation Answer: C) Essar Group

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Business Awareness

6 2381
Q:

A project in PMP can be defined as a :

A) Permanent endeavor that produces repetitive outputs B) Temporary endeavor undertaken to create a unique product, service, or result
C) Permanent endeavor undertaken to create a unique product, service, or result D) Temporary endeavor that produces repetitive outputs
 
Answer & Explanation Answer: B) Temporary endeavor undertaken to create a unique product, service, or result

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: PMP Certification

6 2380
Q:

Which country has successfully launched the world's smallest rocket to carry tiny satellite into orbit?

A) India B) Russia
C) Japan D) Australia
 
Answer & Explanation Answer: C) Japan

Explanation:

Japan's - Japan Aerospace Exploration Agency (JAXA) has successfully launched the world's smallest rocket with the ability to put a tiny satellite into orbit. Rocket -  SS-520 which was pnce failed in 2017 lifted off from the Space Center carrying a microsatellite TRICOM-1R, a three-unit CubeSat weighing about 3 kilograms. The CubeSat will now be used to collect images of the Earth's surface via multiple cameras.

Report Error

View Answer Report Error Discuss

Filed Under: General Awareness
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

5 2380