LV Manufacturing Company, one of India's leading automotive component manufacturers, had embarked on an ambitious digital transformation program by late 2024. They moved from legacy systems to SAP ERP tightly integrated
CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · PYQS · June 2026
LV Manufacturing Company, one of India's leading automotive component manufacturers, had embarked on an ambitious digital transformation program by late 2024. They moved from legacy systems to SAP ERP tightly integrated with Oracle Database 19c, deployed AWS S3 for backups, and adopted a Hyperledger-based blockchain to track raw material sourcing and shipment verification. LV Manufacturing Company also rolled out IoT-based factory sensors connected through a 5G private network to feed real-time production data into their Decision Support System (DSS). One of LV's largest trading partners was Mr. RK, a high-profile Mumbai-based stockbroker and commodities trader. Mr. RK was specialized in predictive investment strategies for manufacturing and logistics sectors, relying heavily on real-time operational data feeds from suppliers like LV. LV Manufacturing Company granted Mr. RK, API-based access to certain DSS metrics, secured through their corporate firewall and an API gateway. In early 2025, LV Manufacturing Company entered a large export contract with European automotive clients that required blockchain-verified shipping updates. Mr. RK's analytics platform consumed this blockchain data along with ERP metrics to predict LV's share performance. Mr. RK's analytics models flagged abrupt drops in LV's production output and delayed shipment logs. Blockchain ledger entries mismatched ERP shipment records. Firewall logs showed traffic spikes from unrecognized IP ranges—many geolocated outside India. Within days, Mr. RK's AWS-based data lake suffered corruption of historical performance datasets, causing predictive models to produce flawed investment signals. Forensics hinted at API credential compromise, likely through phishing of a LV admin user, coupled with firewall misconfiguration allowing API traffic from unvetted IP addresses. On Mr. RK's side, object versioning was disabled in S3, allowing corrupted data to overwrite originals without rollback. Investigators determined: Compromised API tokens were used to pull legitimate LV's data and inject falsified metrics. Attackers modified Oracle DB query responses in-transit before they hit the blockchain validation layer. Mr. RK's network security appliance was only in monitoring mode, so malicious packets were not blocked in real time. The attack impacted not only LV's credibility but also Mr. RK's financial standing, as some investments were made on the basis of tampered analytics. International clients demanded an independent blockchain audit, while both LV Manufacturing Company and Mr. RK had to halt operations temporarily for data restoration. Based on the above case answer the following: As LV Manufacturing Company want to move towards SAP ERP tightly integrated with Oracle Database, how the database files may be structured into a variety of forms to speed up access times and maximize storages space?
Answer & Explanation:
Organization of Database Files To speed up access times and maximize storage space, database files are structured into a variety of forms. These are the most typical database file organization structures: Sequential Files: Records are kept in a sequential file in a certain order. Data are appended to the file's end and accessed one at a time starting at the starting. Indexed Files: An index is made in an indexed file that associates each entry with a different identifier. This makes it possible to quickly retrieve particular files' records. Hashed Files: Datasets are assigned to specific positions in a hashed file according to a hashing algorithm. This enables quick access to particular records using a search key. Implementing hashed files for the live Application Programming Interface (API) data exchange ensures that database records can be retrieved instantly, while also providing a mechanism to verify that the query keys have not been tampered with or altered in-transit by unauthorized external traffic.
Topics: Data Analytics / Database Management
Related Questions in this Topic
- Cyb-D Solutions Pvt. Ltd. is a Chennai based Cyber security firm. This firm was hired by AB Bank after regulators flagge...
- Cyb-D Solutions Pvt. Ltd. is a Chennai based Cyber security firm. This firm was hired by AB Bank after regulators flagge...
- Cyb-D Solutions Pvt. Ltd. is a Chennai based Cyber security firm. This firm was hired by AB Bank after regulators flagge...
- Cyb-D Solutions Pvt. Ltd. is a Chennai based Cyber security firm. This firm was hired by AB Bank after regulators flagge...
- Cyb-D Solutions Pvt. Ltd. is a Chennai based Cyber security firm. This firm was hired by AB Bank after regulators flagge...