LAISHA
Open Laisha

ICAR AICE-JRF/SRF Databases, Big Data & Agricultural Information Systems: practice questions

ICAR AICE-JRF/SRF - Agricultural Statistics, Computer Application, Bioinformatics (PhD admission and fellowship) · India · National Testing Agency for ICAR

Original practice questions written to the published syllabus · not past papers
10worked here, free
34written to this exam in this subject
10syllabus units

About ICAR AICE-JRF/SRF

ICAR AICE-JRF/SRF - Agricultural Statistics, Computer Application, Bioinformatics (PhD admission and fellowship) is a PhD, fellowship and lectureship exam run by National Testing Agency for ICAR, for candidates in India. Computer-based test, 2 hours, 120 MCQs, +4 / -1 (Part A general, Part B core group, Part C subject). 2026 exam held with AIEEA-PG in July 2026.

Source: icar.org.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 ICAR AICE-JRF/SRF

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 34 ICAR AICE-JRF/SRF questions in this subject: 0 easy, 28 medium, 6 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 ICAR AICE-JRF/SRF and are not shown on any other exam's page.

Question 1 · medium

A many-to-many relationship between farmers and traders is implemented in a relational schema with:

  1. A foreign key placed in the farmer table only
  2. A single combined table with repeated groups
  3. Two tables with no link between them
  4. A junction table holding both keys
Answer and working

D. A junction table holding both keys

The junction table's key combines farmer and trader keys, giving three tables.

Question 2 · medium

Boyce–Codd normal form requires that:

  1. No attribute is ever null in the table
  2. Every determinant is a candidate key
  3. All attributes are numeric values
  4. Each table has exactly two columns
Answer and working

B. Every determinant is a candidate key

BCNF is stricter than 3NF.

Question 3 · medium

A PL/SQL block consists of which sections?

  1. DECLARE, BEGIN, EXCEPTION, END
  2. SELECT, FROM, WHERE, GROUP
  3. CREATE, ALTER, DROP, TRUNCATE
  4. COMMIT, ROLLBACK, SAVEPOINT, END
Answer and working

A. DECLARE, BEGIN, EXCEPTION, END

Variables are declared, statements executed and errors handled.

Question 4 · medium

Reading data written by a transaction that later rolls back is a:

  1. Phantom read of new rows
  2. Non-repeatable read of changed rows
  3. Lost update of a value
  4. Dirty read
Answer and working

D. Dirty read

Read committed isolation prevents it.

Question 5 · hard

Survey responses whose structure changes between questionnaire versions are conveniently stored in:

  1. A fixed relational table without changes
  2. A hash index
  3. A star schema fact table only
  4. A document store
Answer and working

D. A document store

Self-describing JSON documents accommodate varying structure.

Question 6 · medium

Disk-based MapReduce is slow for iterative statistical algorithms mainly because it:

  1. Cannot read numbers, only text records in plain files
  2. Runs on only one machine
  3. Writes intermediate results to disk at each step
  4. Needs no shuffle
Answer and working

C. Writes intermediate results to disk at each step

In-memory frameworks avoid this.

Question 7 · medium

A data lake without metadata and governance risks becoming:

  1. A normalised relational database
  2. A faster OLTP system
  3. A star schema
  4. A 'data swamp' of undocumented files
Answer and working

D. A 'data swamp' of undocumented files

Raw data are useless without documentation.

Question 8 · medium

AGROVOC is:

  1. FAO's multilingual agricultural thesaurus
  2. A crop simulation model
  3. A database engine
  4. A sensor protocol
Answer and working

A. FAO's multilingual agricultural thesaurus

It standardises agricultural terms across languages.

Question 9 · medium

The CARE principles for Indigenous data governance emphasise:

  1. Compression and replication
  2. Collective benefit and authority to control
  3. Caching and encryption
  4. Coding and reporting
Answer and working

B. Collective benefit and authority to control

They complement FAIR with Indigenous data sovereignty.

Question 10 · medium

Management information systems mainly provide:

  1. Routine summary reports
  2. What-if simulation
  3. Inference by rules
  4. Raw sensor streams only
Answer and working

A. Routine summary reports

DSS add models for semi-structured decisions.

A study plan for Databases, Big Data & Agricultural Information Systems in ICAR AICE-JRF/SRF

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 (56% of the 34 questions): Relational model, ER modelling and normalisation (5, 15%); SQL and PL/SQL (5, 15%); Transactions, concurrency, indexing and recovery (5, 15%); Data warehousing: star and snowflake schemas, OLAP (4, 12%).

    Read the manual chapters for these first and do every worked question you can find on them.

  2. Then the middle band: Distributed databases (4, 12%); Agricultural information and decision-support systems (3, 9%); Big-data tools: distributed storage and processing (3, 9%); Sensor, IoT and drone data pipelines (3, 9%).

    Aim for one sitting per unit, then mixed questions across them.

  3. Then the lighter units: APIs, open-data portals and data standards (e.g. FAOSTAT, national portals) (1, 3%); FAIR principles, metadata and data governance (1, 3%).

    Learn the definitions, classifications and standard numbers; these units are more often recalled than worked.

  4. Leave time for the hard ones: Sensor, IoT and drone data pipelines (1 hard of 3), Data warehousing: star and snowflake schemas, OLAP (1 hard of 4), Distributed databases (1 hard of 4).

    Come back to these after a first pass, untimed, and read every explanation, including for the options you rejected.

  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 — ICAR AICE-JRF/SRF 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.