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

Fat is completely digested in the

A) small intestine B) mouth
C) large intestine D) stomach
 
Answer & Explanation Answer: A) small intestine

Explanation:

Fat is completely digested in the small intestine of the body.

Report Error

View Answer Report Error Discuss

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

4 2837
Q:

Read the passage carefully and choose the best answer to each question out of the four alternatives and click the button corresponding to it.


Dyslexia is a perceptual disorder often occurring in persons of normal, or even above average intelligence. The reader is unable to perceive correctly what is on a page. Letters and numbers often appear reversed: "b" seems to be "d","quite" is "quiet" and "from" is "form". The reader tends to leave out letters or words or insert words or letters that are not there. Vowel and consonant sounds may be confused. Many dyslexics are left­handed or able to write with either hand. They often confuse left and right. Learning to speak may also be delayed beyond infancy. The condition seems to be inherited. It may persist into adulthood. However, with early recognition and specialized approaches to teaching reading, most dyslexics can learn to read.

Some researchers believe that latent dyslexia may be aggravated by the way reading is taught. The modern whole­word, or look­and­say, method seems to be more of a hindrance to learning for dyslexics than it is for ordinary pupils. The phonetic method of teaching students to learn letters and sound them out appears to achieve better reading results. The problem of words that cannot be sounded out ­ such as rough, laugh or through ­ is not solved by phonetics. These words must simply be memorized. However, for children with dyslexia the problem can be compounded by the failure of parents or teachers to recognize the condition. This can easily lead to emotional problems for dyslexic children, who cannot understand their failure to keep up with their classmates.


In Dyslexia, letters and figures often appear __________

A) Inverted B) Blurred
C) Reversed D) Clustered
 
Answer & Explanation Answer: C) Reversed

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: Bank Exams

0 2837
Q:

The brain and spinal cord are two components of the

A) Central nervous system B) Peripheral nervous system
C) Both A & B D) None of the above
 
Answer & Explanation Answer: A) Central nervous system

Explanation:

The brain and spinal cord are two components of the Central nervous system which are responsible for sensory information.

Report Error

View Answer Report Error Discuss

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

3 2836
Q:

Who is the the author and composer of the National Anthem (Jana Gana Mana) of India?

A) Rabindranath Tagore B) Bankim Chandra Chatterjee
C) Muhammad Iqbal D) Ram Singh Thakur
 
Answer & Explanation Answer: A) Rabindranath Tagore

Explanation:
Report Error

View Answer Report Error Discuss

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

4 2835
Q:

The sea with one of the highest salinities in the world is _________

A) the Dead Sea B) the Red Sea
C) the Arabian Sea D) the Baltic Sea
 
Answer & Explanation Answer: A) the Dead Sea

Explanation:

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

Report Error

View Answer Report Error Discuss

Filed Under: World Geography

1 2835
Q:

The speed of a boat when travelling downstream is 32 km/h, whereas when travelling upstream it is 28 km/h. What is the speed of the boat in still water?

A) 27 km/h B) 29 km/h
C) 31 km/h D) Cannot be determined
 
Answer & Explanation Answer:

Explanation:

Ans.  Suppose the speed of boat in still water is x km/h and speed of stream is y km/h

Speedof boat in downstream = (x + y) km/h x+ y = 32 …(i) 

Speed of boat in upstream = (x – y) km/h

x – y = 28 …(ii)

Add. Eqs. (i) and (ii), we get 2x = 60

x = 30 km/h

 

 

 

Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: CAT , GRE , TOEFL

0 2835
Q:

Read the passage carefully and choose the best answer to each question out of the four alternatives and click the button corresponding to it.

It's nothing short of a revolution in how we eat, and it's getting closer every day. Yes, a lot of people are obese, and yes, the definition of "healthy eating" seems to change all the time. But in labs and research centres around the world, scientists are racing to match our genes and our taste buds, creating the perfect diet for each of us, a diet that will fight disease, increase longevity, boost physical and mental performance, and taste great to boot. As food scientist J.Bruce German says, "The foods we like the most will be the most healthy for us."

Is that going to be a great day, or what?

All this will come to pass, thanks to genomics, the science that maps and describes an individual's genetic code. In the future, personalized DNA chips will allow us to assess our own inherited predispositions for certain diseases, then adjust our diets accordingly. So, if you're at risk for heart disease, you won't just go on a generic low-fat diet. You'll eat foods with just the right amount and type of fat that's best for you. You'll even be able to track your metabolism day-to-day to determine what foods you should eat at any given time, for any given activity. "Since people differ in their genetics and metabolism, one diet won't fit all," says German. As complex as all this sounds, it could turn out to be relatively simple.

What will be possible in the future?

A) Personalised DNA chips for people to assess their own inherited predispositions B) You are at great risk for heart disease
C) You will not be able to determine what food you should eat D) You will be unable to adjust your diet
 
Answer & Explanation Answer: A) Personalised DNA chips for people to assess their own inherited predispositions

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: Bank Exams

0 2834