Data Interpretation - General Aptitude - General Aptitude (GA) Previous Year Questions

How many tuples does the result of the following relational algebra expression contain? Assume that the schema of A∪B is the same as that of A.
(A∪B) ⋈ A.Id > 40 ∨ C.Id < 15 C

The table below has question-wise data on the performance of students in an examination. The marks for each question are also listed. There is no negative or partial marking in the examination.

Q No.	Marks	Answered Correctly	Answered Wrongly	Not Attempted
1	2	21	17	6
2	3	15	27	2
3	2	23	18	3

What is the average of the marks obtained by the class in the examination?

The pie chart below has the breakup of the number of students from different departments in an engineering college for the year 2012. The proportion of male to female students in each department is 5:4. There are 40 males in Electrical Engineering. What is the difference between the numbers of female students in the Civil department and the female students in the Mechanical department?

The number of students in a class who have answered correctly, wrongly, or not attempted each question in an exam, are listed in the table below. The marks for each question are also listed. There is no negative or partial marking.

Q No.	Marks	Answered Correctly	Answered Wrongly	Not Attempted
1	2	21	17	6
2	3	15	27	2
3	1	11	29	4
4	2	23	18	3
5	5	31	12	1

What is the average of the marks obtained by the class in the examination?
(A) 2.290 (B) 2.970 (C) 6.795 (D) 8.795

A file is organized so that the ordering of data records is the same as or close to the ordering of data entries in some index. Then that index is called

Consider an Entity-Relationship (ER) model in which entity sets \( E_1 \) and \( E_3 \) are connected by an \( m : n \) relationship \( R_{12} \), \( E_1 \) and \( E_3 \) are connected by a \( 1 : n \) (1 on the side of \( E_1 \) and \( n \) on the side of \( E_3 \)) relationship \( R_{13} \). \( E_1 \) has two single-valued attributes \( a_{11} \) and \( a_{12} \) of which \( a_{11} \) is the key attribute. \( E_2 \) has two single-valued attributes \( a_{21} \) and \( a_{22} \) of which \( a_{21} \) is the key attribute. \( E_3 \) has two single-valued attributes \( a_{31} \) and \( a_{32} \) of which \( a_{31} \) is the key attribute. The relationships do not have any attributes. If a relational model is derived from the above ER model, then the minimum number of relations that would be generated if all the relations are in 3NF is __________.

The exports and imports (in crores of Rs.) of a country from the year 2000 to 2007 are given in the following bar chart. In which year is the combined percentage increase in imports and exports the highest?

A shaving set company sells 4 different types of razors, Elegance, Smooth, Soft and Executive. Elegance sells at Rs. 48, Smooth at Rs. 63, Soft at Rs. 78 and Executive at Rs. 173 per piece. The table below shows the numbers of each razor sold in each quarter of a year.

Quarter \ Product	Elegance	Smooth	Soft	Executive
Q1	27300	20009	17602	9999
Q2	25222	19392	18445	8942
Q3	28976	22429	19544	10234
Q4	21012	18229	16595	10109

Which product contributes the greatest fraction to the revenue of the company in that year?

An air pressure contour line joins locations in a region having the same atmospheric pressure. The following is an air pressure contour plot of a geographical region. Contour lines are shown at 0.05 bar intervals in this plot.

If the possibility of a thunderstorm is given by how fast air pressure rises or drops over a region, which of the following regions is most likely to have a thunderstorm?

In the given diagram, teachers are represented in the triangle, researchers in the circle and administrators in the rectangle. Out of the total number of the people, the percentage of administrators shall be in the range of ____.

The number of units of a product sold in three different years and the respective net profits are presented in the figure above. The cost/unit in Year 3 was 1, which was half the cost/unit in Year 2. The cost/unit in Year 3 was one-third of the cost/unit in Year 1. Taxes were paid on the selling price at 10%, 13% and 15% respectively for the three years. Net profit is calculated as the difference between the selling price and the sum of cost and taxes paid in that year.
The ratio of the selling price in Year 2 to the selling price in Year 3 is ______.

The pie charts depict the shares of various power generation technologies in the total electricity generation of a country for the years 2007 and 2023.
The renewable sources of electricity generation consist of Hydro, Solar and Wind. Assuming that the total electricity generated remains the same from 2007 to 2023, what is the percentage increase in the share of the renewable sources of electricity generation over this period?