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?
480
557
488
590
663
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 ?
160
130
150
140
120
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 ?
14 : 17
13:15
13:16
13:17
14: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)
155%
158%
153%
151%
159%
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?
133⅓
142 4/9
145
160
143⅓
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?
22:17
11:9
22:19
13:9
11: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?
166
156
162
164
158
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?
D
C
B
A
E
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?
9⅕%
3⅘%
11⅕%
7⅗%
5⅘%
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?
347
363
329
335
341
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?
208
172
186
192
212
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%.
If 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
If 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.
If the data in both the statements I and II together are sufficient to answer the question.
If the data either in statements I or in statement II alone are sufficient to answer the question.
If 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.
If 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
If 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.
If the data in both the statements I and II together are sufficient to answer the question.
If the data either in statements I or in statement II alone are sufficient to answer the question.
If 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.
If 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
If 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.
If the data in both the statements I and II together are sufficient to answer the question.
If the data either in statements I or in statement II alone are sufficient to answer the question.
If 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.
If 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
If 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.
If the data in both the statements I and II together are sufficient to answer the question.
If the data either in statements I or in statement II alone are sufficient to answer the question.
If 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.
If 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
If 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.
If the data in both the statements I and II together are sufficient to answer the question.
If the data either in statements I or in statement II alone are sufficient to answer the question.
If 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)
426
422
436
448
438
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 ?
112 8/13%
120 1/13%
108 6/13%
118 2/13%
115 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)
1820
1680
1640
1780
1740
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?
12:11
10:7
8:7
13:11
16: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?
23%
28%
26%
19%
33%
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 %

In context of database DML Means
Data Multiplication Line
Data Manupulation Language
Data Method Limit
Data Merit Logic

Which among following SQL commands is used to add a row
UPDATE
TRUNCATE
INSERT
ADD

Data dictionary tell DBMS
what files are in the database
what attributes are processed by data
what these files contain
all of above

Data item characteristics that are important in data management include
punctuation
language
spelling
width

Related fields in a data base are grouped to form
data file
data record
menu
bank

The distinguishable parts of a record are called
files
data
fields
formats

Which command is used to set a link between two database files
JOIN
UPDATE
BROWSE
SET RELATION

The command that adds a new field to an active database is
MODIFY LABEL
MODIFY COMMAND
MODIFY STRUCTURE
MODIFY REPORT

Administrative supervision of database activities is responsibility of
Database administrator
DP Manager
DB Manager
None of above

1 2 3 4