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 2293
Q:

Infection of salivary glands by a virus leads to 

A) tetanus B) mumps
C) pyorrhoea D) ulcers
 
Answer & Explanation Answer: B) mumps

Explanation:

Mumps: This is a swelling caused by inflammation of parotid glands placed in front of our ear region. The Inflammation is caused by a virus.

Report Error

View Answer Report Error Discuss

Filed Under: Biology

2 2293
Q:

Which of the following has introduced ‘style ideas’ on its Android app and web based search for fashion content ?

A) Amazon B) Flipkart
C) GOOGLE D) Microsoft
 
Answer & Explanation Answer: C) GOOGLE

Explanation:

To enhance user experience when searching for fashion content, Google on Thursday introduced a new feature called “style ideas” in Image Search on mobile web and in Google app for Android. “Style ideas” throws up high-quality images that show how someone will look while wearing or carrying the item you searched for.

Report Error

View Answer Report Error Discuss

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

2 2293
Q:

In the 10th Mandala of the Rigveda, which one of the following hymns reflects upon the marriage ceremonies?

A) Surya Sukta B) Purusha Sukta
C) Dana Stutis D) Urna Sutra
 
Answer & Explanation Answer: B) Purusha Sukta

Explanation:

surya sukta--a hymn in the praise of the sun god

•dana stuti--these are hymns in the praise of those who donate

•urna sutra--is the dot/mark on the forehead that is put before performing rituals.

•purusha sukta---contains hymns about marriage ceremonies

Report Error

View Answer Report Error Discuss

Filed Under: Indian History
Exam Prep: Bank Exams

1 2292
Q:

What is the functional unit of a skeletal muscle called?

A) Myofibril B) Sarcomere
C) Fiber D) Fasciculus
 
Answer & Explanation Answer: B) Sarcomere

Explanation:

The myofibrils are composed of actin and myosin filaments, repeated in units called sarcomeres, which are the basic functional units of the skeletal muscle.

Report Error

View Answer Report Error Discuss

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

2 2292
Q:

Consider the following statements about the Bureau of Pharma PSUs of India (BPPI):1. It is the implementing agency of Pradhan Mantri Bhartiya Janaushadhi Pariyojana (PMBJP).2. It has registered as an independent society under the Societies Registration Act, 1860.Which of the statements given above is/are correct?

A) 1 only B) 2 only
C) Both 1 and 2 D) Neither 1 nor 2
 
Answer & Explanation Answer: C) Both 1 and 2

Explanation:

Bureau of Pharma PSUs of India (BPPI) is the implementing agency of Pradhan Mantri Janaushadhi Pariyojana (PMBJP). BPPI was established in December2008 under the Department of Pharmaceuticals, Government of India. The Bureau has been registered as an independent society under the Societies RegistrationAct, 1860 as a separate independent legal entity in April, 2010. BPPI follows the provisions of GFR, 2017 as amended from time to time, the CVC guidelines, and instructions from the Department of Pharmaceuticals.

Report Error

View Answer Report Error Discuss

Filed Under: Indian Politics
Exam Prep: Bank Exams

0 2291
Q:

Instruments for measuring Solar Radiation?

A) Ammeter B) Pyranometer
C) Dynamometer D) Anemometer
 
Answer & Explanation Answer: B) Pyranometer

Explanation:

Solar radiation instruments may be produced to measure different types of solar energy. When sunlight encounters the Earth's atmosphere, some of it is absorbed or scattered by water vapor, aerosols, clouds, and other air molecules. The radiation which penetrates to the Earth's surface is termed direct solar radiation.

 

A thermopile pyranometer is a type of actinometer used for measuring solar radiation on a planar surface and it is designed to measure the solar radiation flux density (W/m2) from the hemisphere above within a wavelength range 0.3 μm to 3 μm.

Report Error

View Answer Report Error Discuss

Filed Under: Physics
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO , IT Trainer

6 2291
Q:

In which Olympics India has won the most number of medals?

A) Rio Olympics 2016 B) Beijing Olympics 2008
C) London Olympics 2012 D) Athens Olympics 2004
 
Answer & Explanation Answer: C) London Olympics 2012

Explanation:

Upto now, India has won 28 medals in Olympics from 1896 - 2016. In that

 

Rio Olympics 2016  - 02

Beijing Olympics 2008 - 03

London Olympics 2012 - 06

Athens Olympics 2004 - 01

 

Hence, India has won most number of medals in 2012 Rio Olympics.

Report Error

View Answer Report Error Discuss

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

2 2291