Tuesday 30 June 2015

Computer Knowledge - 3 (for Bank Exams)

 Computer Knowledge – 3

Directions for questions 1-11: Expand the following terms:

1.       ODBC
Ans:  Open Database Connectivity.

2.       HTML
Ans:  Hyper Text Mark-up Language

3.       RISC
Ans:  Reduced Instruction Set Computing

4.       ASCII
Ans:  American Standard Code for Information Interchange

5.       ANSI
Ans:  American National Standard Institute.

6.        XML
Ans:  Extended Mark-up Language

7.        FLOPS
Ans:  Floating Point Operating Per Second

8.       SQL
Ans:  Sequential Query Language

9.       QBE
Ans:  Query By Example

10.   ALE
Ans:  Address Latch Enable

11.   What is lagging in DBMS ?
Ans:  Reduced Redundancy.

Directions 12 to 20: For the following questions find the odd man out

12.   Unix
OS/2
CMOS
MSDOS
Ans:  CMOS

13.   Oracle
Informix
Sybase
LISP
Ans: LISP

14.   Laser
Inkjet
Dot-matrix
Mouse
Ans: Mouse

15.   Dir
Cls
Csh
Copy
Ans: Csh

16.   Bit
Byte
Nibble
Digit
Ans: Digit

17.   Hard Disk
Floppy Drive
CD ROM
Cache
Ans: Cache

18.   SQL
QUEL
QBE
ORACLE
Ans: Oracle

19.   C++
JAVA
VC++
PASCAL
Ans: PASCAL

20.   Projection Operation
Selection Operation
Intersection
Set Difference Operation
Ans: Intersection

21.   Which of the following is a universal gate?
(a) OR
(b) AND
(c) XOR
(d) NOR
 Ans: (d)

22.   The default back end of the VB is:
(a) Oracle
(b) Sybase
(c) Informics
Ans: Sybase

23.   What is meant by Superconductivity?
Ans: No resistance

24.   Viscosity
Ans: Friction

25.   What is the Lock Based Protocol used for?
Ans: Concurrency Control in DBMS


English Verbal - 14 (for Bank Exams)

English – Verbal – 14 (for Bank Exams)

Find the meaning of the following Idioms:

1.       A man of letters
A man, usually a writer, who knows a lot about literature A distinguished statesman and man of letters, he was born just before the turn of the century.

2.       A man of straw
A person or an idea that is weak and easy to defeat. Compared to their illustrious predecessors, the country's leaders seem to be men of straw.

       3.     To be in the air
(i) Is a feeling, especially excitement, is in the air, everyone is feeling it at the same time.
 There was excitement in the air as people gathered in the main square to hear the
Proclamation.
(ii) to be going to happen very soon The daffodils are in flower and spring is definitely in the
 air. I get the feeling that change is in the air.

4.       To bite the dust
(i)             to die. A shot rang out, and another cowboy bit the dust. The soldier was too young to bite the dust.
(ii)             to break; to fail; to give out. My old car finally bit the dust. This pen is out of ink and
 has bitten the dust.

5.       Man of few words
Someone, not necessarily a man, who speaks concisely or not at all, He is a man of few
 words, but he usually makes a lot of sense.

6.       Penny wise pound foolish
Someone who is penny wise, pound foolish can be very careful or mean with small amounts of money, yet wasteful and extravagant with large sums.

Questions: (7 – 11) Please arrange the following phrases in order to make a proper sentence.

7.       A. They are the three faces of dysphoria - bad feeling.
B. Anxiety, Depression and Anger.
C. When the three combine and get out of control, we get what is called mental illness.
D. All of us experience three emotions almost daily.
(a) ACDB
(b) CBDA
(c) CADB
(d) DBAC
Ans: (d)

8.       A. This is the key to tap the creative power inside us.
B. It is difficult to control our thinking and feelings.
C. That is, unless we work at it consciously and persistently.
D. We are influenced and limited by attitudes, prejudices by other individuals and by
external conditions to such an extent that few can control mental and emotional processes.
(a) ACDB
(b) BDCA
(c) CADB
(d) DBAC
Ans: (b)

9.       A. Two vital facts must be understood.
B. The subconscious mind has the power to create.
C. The second is that it obeys the orders given to it by the conscious mind.
D. Its function is to bring to full expression whatever is desired by the conscious mind.
(a)ABCD
(b) CBDA
(c) ADBC
(d) DBAC
Ans: (a)

10.   A. But what is not often understood is that this flash is outcome of long periods of
incubation.
B. The layman thinks that it is a spell of divine flash which illuminates the dark and the
hidden.
C. True, it does.
D. Inspiration is much misunderstood term.
(a) DBAC
(b) ACBD
(c) DBCA
(d) CADB
Ans: (c)

11.   A. As a result, the world has undergone a transformation.
B. Science and civilization have made rapid strides especially in recent times.
C. This constitutes the basic factor in the use of productive resources.
D. But behind all the progress of mankind is the human factor which is invaluable and
irreplaceable.
(a) ABDC
(b) BADC
(c) DCAB
(d) CBDA
Ans: (b)

Questions: (12 – 21) Identify the word with the correct spelling.

12.   (i) supercede                     (ii) supersede
Ans: (ii)

13.   (i)  recommend                 (ii) recoomend
Ans: (i)

14.   (i) superintendent           (ii) superitendant
Ans: (i)

15.   (i) separete                        (ii) separate
Ans: (ii)

16.   (i) succeed                          (ii) suceed
Ans: (i)

17.   (i) coolly                               (ii) cooly
Ans: (i)

18.   (i) despair                            (ii) dispair
Ans: (i)

19.   (i) rediculous                      (ii) ridiculous
Ans: (ii)

20.   (i)indispensable                (ii) indespensable
Ans: (i)

21.   (i) tranquility                      (ii) tranquillity
Ans: (ii)




Saturday 27 June 2015

Aptitude Questions - 4 (for Bank Exams)

Aptitude Questions – 4 (For Bank Exams)

1.                   Find the reminder when 333666777888999 divided by 3 or 9 or 11?
Ans: Reminder 5 when divided by 11.  
Rule of divisibility for 3 and 9 – I f the sum of the digits divisible by 3 or 9 then the whole number is divisible by 3 and 9.
Rule of divisibility for 11 --- If the difference between the sum of the odd placed numbers and even placed numbers is either zero or divisible by 11 then the whole number is divisible by 11.
In this case the difference is 5 and that’s the reminder.

2.                   Which is the biggest perfect square amongst the following
(a) 15129,    (b) 12348,            (c) 23716,             (d) 20736
Ans: (c)

3.                   The greatest area of the following:
(a) The radius of circle is 4
(b) The square of diagonal is 4
(c) The square of side is 4
Ans: (a)

4.                   The area of the maximum size of the circle inscribed within a 10 inch square?
Ans: 78.57 sq. inch  ( The radius of the circle will be half the side of the square)

5.                    A gold density is 19 times greater than the water and for copper it is 9 times. At
what ratio you can mix gold and copper to get 15 times denser than water?
                       Ans: 3 : 2
                       Using the rule of alligation we have for Gold 15 – 9 = 6 parts and for Copper
                       19 – 15 = 4 parts. Thus the ratio is 3 : 2

6.                   Find the value of (1.99)2
Ans: 3.9601

7.                   There is a room with 6' x 8'. A one foot tile is fixed along the 4 walls in one row. How
many more one foot tiles are required  to finish the work.
Ans. 24 Tiles
Since all along the wall one foot tile is already fixed, the dimension of the room now is reduced to  -> 4 * 6 = 24 sq.ft.

8.                   Two persons can finish a job in 8 days. First person alone can finish the work in 24
days. How many days does the second person take to finish the job?
Ans: 12 days
Let the two persons be A and B.
A in one day does 1/24 job and B in one day 1/B job.
They both together finish the job in 8 days.
Hence the job done together in one day is 1/8. Thus we have an equation
1/24 + 1/B = 1/8 -> 1/B = 1/8 – 1/24 = 1/12.
1/B = 1/12. B will alone finish the job in 12 days.

9.                   A person's salary is getting reduced by 20%. What percentage should be added to
get back his original salary?
Ans: 25%
Use the formula ----  100R/100-R (where R is the percentage of reduction)

10.               Two persons start from the same point and walk in opposite directions with 5km/hr and
       5.5km/hr speed respectively. What is the distance separating them after 2 and half hrs?
       Ans: 26.25 km
       Relative speed between the two is ---- 5 + 5.50 = 10.50 km/hr. (They walk in opp.
                     direction.
      Thus the distance between them after 2.30 hours will be 10.50 * 2.30hrs = 26.25 km.    

11.               A person starts walking at a speed of 5km/hr through half the distance, rest of the distance he covers with a speed 4km/hr. Total time of travel is 9 hours. What is the maximum distance he can cover?
Ans: 40.50 km.
Average speed is ---(5 + 4)/2 = 4.50 km. ( Note: He covers the total distance in two equal half)
Distance/ Speed is = Time.  Let X be the distance.
Thus ------  x/4.5 = 9 hrs. solving we get … X = 40.50km

12.               Initially two cups of same volume are present with milk filled upto 3/5th and 4/5th
of their volumes. Water is then filled. Then two mixtures are mixed. Find the ratio of water to milk in the mixture.
Ans: 3 : 7
A simple question. Let the volume of the two cups be 5 each. Then total volume is 10. The total volume of Milk in these two cups initially is 3 + 4 = 7parts. The remaining is 3 parts now filled with water.
Thus the ratio of water and milk is ------- 3 : 7.

13.               16 grams of radioactive material decays into 8 grams in 10 years. How long will it
take to decay to 1 gram?
Ans: 70 years.
16 gm reduced to 8gm in 10yrs. So 8 gm get decayed.
For decaying 1 gm it takes 10/8 years. For decaying 8 gm it takes 10/8*8
Remaining 8 gm need to decay 7 to get 1 gm remaining.
For decaying 7 gm it will take
10/8*8*7 = 10*7
= 70 years
 
14.               In a rectangle the length is increased by of the original length. By what proportion
should the width be reduced so that the area will be the same?
Ans: 50%
Assume the original Length and Breadth as 5 and 4. The area is 5 * 4 = 20.
The new length is 5 + 5 = 10. To retain the same area the breadth should be 2.
Breadth reduced from 4 to 2 or 50%.

15.               A person’s salary is decreased by steps of 20%, 15% and 10%. What will be the percentage decrease, if the salary is decreased in a single shot?
Ans: 38.8%
Successive percentage change is given by the formula ->  x + y + xy/100 where x and y are the two successive percentages.
Applying this after the second decrease, the percentage change is ->  -20 - 15 + 300/10 =  -32%
After the third decrease the change will be:
-32 – 10 + 320/100 = - 38.8%


Thursday 25 June 2015

Polaris - Aptitude - 1

Polaris – Aptitude - 1

1.       I have marbles in three different colours as follows:
Blue 60;  Green 156;  Red 204
I distribute them to children in such a way that each one of them get equal number of marbles and all in one colour.
How many children are there?
(a) 12                     (b) 35                    (c) 67                     (d) 31
Ans: (b)
Find the HCF of 60, 156 and 204. The HCF is 12. Total number of marbles is 420. Divide this by the HCF -> 420/12 = 35.

2.       A square of side 6cm has a circle inscribed in it. Calculate the approximate ratio of surface area of the circle to square.
(a) 11/14              (b) 13/14              (c) 12/14              (d) 14/18
Ans: (d)
The area of the Square is 6*6 = 36 sq.cm.  The radius of the circle if half the side of the square – 3 cm. The area of the circle is πr2 -> 22/7 * 3 * 3 = 28 sq.cm (approx.)
Hence the ratio is 28 : 36 or 14 : 18

3.       There are 3 numbers whose ratio is as follows: first: second=2:3 and second : third= 5:8. There sum is 98, what is the second number?
(a) 20                     (b) 30                    (c) 40                     (d) 50
Ans: (b)
Let the three numbers be A, B and C. We now have two ratios
A : B :: 2 : 3  …….. (i)     and  B : C :: 5 : 8 ……….. (ii)
We have two different values for B in the two ratios. Let us make this common in both the ratios.
Multiply (i) by 5 and (ii) by 3.
We now have one common ratio ->    A : B : C :: 10 : 15 : 24
The sum of A + B + C = 98.  Hence the value of B is ->  98 * 15/49 = 30.

4.       A 30% saline solution is to be converted to a 10% saline solution. How much pure water needs to be added to 100 kg of 30% saline solution?
(a) 150 kg             (b) 100 kg            (c) 200 kg             (d) 250 kg
Ans: (c)
In 100 kg saline solution the salt is 30 kg. This quantum of salt will remain as such in the 10% saline solution also. Since the quantum of salt is 30 kg and its percentage is 10% only the total quantum of solution should be 300 kg.
Hence 200 kg of water needs to be added.

5.       In a given factory, average salary combined for the staff and supervisors is Rs 60 while that for only staff is Rs. 56. The average salary of supervisors is Rs. 400. There are a total of 12 supervisors. How many labourers are employed in this factory?
(a) 1020                (b) 1130                (c) 1500                (d) 1532
Ans: (a)
This question can best be answered through Rule of Alligation figure as under.





                          A (56)                                                          B (400)
                                  





                                                                X (60)           



                       B – X (340)                                                 X – A (4)

From the above we observe the ratio of staff and supervisors as 340 : 4
We are informed that there are 12 supervisors.
3 Parts of supervisors amount to 12.
Hence the number of staff is 340 * 3 = 1020.

6.       Alok completed a journey from his home to mall in 42 minutes at an average speed of 10kmph. He walked initially at 4kmph and then took an auto which moved at 25kmph. What part of his journey did he walk?
(a) 1km                 (b) 2km                                (c) 3km                 (d) 4km
Ans: (b)
The distance covered in 42 minutes t an average speed of 10 kmph is -> 10 * 42/60 = 7 km.
Let ‘x’ be the distance travelled by walking at a speed of 4 kmph. Then 7-x is the distance travelled by auto at a speed of 25 kmph.  We now have an equation:
x/4 + (7-x)/25 = 42/60. Solving we get the value of x as 2 km.
Hence, the distance covered by walking is 2km.

7.       Ashish can do 1/4 of his work in 10 days, Vijay 40% in 40 days and Deepak 1/3 in 13 days. Who finishes first?
(a) Ashish            (b) Deepak         (c) Vijay                                (d) Can’t say
Ans: (b)
Ashish ……. In 10 days does ¼th work. So, to complete the whole work will take 40 days.
Vijay in 40 days will complete 40% or 2/5 of the work. He will take 100 days to complete the work.
Deepak in 13 days completes 1/3rd of the work and would take 39 days to complete the whole work.
Hence, Deepak will complete the work first.

8.       You can complete a carpet weaving in 10 days while I can do it in 15 days. We work together but I leave in 2 days. How many days will you now require to finish the work?
(a) 7                       (b) 8                       (c) 19/3                 (d) 20/3
Ans: (d)
In one day I will do 1/10 work and my friend will do 1/15 work. Together we both in one day will do 1/10 + 1/15 = 5/30 -> 1/6 work. In two day we both will do 1/6 * 2 = 1/3 work.
The remaining work now is 1 – 1/3 = 2/3 which I alone will have to do.
The time taken by me to complete this work is ----- (2/3) / 1/10 = 20/3 days.

9.       Increase in population for a given country in three consecutive years is 10%, 25% and 10%. What is the combined percentage increase for the three years?
(a) 45%                 (b) 52%                 (c) 51.25%           (d) 45.25%
Ans: (c)
Successive percentage increase for two years is given by the formula -> x + y + xy/100 where x and y are the percentage variation of two successive periods.
Applying this, we get the percentage variation at the end of 2nd year as -> 10 + 25 + 250/100 = 37.50%
Now the variance between the second and third year is ->  37.50 + 10 + (37.50*10)/100
= 51.25% 

10.   Sheila and Sunita start a business with investment of Rs8000 and Rs5000 resp. Sunita is an active partner and so she gets 10% of profit separately for supervision. If the total profit is Rs 3240/-, then what is the share of profit for Sunita?
(a) 1445                (b) 1334                (c) 1500                (d) 324
Ans: (a)
Ratio of Shiela and Sunita’s investment are :  8 : 5
10% of total profit of Rs 3240/- is Rs 324/- and this Sunita gets separately.
Remaining profit is --- 3240 – 324 = 2916.
Sunita’s share in this profit is ->     2916 * 5/13 =1121.

Hence, Sunita’s share of profit in the business is ----  1121 + 324 = 1445.