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

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

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

If the total production of wheat by Chhattisgarh, Kerala and West Bengal in 2008 was more than that in 2007 by 1.8%, what was the total production of these three states together in 2008in thousand tonnes?
A480
B557
C488
D590

E663
Explanation:

Total producttion of wheat by Chhattisgarh, kerala and West Bengal in 2007=360+120+100=580

Total production of wheat by three states in 2008 = 101.8/100 × 580

= 590.44

= 590

What is the difference between total production of rice and jowar (in thousand tonnes) by Rajasthan, Chhattisgarh and Tamil Nadu together in 2007 ?
A160
B130

C150
D140
E120
Explanation:

Total production of rice by Rajasthan, Chhattisgarh and Tamil Nadu = 160+250+290= 700

Total production of jowar by Rajasthan, Chhattisgarh and Tamil Nadu = 120+210+240= 570

∴ Required difference = 700-570

= 130

What is the respective ratio of between the total production of bajra by Rajasthan, Uttar Pradesh and Chhattisgarh together and total production of jowar by these three states together ?
A14 : 17
B13:15
C13:16

D13:17
E14:19
Explanation:

Total production of bajra by Rajasthan, Uttar Pradesh and Chhattisgarh = 80+130+180=390

Total production of jowar by Rajasthan, Uttar Pradesh and Chhattisgarh= 120+150+210=480

∴ Required ratio = 390 : 480

= 13:16

Total production of rice by Kerala and Tamil Nadu together is what percent of total production of jowar produced by these states together? (rounded off to nearest integer)
A155%
B158%
C153%

D151%
E159%
Explanation:

Total production of rice by Kerala and Tamil Nadu = 230+290 = 520

Total production of jowar by Kerala and Tamil Nadu =100+240 = 340

∴ Required Percentage = (520/340 ×100)

= 152.9

= 153%

What was the average production of bajra (in thousand tones) by all the given states in 2007?
A133⅓
B142 4/9
C145
D160

E143⅓
Explanation:

Total production of bajra (in thousand tonnes) by all the given states in 2007

= 80+180+130+270+140+160

=960

∴ Average production = 960/6

= 160

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

Data related to number of employees who joined(Jo) and left(Le) 5 given companies during 5 given years

Company	A		B		C		D		E
Year	Jo	Le	Jo	Le	Jo	Le	Jo	Le	Jo	Le
2001	161		148		179		116		128
2002	148	58	172	60	161	90	208	60	191	50
2003	135	69	188	96	143	101	169	45	167	79
2004	112	88	173	59	165	58	142	56	185	82
2005	141	39	151	48	179	66	155	108	142	91

(Note : Consider the given companies started in 2001)

What is the respective ratio between total number of employees who joined company C in 2003 and 2004 together and total number of employees who left company E in 2003, 2004 and 2005 together?
A22:17
B11:9

C22:19
D13:9
E11:7
Explanation:

Total number of employees who joined company C in 2003 and 2004= 143+165 = 308

Total number of employees who left company E in 2003,2004 and 2005 together

= 79+82+91

=252

∴ Required ratio = 308 : 252

= 11:9

What is the average number of employees who joined company D during all the given years together?
A166
B156
C162
D164
E158

Explanation:

Number of employees who joined company D during all the years

= 116+208+169+142+155

= 790

∴ Required average = 790/5

= 158

In which of the given companies number of employees was highest at the end of 2002?
AD
BC
CB
DA
EE

Explanation:

Number of employees in company A at the end of 2002 = 161+(148-58) =251

Number of employees in company B at the end of 2002 = 148+(172-60) =260

Number of employees in company C at the end of 2002 = 179+(161-90) = 250

Number of employees in company D at the end of 2002 = 116+(208-60) = 264

Number of employees in company E at the end of 2002 = 128+(191-50) = 269

Number of employees in company E at the end of 2002 is what percent more than the number of employees in company C at the end of 2002?
A9⅕%
B3⅘%
C11⅕%
D7⅗%

E5⅘%
Explanation:

Number of employees in company E at the end 2002

= 128+(191-50) = 269

Number of employees in company C at the end of 2002

= 179+(161-90) =250

Increased Percentage = (269-250/250 ×100)%

=(19/250 ×100)%

=7⅗%

What was the total number of employees in company A at the end of 2004?
A347
B363
C329
D335
E341

Explanation:

Total number of employees in company A at the end of 2004

= 161+(148-58)+(135-69)+(112-88)

= 161+90+66+24

= 341

If the respective ratio of number of male and female employees in company B at the end of 2003 was 5:6, what was the number of female employees in company B at the end of 2003?
A208
B172
C186
D192

E212
Explanation:

Total number of employees in company B at the end of 2003 = 148 + (172-60)+(188-96) =352

∴ Number of female employees = 352 × 6/11 = 192

Directions (Next Five Questions) : Each of the questions below consists of a question and two statements numbered I and II given below it. You have to decide whether the data provided in the statements are sufficient to answer the question. Read both the statements and

What is the cost price of the table?

I. The percent profit made when table is sold for INR 1,054/- is twice as much as it is when it sold for INR 952/-

II. The marked price of the table is INR 1,105/-, If a discount of 20% is given on the marked price , the profit gained is 4%.
AIf the data in statement I alone are sufficient to answer the question while the data in statement II alone are not sufficient to answer the question
BIf the data in statement II alone are sufficient to answer the question while the data in statement I alone are not sufficient to answer the question.

CIf the data in both the statements I and II together are sufficient to answer the question.
DIf the data either in statements I or in statement II alone are sufficient to answer the question.
EIf the data in both the statements together are not sufficient to answer the question.
Explanation:

From the statement II, Marked price = INR 1105/-

Discount = 20%

∴ Selling Price =80/100 ×1105

= INR 884/-

Profit gained = 4%

∴ Cost Price = 884 × 100/104

= INR 850/-

What is the value of sum of squares of both the numbers?

I. The sum of both the numbers is 128.

II. The H.C.F and L.C.M of the two numbers are 8 and 504 respectively.
AIf the data in statement I alone are sufficient to answer the question while the data in statement II alone are not sufficient to answer the question
BIf the data in statement II alone are sufficient to answer the question while the data in statement I alone are not sufficient to answer the question.

CIf the data in both the statements I and II together are sufficient to answer the question.
DIf the data either in statements I or in statement II alone are sufficient to answer the question.
EIf the data in both the statements together are not sufficient to answer the question
Explanation:

From Statement II

Let the numbers be 8x and 8y

We know that H.C.F. × L.C.M = Product of two numbers

8 × 504 = 8x ×8y

8×8×63 = 8x ×8y

64 × 63 = 8x ×8y

Comparing the values, we get the numbers 63 and 64.

What is the length of the diagonal of the rectangle?

I. The length of the rectangle is 120% more than its breadth.

II. The perimeter of the rectangle is 32m. The difference between length and breadth of the rectangle is 6m.
AIf the data in statement I alone are sufficient to answer the question while the data in statement II alone are not sufficient to answer the question
BIf the data in statement II alone are sufficient to answer the question while the data in statement I alone are not sufficient to answer the question.

CIf the data in both the statements I and II together are sufficient to answer the question.
DIf the data either in statements I or in statement II alone are sufficient to answer the question.
EIf the data in both the statements together are not sufficient to answer the question.
Explanation:

From Statement II

Let the length of a rectangle be l and beadth be b.

It is given that,

l –b =6

and 2(l+b) = 32

l +b=16

Solving both the equations we get,

l=11

b=5

The length of the diagonal of the rectangle

=√l²+b²= √(11)²+(5)²

=√146

What is the present age of Meera?

I. The respective ratio of present ages of Meera and her mother is 7:16.

II. The respective ratio of ½ of Meera’s present age to ⅛ of mother’s present age is 7:4.
AIf the data in statement I alone are sufficient to answer the question while the data in statement II alone are not sufficient to answer the question
BIf the data in statement II alone are sufficient to answer the question while the data in statement I alone are not sufficient to answer the question.
CIf the data in both the statements I and II together are sufficient to answer the question.
DIf the data either in statements I or in statement II alone are sufficient to answer the question.
EIf the data in both the statements together are not sufficient to answer the question.

what is the total number of students (male and Female) in the class?

I. the average weight of the students of the class is 61.08 kg. the average weight of male students is 63 kg and the average weight of the female students is 59 kg. The difference between number of male students and number of female students is 3.

II. The respective ratio of number of male students and number of female students in the class is 13:12.
AIf the data in statement I alone are sufficient to answer the question while the data in statement II alone are not sufficient to answer the question

BIf the data in statement II alone are sufficient to answer the question while the data in statement I alone are not sufficient to answer the question.
CIf the data in both the statements I and II together are sufficient to answer the question.
DIf the data either in statements I or in statement II alone are sufficient to answer the question.
EIf the data in both the statements together are not sufficient to answer the question
Explanation:

From Statement I

Let the total number of student be X

Let the male students be A and female students be B.

It is given that,

A-B = 3

and A + B = x

Weight of total students = 61.08 × x

Weight of male students = 63 × A

Weight of female students = 59 × B

∴ 61.08(3+2B) = 63(3+B) + 59B

183.24+122.16B=189+63B+59B

0.16B=5.76

B=36

∴ A=39

∴ Total number of students = 36+39=75

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

Expenditure (in INR Thousand) of 3 businessman during 5 given years

Profit = Income – Expenditure

Profit percent = (Profit / Expenditure) × 100

what is the average expenditure of businessman B among all the given years together? (in INR thousand)
A426
B422
C436

D448
E438
Explanation:

Average expenditure of business B among all the years

= 360+500+560+300+460/5 × 1000

= 436 × 1000

= INR 436 thousand

Expenditure of businessman A increased by what percent from 2004 to 2008 ?
A112 8/13%
B120 1/13%
C108 6/13%
D118 2/13%
E115 5/13%

Explanation:

Expenditure of businessman A in 2004 = INR 260 × 1000

Expenditure of businessman A in 2008 = INR 560×1000

∴ Increase in 2004 to 2008 = 560 × 1000 - 260 × 1000

= INR300 × 1000

∴ Increased Percentage = (300 × 1000/ 260×1000) × 100

= 115 5/13 %

If the percent profit earned by all the given businessmen together in 2006 was 45, what was the total income of all the given businessmen together in that particular year ? (in INR Thousand)
A1820
B1680
C1640
D1780
E1740

Explanation:

Expenditure in 2006 = 220 × 1000+ 420 × 1000 + 560 × 1000

=1200×1000

Let the profit be INR x

∴ (X/1200 ×1000) ×100 = 45

X = INR 5,40,000/-

∴ Required Income = Expenditure + Profit

= 1200 × 1000 + 540000

= INR 17,40,000/-

what is the respective ratio between the total expenditure of all the businessmen together in 2005 and total expenditure of all the given businessmen together in 2007?
A12:11
B10:7
C8:7
D13:11

E16:13
Explanation:

Expenditure in 2005 = 320+ 500+ 220

= 1040

Expenditure in 2007 = 140+ 300+ 440

=880

∴ Required ratio = 1040 : 880

= 13 : 11

If C’s income in 2008 was INR 3,69,000/-, what was the percent profit in that particular year?
A23%

B28%
C26%
D19%
E33%
Explanation:

Income of C = INR 3,69,000/-

Expenditure of C = INR 3,00,000/-

Profit = 369000-300000

=INR 69,000/-

∴ Profit Percentage = (69000/300000×100)%

=23 %