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

Which of the following is true of three-tier data worehouses
Once created, the data marts will directly receive their new data from the operational databases.
The data mart combines all the tables of the data warehouse.
The data marts are different groups of tables in the data warehouse.
Once created, the data marts will keep on being updated from the data warehouse at periodic times.
A data mart becomes a data warehouse when it reaches a critical size.

Which of the following is not a Web App interface mechanism
Cookies
Forms
Browser
Cookies and Links
Links

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?
2016
4126
1648
1028
6058
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?
46%
32%
68%
58%
42%
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?
25%
35%
40%
20%
15%
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%

What is the total number of C type of garments in both the stores together?
3770
2610
3276
1008
3618
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?
F
A
C
E
B
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?
20%
25%
30%
28%
22%
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)?
63
51
56
69
76
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) ?
24
21
34
26
32
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) ?
584
535
596
586
574
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) ?
92
91
93
99
96
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) ?
156
128
152
132
168
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) ?
6
9
8
11
7
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?
42
41
45.25
42.5
48
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?
51⅓%
55⅔%
52⅓%
54⅔%
53⅓%
Explanation:

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

=53⅓%

What is the difference between the population of states V and P ?(in lakhs)
38.5
33.75
35.75
35.5
32.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)
118.75
112.65
106.85
112.25
108.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?
12:13
11:12
9:10
7:9
4: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?
7/20
7/10
9/10
3/5
2/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?
14/95
22/95
15/95
12/95
18/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?
27/38
35/38
30/38
33/38
29/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 ?
Only A
Both A and B
Both A and C
Only B
Only 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?
288%
264%
30%
100%
144%
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?
65%
20%
15%
25%
40%
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?
2008
2009
2011
2010
2012
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?
3:4
2:3
4:5
3:5
4: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?
INR 107 Crores
INR 132 Crores
INR 120 Crores
INR 146 Crores
INR 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?
640
610
620
636
663
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

1 2 3 4