Home Questions & Answer Technology Questions & Answers Data Base Questions & Answers

Data Base Questions & Answers (Compiled from UPSC, SSC ,PSC ,IBPS previous question papers)

Which of the following is true of three-tier data worehouses
AOnce created, the data marts will directly receive their new data from the operational databases.
BThe data mart combines all the tables of the data warehouse.
CThe data marts are different groups of tables in the data warehouse.
DOnce created, the data marts will keep on being updated from the data warehouse at periodic times.

EA data mart becomes a data warehouse when it reaches a critical size.

Which of the following is not a Web App interface mechanism
ACookies
BForms

CBrowser
DCookies and Links
ELinks

Directions (145-150) : Study the following Pie charts and answer the questions given below them.

Percentage of Six different types of garments in store I

Total number of garments in store I = 12600

Percentage of six different types of garments in store II

Total number of garments in store II = 14500

What is the average of A, Band C type of garments in store I?
A2016

B4126
C1648
D1028
E6058
Explanation:

In store I, number of A,B and C type of garments = 19+21+8/100 × 12600 = 6048

∴ Required average = 6048/3 = 2016

The number of E type of garments in store I is approximately what percent of the number of B type of garments in store II?
A46%
B32%
C68%

D58%
E42%
Explanation:

In store I, number of E type of garments = 11/100× 12600 =1386

In store II, number of B type of garments = 14/100 × 14500 = 2030

∴ Required percentage = 1386/2030 ×100

= 68.2 = 68%

Number of D type of garments in store I is more than that in store II by what percent approximately?
A25%
B35%
C40%
D20%
E15%

Explanation:

In store I, number of D type of garments = 16/100 ×12600 = 2016

In store II, number of D type of garments = 12/100 × 14500 =1740

∴ Required percentage 2016-1740/1740 ×100

= 15.86%

=15%

The difference in number of which type of garments in two stores is maximum?
AE
BD
CB
DC

What is the total number of C type of garments in both the stores together?
A3770
B2610
C3276
D1008
E3618

Explanation:

In store I, number of C type garments

= 8/100 × 12600 = 1008

In store II, number of C type garments

= 18/100 ×14500

=2610

∴ Required total = 1008 +2610

= 3618

Total number of D and A type of garments in store I is approximately double the number of which type of garments in store II?
AF
BA

CC
DE
EB
Explanation:

In Store I, number of A type of garments = 19/100×12600

In Store II, number of D type garments = 16/100 ×12600 = 2016

∴ Total number of A and Dtype of garments in store I = 2394+2016

= 4410

In store II, number of A type of garments = 15/100 × 14500

= 2175

Directions (Next six quesions) : Study the following information carefully to answer the questions.

Details of population as recorded in a census

Population of state ‘P’ is 150% of population of state ‘T’ and 80% of the population of state ‘U’. Population of State ‘Q’ is 60% of the population of state ‘V’. population of state ‘S’ is 125% of population o state ‘R’. Population of state ‘U’ is 75 lakhs which is 80% of the population of state ‘V’ and 120%of the population of state ‘S’.

Population of state S is more than the population of state R by what percent?
A20%
B25%

C30%
D28%
E22%
Explanation:

Population of State U = 75 lakh

Population of state V = 75 ×100/80

=375/4 lakh

Population of state S = 75 × 100/120

= 125/2 lakh

Population of State R = 125/2 ×100/125 = 50lakh

Population of State Q = 375/4 × 60/100

=225/4 Lakh

Population of state P = 75 × 80/100 = 60 lakh

Population of State T = 60×100/150 = 40 lakh

Required Percentage = (125/2-50/50 ×100)%

=25%

Directions (Next Six Questions) : in these questions, a number of series is given. After the series a number is given followed by (1), (2), (3), (4) and (5). You have to complete the series starting with the given numbers following the sequence of original series and answer the question that follows the series.

15 14 20 33 68 215

21 (1) (2) (3) (4) (5)

What will come in place of (3)?
A63
B51
C56
D69

E76
Explanation:

15(X1-(1)³) 14(X2-(2)³) 20(X3-(3)³) 33(X4-(4)³) 68(X5-(5)³) 215

21(X1-(1)³) 20(X2-(2)³) 32(X3-(3)³) 69(X4-(4)³) 212(X5-(5)³) 935

8 7 12 33 128 635

6 (1) (2) (3) (4) (5)

What will come in place of (3) ?
A24
B21

C34
D26
E32
Explanation:

8(X1-1) 7(X2-2) 12(X3-3) 33(X4-4) 128(X5-5)635

6(X1-1) 5(X2-2) 12(X3-3) 21(X4-4) 80(X5-5)395

7 13 31 97 391 1957

13 (1) (2) (3) (4) (5)

What will come in place of (4) ?
A584
B535

C596
D586
E574
Explanation:

7(X1+6) 13(X2+5) 31((X3+4) 97(X4+3) 391(X5+2)1957

13(X1+6) 19(X2+5) 43(X3+4) 133(X4+3) 535(X5+2)2677

5 31 159 645 1951 3927

3 (1) (2) (3) (4) (5)

What will come in place of (2) ?
A92
B91
C93
D99

E96
Explanation:

5(X6+1) 31(X5+4) 159(X4+9) 645(X3+16) 1951(X2+25)3927

3(X6+1) 19(X5+4) 99(X4+9) 405(X3+16) 1231(X2+25)2487

9 18 54 216 1080 6480

7 (1) (2) (3) (4) (5)

What will come in place of (3) ?
A156
B128
C152
D132
E168

Explanation:

9(X2) 18(X3) 54(X4) 216(X5) 1080(X6) 6480

7(X2) 14(X3) 42(X4) 168(X5) 840(X6) 5040

11 5 4 4.5 7 15

15 (1) (2) (3) (4) (5)

What will come in place of (2) ?
A6

B9
C8
D11
E7
Explanation:

11(X0.5-0.5) 5 (X1-1) 4 (X1.5-1.5 ) 4.5 (X2-2) 7(X2.5-2.5) 15

15(X0.5-0.5) 7(X1-1) 6 (X1.5-1.5) 7.5 (X2-2) 13(X2.5-2.5) 30

Directions (Next six quesions) : Study the following information carefully to answer the questions.

Details of population as recorded in a census

Population of state P was found to have been increased by 25% from the previous census record. What was the population(in lakhs)of state P as per previous census?
A42
B41
C45.25
D42.5
E48

Explanation:

Population of State U = 75 lakh

Population of state V = 75 ×100/80

=375/4 lakh

Population of state S = 75 × 100/120

= 125/2 lakh

Population of State R = 125/2 ×100/125 = 50lakh

Population of State Q = 375/4 × 60/100

=225/4 Lakh

Population of state P = 75 × 80/100 = 60 lakh

Population of State T = 60×100/150 = 40 lakh

Let the population of state P = x lakh

∴ 125/100x = 60

x= 60 × 100/125

=48 lakhs

Population of state R is what percent of the population of state V?
A51⅓%
B55⅔%
C52⅓%
D54⅔%
E53⅓%

Explanation:

Required Percentage = (50/375/4 × 100)%

=53⅓%

What is the difference between the population of states V and P ?(in lakhs)
A38.5
B33.75

C35.75
D35.5
E32.75
Explanation:

Population of State U = 75 lakh

Population of state V = 75 ×100/80

=375/4 lakh

Population of state S = 75 × 100/120

= 125/2 lakh

Population of State R = 125/2 ×100/125 = 50lakh

Population of State Q = 375/4 × 60/100

=225/4 Lakh

Population of state P = 75 × 80/100 = 60 lakh

Population of State T = 60×100/150 = 40 lakh

Required difference = 375/4-60

=33.75 lakhs

What is the population of state Q and S together? (in lakhs)
A118.75

B112.65
C106.85
D112.25
E108.25
Explanation:

Population of State U = 75 lakh

Population of state V = 75 ×100/80

=375/4 lakh

Population of state S = 75 × 100/120

= 125/2 lakh

Population of State R = 125/2 ×100/125 = 50lakh

Population of State Q = 375/4 × 60/100

=225/4 Lakh

Population of state P = 75 × 80/100 = 60 lakh

Population of State T = 60×100/150 = 40 lakh

Total Population = 225/4 + 125/2

= 118.75 lakhs

What is the ratio between population of state Q and State S respectively?
A12:13
B11:12
C9:10

D7:9
E4:5
Explanation:

Population of State U = 75 lakh

Population of state V = 75 ×100/80

=375/4 lakh

Population of state S = 75 × 100/120

= 125/2 lakh

Population of State R = 125/2 ×100/125 = 50lakh

Population of State Q = 375/4 × 60/100

=225/4 Lakh

Population of state P = 75 × 80/100 = 60 lakh

Population of State T = 60×100/150 = 40 lakh

Required ratio = 225/4 : 125/2

= 9:10

Directions (Next three questions) : Study the information to answer the questions.

A bag contains 6 red shirts, 6 green shirts and 8 blue shirts.

One shirt is drawn randomly. What is the probability that it is not green?
A7/20
B7/10

C9/10
D3/5
E2/5
Explanation:

Probability of being a green shirt = 6/20 = 3/10

Probability of shirt not being green = 1-3/10 = 7/10

One shirt is drawn randomly and then another shirt is drawn randomly. What is the probability that the first shirt is red and the another shirt is blue?
A14/95
B22/95
C15/95
D12/95

E18/95
Explanation:

Required Probability ⁶C₁/²⁰C₁× ⁸C₁/¹⁹C₁

_{= 6/20 × 8/19}

_=12/95

Two shirts are drawn randomly. What is the probability that atmost one shirt is red?
A27/38
B35/38

C30/38
D33/38
E29/38
Explanation:

Atmost one shirt is red means either 0 or 1 shirt is red.

∴ Required probability

= (⁶C₀ × ¹⁴C₂)+(⁶C₁×¹⁴C₁)/²⁰C₂

=91+(6×14)/190

=91+84/190

=35/38

Directions (Next Six Questions) : Study the following graph and answer the given questions.

Profit earned by three companies over the years (in INR Crores)

The percentage increase in profit from the preceding years was maximum in case of which of the following companies ?
AOnly A

BBoth A and B
CBoth A and C
DOnly B
EOnly C
Explanation:

It is cleared from graph , the maximum profit was earned by company A from 2008 to 2009

In 2009, Profit earned by Company A = INR 130Crores

In 2008, Profit earned by Company A = INR 90Crores

∴ increased Percentage = (130-90/90×100)%

= 44.4%

The total profit earned by company A in 2011 and company C in 2012 together was approximately what percent of the profit earned by company A in 2007?
A288%

B264%
C30%
D100%
E144%
Explanation:

Profit earned by company A in 2011 = INR 115Crores

Profit earned by company C in 2012 = INR 115Crores

Profit earned by company A in 2007 = INR 80Crores

∴ Required Percentage = (115+115/80 ×100)%

=287.5%

=288%

Approximately, what is the percentage increase in profit earned by company C from 2007 to 2011?
A65%
B20%
C15%
D25%
E40%

Explanation:

Profit earned by company C in 2007= INR 85 crores

Profit earned by company C in 2011 = INR 120 crores

∴ Increased Percentage = (120-85/85 ×100)%

= 41.1%

=40%

The total profit of all the three companies together was maximum in which of the following years among the given years?
A2008
B2009
C2011
D2010
E2012

Explanation:

Profit earned by all the three companies (in INR crores)

In 2008 = 90+110+120= 320

In 2009 = 130+120+110= 360

In 2010 = 100+140+120= 360

In 2011 = 115+105+120= 340

In 2012 = 125+135+115 = 375

It is cleared from above, the maximum profit was earned by all three companies in 2012.

What is the ratio between total profit earned by all three companies in 2007 and 2011 respectively?
A3:4

B2:3
C4:5
D3:5
E4:7
Explanation:

Profit earned by three companies in 2007

= 80+90+85

=255 crores

Profit earned by three companies in 2011

= 115+105+120

=340 crores

∴ Required ratio = 255 : 340 = 3:4

Approximately, what is the average profit earned by company Bover he given years?
AINR 107 Crores
BINR 132 Crores
CINR 120 Crores

DINR 146 Crores
EINR 97 Crores
Explanation:

Profit earned by company B ina ll the years (INR in crores0 = 90+110+120+140+105+135 = 700

∴ Average Profit = 700/6

= INR 120Crores

Directions (Next Six Questions) : Study the following table to answer these questions:

Production of different food grains (in thousand tones) by six states in 2007

State	Wheat	Rice	Jowar	Bajra
Rajasthan	240	160	120	80
Chhattisgarh	360	250	210	180
Uttar Pradesh	280	220	150	130
Kerala	120	230	100	270
West Bengal	100	280	200	140
Tamil Nadu	160	290	240	160

Out of total production of all the total grains together by Uttar Pradesh in 2007, 85%of the quantity could be sold. What was the total quantity of given food grains (in thousand tonnes) Sold by Uttar Pradesh in that year?
A640
B610
C620
D636
E663

Explanation:

Total production of all the grains together by Uttar Pradesh = 280+220+150+130 = 780

Now, food grains (in thousand tonnes) sold by Uttar Pradesh = 85/100 ×780

=663