ICAR-IASRI MSc and PhD Databases, Big Data & Agricultural Information Systems: practice questions
ICAR-IASRI MSc and PhD (Agricultural Statistics, Computer Application, Bioinformatics) · India · ICAR-Indian Agricultural Statistics Research Institute with the IARI Graduate School
Original practice questions written to the published syllabus · not past papers
10worked here, free
22written to this exam in this subject
10syllabus units
About ICAR-IASRI MSc and PhD
ICAR-IASRI MSc and PhD (Agricultural Statistics, Computer Application, Bioinformatics) is a postgraduate admission exam run by ICAR-Indian Agricultural Statistics Research Institute with the IARI Graduate School, for candidates in India. Admission through ICAR AIEEA-PG (Master's) and AICE-JRF/SRF (PhD) plus the Graduate School's own process.
We have not been able to confirm these details against the exam body's own specification, so fees, dates and pass marks are left out on purpose. Check the current format, eligibility, fees and dates on the official site.
Databases, Big Data & Agricultural Information Systems in ICAR-IASRI MSc and PhD
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 ICAR-IASRI MSc and PhD questions in this subject: 15 easy, 7 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 ICAR-IASRI MSc and PhD and are not shown on any other exam's page.
Question 1 · easy
A minimal set of attributes that uniquely identifies each row of a relation is a:
Foreign key that refers to another table
Candidate key
Superkey with extra redundant attributes
Composite index on non-key columns
Answer and working
B. Candidate key
A superkey may contain unnecessary attributes; a candidate key is minimal.
Question 2 · easy
The 'A' in ACID stands for:
Atomicity of each transaction
Availability of the system
Accuracy of the stored values
Authentication of users
Answer and working
A. Atomicity of each transaction
Consistency, isolation and durability complete the set.
Question 3 · easy
Storing each district's farm records at that district's server is:
Vertical fragmentation of columns
Full replication at every site
Denormalisation into a star schema
Horizontal fragmentation
Answer and working
D. Horizontal fragmentation
Rows are split by district.
Question 4 · medium
Replication of data across sites mainly improves:
Write speed, since copies never need to be kept consistent
Availability and read performance
Normal form of the tables
Accuracy of each measurement
Answer and working
B. Availability and read performance
Keeping copies consistent is the cost.
Question 5 · medium
Stock levels of grain in stores are a semi-additive measure because they can be summed over:
Time but not over stores, as monthly stocks accumulate
Nothing at all
Stores and regions but not over time
Only the time dimension
Answer and working
C. Stores and regions but not over time
Summing monthly stocks over a year is meaningless.
Question 6 · easy
In a distributed file system, data blocks are replicated (by default three times) mainly to:
Speed up writing by spreading each block over many disks
Survive machine failures
Save storage space
Normalise the data
Answer and working
B. Survive machine failures
Losing one machine loses no data.
Question 7 · medium
The 'variety' characteristic of big data refers to:
The number of crop varieties recorded in the data set
Rapid arrival of data
The usefulness of data
Many formats, from tables to images and text
Answer and working
D. Many formats, from tables to images and text
Velocity is speed; value is usefulness.
Question 8 · easy
Drone plant height is commonly derived from:
The colour of leaves alone
Soil moisture readings
Digital surface models from photogrammetry
Market prices
Answer and working
C. Digital surface models from photogrammetry
Height = surface model minus terrain model.
Question 9 · medium
Provenance metadata describe:
Only the file size
The colour of maps
How data were collected and processed
The price of the data
Answer and working
C. How data were collected and processed
Provenance is essential for reuse.
Question 10 · easy
The three components of a decision-support system are:
Keyboard, mouse and screen
Sensor, gateway and drone
Fact, dimension and cube
Database, model base and user interface
Answer and working
D. Database, model base and user interface
Models let users ask 'what if' questions.
A study plan for Databases, Big Data & Agricultural Information Systems in ICAR-IASRI MSc and PhD
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%); Sensor, IoT and drone data pipelines (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: Data warehousing: star and snowflake schemas, OLAP (2, 9%); Distributed databases (2, 9%); FAIR principles, metadata and data governance (2, 9%); Relational model, ER modelling and normalisation (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: Relational model, ER modelling and normalisation (2 easy of 2); SQL and PL/SQL (2 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.