Sawaal
  • Home/
  • Searching for If

 Searching for "If"

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.

Report Error

View answer Workspace Report Error Discuss

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

Q:

Solve the Riddle :: Three men were on a boat that was stuck one mile from the shore.

One was afraid of Sharks. The other couldn't Swim. And the last one didn't have a life jacket. However, they reached the shore without any problems. How did they do it?

Answer

They walked and did this.


It was never specified that the boat was at sea. Since this logic is observed by them to tackle situation.

Report Error

View answer Workspace Report Error Discuss

Subject: Logic Puzzles Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer , Network Engineer , Project Manager , Software Architect

Q:

Tilak rides on a cycle to a place at speed of 22 kmph and comes back at a speed of 20 kmph. If the time taken by him in the second case is 36 min. more than that of the first case, what is the total distance travelled by him (in km)?

A) 132 km B) 264 km
C) 134 km D) 236 km
 
Answer & Explanation Answer: B) 264 km

Explanation:

Let the distance travelled by Tilak in first case or second case = d kms

Now, from the given data,

d/20 = d/22 + 36 min

=> d/20 = d/22 + 3/5 hrs

=> d = 132 km.

 

Hence, the total distance travelled by him = d + d = 132 + 132 = 264 kms.

Report Error

View Answer Report Error Discuss

Filed Under: Time and Distance
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

Q:

The Hardest Logic Puzzle Ever?

If a giraffe has two eyes, a monkey has two eyes, and an elephant has two eyes, how many eyes do we have?

A) 3 B) 4
C) 1 D) 2
 
Answer & Explanation Answer: B) 4

Explanation:

4 eyes.

Here in the question, it is asked how many Eyes We have so that means here the person who has asked the question is also including the person who is suppose to give the answer. In a clear understanding, the Conversation is happening between 2 people 1st who asked the question and 2nd to whom it has been asked, which means there are 4 eyes.

Report Error

View Answer Report Error Discuss

Filed Under: Logic Puzzles
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

Q:

If the price of a commodity is decreased by 20% and its consumption is increased by 10%, what will be the increase or decrease in the expenditure on the commodity?

A) increase 12% B) decrease 12%
C) increase 16% D) decrease 16%
 
Answer & Explanation Answer: B) decrease 12%

Explanation:

Given the price of a commodity is decreased by  p = 20%

And its consumption is increased by q = 10%

Now, required increase or decrease in the expenditure on the commodity can be 

p + q + pq/100 = -20 + 10 - 200/100 = -10 - 2 = -12%.

 

Hence, decrease in the expenditure = 12%

 

Report Error

View Answer Report Error Discuss

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

Q:

Where is a hub specified in the OSI model?

A) Data link layer B) Session layer
C) Application Layer D) Physical layer
 
Answer & Explanation Answer: D) Physical layer

Explanation:

Hubs are specified or operate at Layer1 i.e, the physical layer in the OSI model. Hubs regenerate electrical signals. A hub sends data packets (frames) to all devices on a network, regardless of any MAC addresses contained in the data packet.

Report Error

View Answer Report Error Discuss

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

Q:

A train covers 180 km distance in 5 hours. Another train covers the same distance in 1 hour less. What is the difference in the distances covered by these trains in one hour if they are moving in the same direction?

A) 15 kms B) 9 kms
C) 6 kms D) 18 kms
 
Answer & Explanation Answer: B) 9 kms

Explanation:

The first train covers 180 kms in 5 hrs

=> Speed = 180/5 = 36 kmph

Now the second train covers the same distance in 1 hour less than the first train => 4 hrs

=> Speed of the second train = 180/4 = 45 kmph

Now, required difference in distance in 1 hour = 45 - 36 = 9 kms.

Report Error

View Answer Report Error Discuss

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

Q:

Which of the following is the fastest communication channel?

A) Microwave B) Optical fiber
C) Radio wave D) All are operating at nearly the same propagation speed
 
Answer & Explanation Answer: A) Microwave

Explanation:

A microwave is the fastest communication channel whereas Optical fiber is a way of transferring data not a way of communication.

Report Error

View Answer Report Error Discuss

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