uiz Space

January 2026 term · Database Management Systems · BSCS2001

Database Management Systems Quiz 2: 12 April 2026, Set 2 (January 2026 term)

The IIT Madras BS Database Management Systems (DBMS) Quiz 2 paper sat on 12 Apr 2026, in the January 2026 term, set 2: 18 questions for 18 marks in 120 minutes. Every question is below with its answer. Take it as a timed mock test to be marked, or read it through first.

Questions
18
Marks
18
Duration
120 min
MCQ
15
MSQ
2
Written
1
Take as mock testPractise with answers

Updated

Official paper: Business Data Management 06 Apr 26 · No negative marking.

Question 1

+1 markOne correct option

In FY 2022 vs FY 2021, e-commerce order volume grew by 69.4% while Gross Merchandise Value (GMV) grew by 73.6%, and average order value (AOV) grew by just 2.5% YoY. What does the near-parity of order volume growth and GMV growth, with only marginal AOV increase, most likely indicate?

  1. A

    Customers are buying significantly more expensive products than before

  2. B

    Growth is primarily driven by a surge in the number of transactions rather than higher spending per order

  3. C

    Sellers are increasing prices substantially across all categories

  4. D

    The e-commerce market is shrinking in terms of customer base

Show answer

Correct answer

  • B

    Growth is primarily driven by a surge in the number of transactions rather than higher spending per order

Question 1 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 2

+1 markOne correct option

Pepperfry sells exclusively furniture and home decor, while Amazon India sells everything from groceries to electronics. A new founder wants to launch an online store selling only organic baby food in India. Which market strategy does this represent, and what is the primary advantage?

  1. A

    Mass market: wider customer reach leads to more revenue

  2. B

    Niche market: focused positioning allows deeper expertise and customer loyalty in a specific segment

  3. C

    Mass market: organic baby food appeals to all demographics equally

  4. D

    Niche market: lower investment is needed because there is no competition

Show answer

Correct answer

  • B

    Niche market: focused positioning allows deeper expertise and customer loyalty in a specific segment

Question 2 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 3

+1 markOne correct option

A smartphone brand is launching a rugged, waterproof phone priced at INR 15,000 with a high-quality camera. Using the user personas, which profile is the best primary target, and why?

  1. A

    Rajesh Sharma (Tech Enthusiast): he loves the latest gadgets

  2. B

    Aishwarya Singh (Fashion Influencer): she needs good camera quality

  3. C

    Mohan Gupta (Adventure Seeker): his needs for rugged durability, photography, and outdoor use align perfectly with the product, and the price fits his INR 6,00,000 income

  4. D

    Ananya Verma (Business Professional): she values productivity tools

Show answer

Correct answer

  • C

    Mohan Gupta (Adventure Seeker): his needs for rugged durability, photography, and outdoor use align perfectly with the product, and the price fits his INR 6,00,000 income

Question 3 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 4

+1 markOne correct option

Nykaa (beauty-focused) and Flipkart (multi-category platform) both sell cosmetics online. Which of the following best explains why a customer might prefer buying from Nykaa over Flipkart for beauty products, despite Flipkart offering the same brands?

  1. A

    Nykaa always offers lower prices than Flipkart on cosmetics

  2. B

    Nykaa provides curated expertise, specialist content, and category-specific trust that a general platform cannot replicate easily

  3. C

    Flipkart does not have a return policy for beauty products

  4. D

    Platform companies are legally restricted from selling beauty products

Show answer

Correct answer

  • B

    Nykaa provides curated expertise, specialist content, and category-specific trust that a general platform cannot replicate easily

Question 4 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 5

+1 markOne correct option

The opening stock data shows SKU F01 has stock of 391 (H), 77 (C), and 50 (M), totalling 518 units. SKU F08 has 23, 6, and 2 totalling 31 units. If warehouse H accounts for 75.5% of F01's total stock but only 74.2% of F08's stock, and daily demand for F01 is 15 units from warehouse C, approximately how many days of stock does warehouse C have for F01?

  1. A

    Approximately 3 days

  2. B

    Approximately 5 days

  3. C

    Approximately 10 days

  4. D

    Approximately 26 days

Show answer

Correct answer

  • B

    Approximately 5 days

Question 5 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 6

+1 markOne correct option

A fast-fashion e-commerce company receives fresh inventory every morning based on the previous day's sales data, keeping almost zero buffer stock. During a surprise viral trend, they run out of a popular dress by noon. Which inventory management approach are they using, and what risk does this scenario illustrate?

  1. A

    FIFO method: risk of selling old stock first

  2. B

    EOQ model: risk of ordering too much at once

  3. C

    Just-In-Time (JIT): risk of stock-out when demand spikes unexpectedly

  4. D

    Par Stock method: risk of overstocking

Show answer

Correct answer

  • C

    Just-In-Time (JIT): risk of stock-out when demand spikes unexpectedly

Question 6 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 7

+1 markOne correct option

The FY 2022 vs FY 2021 segment-wise order volume growth chart shows Beauty & Personal Care leading at 143.3%, while Electronics & Home Appliances grew only 34.7%. What is the most reasonable business inference from this disparity?

  1. A

    Electronics products are declining in overall demand

  2. B

    Beauty & Personal Care is transitioning rapidly to online channels from offline, likely driven by factors like D2C brands and social commerce, while Electronics already had higher online maturity

  3. C

    Electronics companies are deliberately reducing online sales

  4. D

    Beauty products are inherently more profitable than electronics

Show answer

Correct answer

  • B

    Beauty & Personal Care is transitioning rapidly to online channels from offline, likely driven by factors like D2C brands and social commerce, while Electronics already had higher online maturity

Question 7 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 8

+1 markOne correct option

ACE Gears produces Gear Assembly 4, which requires Gear 4-A (made from Blank-011) and Gear 4-B (made from Blank-022). If ACE Gears receives an order for 500 units of Gear Assembly 4, and each assembly requires exactly one of each gear, how many blanks of each type are needed?

  1. A

    500 Blank-011 and 500 Blank-022

  2. B

    250 Blank-011 and 250 Blank-022

  3. C

    1000 Blank-011 and 1000 Blank-022

  4. D

    500 Blank-011 and 500 Blank-021

Show answer

Correct answer

  • A

    500 Blank-011 and 500 Blank-022

Question 8 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 9

+1 markOne correct option

The October 2019 Hobbing workstation schedule shows a capacity of 400 units on Monday and 800 units on Tuesday through Saturday, with Sundays off. The Broaching workstation runs at 780 units per day, Tuesday through Saturday, with Sunday and Monday off. In a standard week, what is the total combined weekly capacity of both workstations?

  1. A

    Hobbing: 4,400 + Broaching: 3,900 = 8,300 units

  2. B

    Hobbing: 4,800 + Broaching: 3,900 = 8,700 units

  3. C

    Hobbing: 4,400 + Broaching: 4,680 = 9,080 units

  4. D

    Hobbing: 4,000 + Broaching: 3,120 = 7,120 units

Show answer

Correct answer

  • A

    Hobbing: 4,400 + Broaching: 3,900 = 8,300 units

Question 9 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 10

+1 markOne correct option

The scatter plot of Gear Assembly sales quantity vs. two-year revenue shows GA6 (BS4/6) as a high-volume product (~225,000 units) and GA7 (BS4/6) as a high-revenue product (~INR 90 million). Most other assemblies cluster along a linear trend. What strategic insight can be drawn about GA6?

  1. A

    GA6 should be discontinued because its revenue per unit is low

  2. B

    GA6 is likely a lower-priced, high-demand product that drives production volume and capacity utilization. It is strategically important even if revenue per unit is modest

  3. C

    GA6 is an outlier caused by a data error and should be ignored

  4. D

    GA6 and GA7 are interchangeable in the product portfolio

Show answer

Correct answer

  • B

    GA6 is likely a lower-priced, high-demand product that drives production volume and capacity utilization. It is strategically important even if revenue per unit is modest

Question 10 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 11

+1 markOne correct option

Using the ABC classification for inventory, Category A items are high-value and tightly controlled with JIT ordering. In the Blank Cost data, Blank-011 costs INR 105, Blank-012 costs INR 35, and Blank-022 costs INR 25. If Blank-011 is used in multiple gear assemblies (GA3 and GA4), making it high-value and high-consumption, which inventory strategy should ACE Gears apply to Blank-011?

  1. A

    Economic Order Quantity (EOQ) with simple record-keeping

  2. B

    Just-In-Time with planned orders and accurate record maintenance

  3. C

    Planned Orders with safety stock and moderate controls

  4. D

    Bulk purchasing annually to get volume discounts

Show answer

Correct answer

  • B

    Just-In-Time with planned orders and accurate record maintenance

Question 11 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 12

+1 markOne correct option

A company uses BCG Matrix and invests heavily in high-growth, low-share products without improving their market share. What is the most likely long-term outcome?

  1. A

    Immediate profitability

  2. B

    Conversion into cash cows

  3. C

    Resource drain without guaranteed returns

  4. D

    Elimination of competition

Show answer

Correct answer

  • C

    Resource drain without guaranteed returns

Question 12 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 13

+1 markOne correct option

In PESTEL analysis, rising interest rates and exchange rate volatility would primarily impact which aspect of a firm’s strategy?

  1. A

    Internal operations

  2. B

    Economic environment affecting demand and costs

  3. C

    Legal compliance only

  4. D

    Product design

Show answer

Correct answer

  • B

    Economic environment affecting demand and costs

Question 13 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 14

+1 markOne correct option

Why does ABC analysis emphasize value rather than volume in inventory control?

  1. A

    High-volume items always generate highest profits

  2. B

    Operational focus should align with business impact, not quantity

  3. C

    Low-value items are irrelevant

  4. D

    Volume is harder to measure than value

Show answer

Correct answer

  • B

    Operational focus should align with business impact, not quantity

Question 14 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 15

+1 markOne correct option

Tesla integrates PESTEL, ABC, BCG, and TOWS frameworks. If Tesla uses strict control on battery cells while automating generic components like bolts, which framework logic is being applied?

  1. A

    BCG portfolio balancing

  2. B

    ABC classification focusing on high-value components

  3. C

    PESTEL macro analysis

  4. D

    TOWS strategy formulation

Show answer

Correct answer

  • B

    ABC classification focusing on high-value components

Question 15 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 16

+1 markOne or more correct options

According to the BCG Matrix, which statements are true?

Select all that apply.

  1. A

    Cash cows fund other business units

  2. B

    Stars require investment

  3. C

    Dogs always generate high growth

  4. D

    Question marks involve uncertainty and capital needs

Show answer

Correct answers

  • A

    Cash cows fund other business units

  • B

    Stars require investment

  • D

    Question marks involve uncertainty and capital needs

Question 16 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 17

+1 markOne or more correct options

Which of the following are valid implications of ABC classification?

Select all that apply.

  1. A

    Class A items need tight control

  2. B

    Class C items require high monitoring

  3. C

    Operational effort should scale with value

  4. D

    Automation is suitable for low-value items

Show answer

Correct answers

  • A

    Class A items need tight control

  • C

    Operational effort should scale with value

  • D

    Automation is suitable for low-value items

Question 17 on its own pageAlso asked in Quiz 2 12 Apr 2026

Question 18

+1 markWritten answer

(FIll in the blank) In ABC analysis, Class A items typically account for about 70-80% of ______ but only a small proportion of total items. NOTE: Enter the exact answer without any extra space in the beginning or at the end. Answers Case Sensitive : No

Show answer

A written answer, not marked automatically.

Question 18 on its own page