LAISHA
Open Laisha

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.

Official site: iasri.icar.gov.in.

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:

  1. Foreign key that refers to another table
  2. Candidate key
  3. Superkey with extra redundant attributes
  4. 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:

  1. Atomicity of each transaction
  2. Availability of the system
  3. Accuracy of the stored values
  4. 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:

  1. Vertical fragmentation of columns
  2. Full replication at every site
  3. Denormalisation into a star schema
  4. Horizontal fragmentation
Answer and working

D. Horizontal fragmentation

Rows are split by district.

Question 4 · medium

Replication of data across sites mainly improves:

  1. Write speed, since copies never need to be kept consistent
  2. Availability and read performance
  3. Normal form of the tables
  4. 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:

  1. Time but not over stores, as monthly stocks accumulate
  2. Nothing at all
  3. Stores and regions but not over time
  4. 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:

  1. Speed up writing by spreading each block over many disks
  2. Survive machine failures
  3. Save storage space
  4. 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:

  1. The number of crop varieties recorded in the data set
  2. Rapid arrival of data
  3. The usefulness of data
  4. 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:

  1. The colour of leaves alone
  2. Soil moisture readings
  3. Digital surface models from photogrammetry
  4. Market prices
Answer and working

C. Digital surface models from photogrammetry

Height = surface model minus terrain model.

Question 9 · medium

Provenance metadata describe:

  1. Only the file size
  2. The colour of maps
  3. How data were collected and processed
  4. 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:

  1. Keyboard, mouse and screen
  2. Sensor, gateway and drone
  3. Fact, dimension and cube
  4. 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.

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

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

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

  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-IASRI MSc and PhD 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.