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.
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:
A foreign key placed in the farmer table only
A single combined table with repeated groups
Two tables with no link between them
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:
No attribute is ever null in the table
Every determinant is a candidate key
All attributes are numeric values
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?
DECLARE, BEGIN, EXCEPTION, END
SELECT, FROM, WHERE, GROUP
CREATE, ALTER, DROP, TRUNCATE
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:
Phantom read of new rows
Non-repeatable read of changed rows
Lost update of a value
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:
Disk-based MapReduce is slow for iterative statistical algorithms mainly because it:
Cannot read numbers, only text records in plain files
Runs on only one machine
Writes intermediate results to disk at each step
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:
A normalised relational database
A faster OLTP system
A star schema
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:
FAO's multilingual agricultural thesaurus
A crop simulation model
A database engine
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:
Compression and replication
Collective benefit and authority to control
Caching and encryption
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:
Routine summary reports
What-if simulation
Inference by rules
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.
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.
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.
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.
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.
Finish timed. Sit the subject as a timed set without notes, mark it, and send each wrong answer back to its unit above.