GATE DA Databases, Big Data & Agricultural Information Systems: practice questions
GATE - Data Science and Artificial Intelligence (DA) · India · IITs and IISc on rotation (2027: IIT Madras)
Original practice questions written to the published syllabus · not past papers
10worked here, free
22written to this exam in this subject
10syllabus units
About GATE DA
GATE - Data Science and Artificial Intelligence (DA) is a postgraduate admission exam run by IITs and IISc on rotation (2027: IIT Madras), for candidates in India. Computer-based, 3 hours, 100 marks (15 General Aptitude + 85 subject). MCQ, MSQ and NAT; negative marking on MCQ only.
Checked against the exam body's published information. Formats and fees change; confirm the current edition there before you book.
Databases, Big Data & Agricultural Information Systems in GATE DA
Storing and serving agricultural data at scale: relational design and SQL, data warehouses and multidimensional models, big-data tools, APIs and open-data portals, sensor and IoT streams, FAIR data and data governance, and the information systems that hold trial, survey and market data.
Our 22 GATE DA questions in this subject: 5 easy, 17 medium, 0 hard, across 10 units.
10 practice questions, worked
Choose an answer, then open the working. Each explanation says why the right answer is right and why the others are not.
These 10 were written to GATE DA and are not shown on any other exam's page.
Question 1 · medium
The Cartesian product of relations with 10 and 20 rows has how many rows?
30
200
10
400
Answer and working
B. 200
Every row of one is paired with every row of the other: 10 × 20.
Question 2 · medium
farm_id → village and village → district hold in a table keyed by farm_id. The dependency of district on farm_id is:
Partial, violating 2NF
Trivial and harmless
Transitive, violating 3NF
Multivalued, violating 4NF
Answer and working
C. Transitive, violating 3NF
District depends on the key through the non-key attribute village.
Question 3 · medium
In SQL, the condition WHERE yield = NULL returns:
No rows
All rows with missing yields
All rows in the table
An error in every database system
Answer and working
A. No rows
Comparisons with NULL are unknown; use IS NULL.
Question 4 · medium
The logical order of evaluation of a SELECT query begins with:
FROM
SELECT, which is evaluated first
ORDER BY, which sorts input rows
HAVING, which filters groups first
Answer and working
A. FROM
FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY.
Question 5 · medium
B+ tree indexes are preferred over hash indexes for:
Exact-match lookups only
Tables with a single row
Range queries
Data that are never searched
Answer and working
C. Range queries
Hash indexes support equality, not ranges.
Question 6 · easy
In a star schema, the central table of numeric measures is the:
Dimension table describing context
Junction table of a many-to-many link
Fact table
Lookup table of error codes
Answer and working
C. Fact table
Dimensions such as time, region and crop surround it.
Question 7 · medium
Moving from district totals to regional totals in an OLAP cube is:
Drill-down to finer detail
Slice at a single value
Pivot of the axes
Roll-up
Answer and working
D. Roll-up
Drill-down goes the other way.
Question 8 · medium
Time-series databases are designed mainly for:
Text documents of varying structure
Timestamped readings arriving continuously
Pedigree relationships
Survey weights
Answer and working
B. Timestamped readings arriving continuously
Retention policies keep raw and aggregated data efficiently.
Question 9 · medium
A persistent identifier such as a DOI mainly makes a data set:
Free of errors
Findable over the long term
Faster to download
Encrypted
Answer and working
B. Findable over the long term
Identifiers remain valid when locations change.
Question 10 · easy
Market information systems disseminate prices to farmers through:
Only printed annual reports
Text messages, voice, radio and web
Only face-to-face meetings
Only satellite images
Answer and working
B. Text messages, voice, radio and web
Timely prices improve bargaining positions.
A study plan for Databases, Big Data & Agricultural Information Systems in GATE DA
This plan follows where our questions actually fall, so the time goes where the marks are likely to be. It is our reading of the syllabus, not the exam body's weighting.
First, the heavy units (45% of the 22 questions): Big-data tools: distributed storage and processing (3, 14%); Data warehousing: star and snowflake schemas, OLAP (3, 14%); Agricultural information and decision-support systems (2, 9%); APIs, open-data portals and data standards (e.g. FAOSTAT, national portals) (2, 9%).
Read the manual chapters for these first and do every worked question you can find on them.
Then the middle band: Distributed databases (2, 9%); FAIR principles, metadata and data governance (2, 9%); Relational model, ER modelling and normalisation (2, 9%); Sensor, IoT and drone data pipelines (2, 9%).
Aim for one sitting per unit, then mixed questions across them.
Then the lighter units: SQL and PL/SQL (2, 9%); Transactions, concurrency, indexing and recovery (2, 9%).
Learn the definitions, classifications and standard numbers; these units are more often recalled than worked.
Bank the easy marks: Data warehousing: star and snowflake schemas, OLAP (2 easy of 3); Agricultural information and decision-support systems (1 easy of 2).
Do these early in revision so they are fast on the day.
Finish timed. Sit the subject as a timed set without notes, mark it, and send each wrong answer back to its unit above.