LAISHA
Open Laisha

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.

Source: gate2027.iitm.ac.in.

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?

  1. 30
  2. 200
  3. 10
  4. 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:

  1. Partial, violating 2NF
  2. Trivial and harmless
  3. Transitive, violating 3NF
  4. 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:

  1. No rows
  2. All rows with missing yields
  3. All rows in the table
  4. 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:

  1. FROM
  2. SELECT, which is evaluated first
  3. ORDER BY, which sorts input rows
  4. 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:

  1. Exact-match lookups only
  2. Tables with a single row
  3. Range queries
  4. 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:

  1. Dimension table describing context
  2. Junction table of a many-to-many link
  3. Fact table
  4. 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:

  1. Drill-down to finer detail
  2. Slice at a single value
  3. Pivot of the axes
  4. Roll-up
Answer and working

D. Roll-up

Drill-down goes the other way.

Question 8 · medium

Time-series databases are designed mainly for:

  1. Text documents of varying structure
  2. Timestamped readings arriving continuously
  3. Pedigree relationships
  4. 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:

  1. Free of errors
  2. Findable over the long term
  3. Faster to download
  4. 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:

  1. Only printed annual reports
  2. Text messages, voice, radio and web
  3. Only face-to-face meetings
  4. 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.

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. Finish timed. Sit the subject as a timed set without notes, mark it, and send each wrong answer back to its unit above.

Last updated · How Laisha writes and checks its pages · Report a mistake

Ask Laisha about this

Opens Laisha's chat with your question ready to send. Sign in or start free.

Unlock every question — GATE DA Databases, Big Data & Agricultural Information Systems

US$10 a month · one price worldwide · cancel any time

  • Every practice question in this subject, with full working
  • Timed exam papers and progress by unit
  • Ask Laisha to explain any answer — up to 1,000 questions a month
Free or Smarter
FreeSmarter
Grow guides, pest pages, articlesRead allRead all
Ask Laisha5 a dayUp to 1,000 a month
Exam practiceThe sample on each pageEvery question, timed papers
Crop calendar and pest alerts—For your own fields
Calculators and tools—All
Uploads and reports—100 a month, real files
10 days free for every new account, no card.