Q:

Difference between Union and Union all?

Answer

The difference between Union and Union all is that Union all will not eliminate duplicate rows, instead it just pulls all rows from all tables fitting your query specifics and combines them into a table. A UNION statement effectively does a SELECT DISTINCT on the results set.

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Analyst , Database Administration , IT Trainer , Software Architect

1 1940

Q:

If an animal is an ectotherm, it has?

A) A skeleton on the inside of its body	B) A body that does not produce much internal heat
C) A skeleton on the outside of its body	D) A body that regulates its own internal temperature

Answer & Explanation Answer: B) A body that does not produce much internal heat

Explanation:

Report Error

View Answer Report Error Discuss

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

2 1939

Q:

When was World Meterological Organisation estabilished?

A) 1950	B) 1952
C) 1956	D) 1949

Answer & Explanation Answer: A) 1950

Explanation:

Report Error

View Answer Report Error Discuss

Filed Under: World Organisations

5 1939

Q:

In what way is geography an integrative science?

A) Geography is an integrative science because it borrows from physical sciences such as chemistry, biology, meterology, and geology	B) Geography is an integrative science because it borrows from human science such as cultural studies , economics , and public policy
C) Geography is an integrative science because it examines Earth in both physical and human terms	D) All of the above

Answer & Explanation Answer: C) Geography is an integrative science because it examines Earth in both physical and human terms

Explanation:

Report Error

View Answer Report Error Discuss

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

1 1939

Q:

A person who does not believe in any religion

A) Atheist	B) Rationalist
C) Pagan	D) Philatelist

Answer & Explanation Answer: A) Atheist

Explanation:

A person who does not believe in any religion or god is called as Atheist.

Report Error

View Answer Report Error Discuss

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

0 1938

Q:

Vinegar is __________ .

A) diluted acetic acid	B) glacial acetic acid
C) glacial formic acid	D) diluted formic acid

Answer & Explanation Answer: A) diluted acetic acid

Explanation:

Report Error

View Answer Report Error Discuss

Filed Under: Chemistry

1 1938

Q:

In which of the following state its first mega food park was inaugurated?

A) Karnataka	B) Telangana
C) Gujarat	D) Punjab

Answer & Explanation Answer: C) Gujarat

Explanation:

Report Error

View Answer Report Error Discuss

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

0 1938

Q:

What is flag?

Answer

Flag is a flip-flop used to store the information about the status of a processor and the status of the insturction executed most recently.

A software or hardware mark that signals a particular condition or status. A flag is like a switch that can be either on or off. The flag said to be set when it is turned on.

Questions

Quick Links