Which term describes the processing style used to run complex analytical queries over a data warehouse?
- A.OLTP
- B.OLAP
- C.FTP
- D.SMTP
Correct answer
Explanation
The correct answer is B, OLAP. Online analytical processing answers few but complex queries that aggregate, slice and compare historical data held in a data warehouse, which is what business intelligence dashboards and drill-down reports rest on. Option A is wrong because online transaction processing is the opposite style: a very large number of short insert and update operations in operational systems, where speed and accuracy per transaction matter and reversing the two is the standard trap. Option C is wrong because the file transfer protocol moves files between computers over a network and is unrelated to analysis. Option D is wrong because the simple mail transfer protocol sends electronic mail. Learn the companion term too: data mining is the discovery of patterns, clusters and associations in such large stores of data.
Read the full article: Business Software: ERP, CRM, MIS and Tally Basics
Practice Questions
View allIn business software, ERP stands for what?
- A.Electronic Record Processing
- B.Enterprise Resource Planning
- C.Enterprise Report Publishing
- D.External Resource Protocol
Show answer
An ERP package replaces separate departmental programs with one integrated suite built on a single shared database, so a transaction entered once flows through stock, production, dispatch and the ledger.
Read the full explanation →Which type of software is used to manage a company's contacts, enquiries, campaigns and service history?
- A.CRM software
- B.Compiler
- C.Device driver
- D.Disk defragmenter
Show answer
Customer relationship management software keeps the record of every dealing with a customer or prospect, including contacts, enquiries, calls, complaints, campaigns and purchase history, and is divided into operational, analytical and collaborative CRM.
Read the full explanation →Tally is best described as which kind of software?
- A.Operating system
- B.Accounting software
- C.Antivirus software
- D.Web browser
Show answer
Tally, from Tally Solutions of Bengaluru, keeps ledgers and groups, takes entries as vouchers, and produces the trial balance, profit and loss account, balance sheet, day book and stock summary without separate work; later versions added inventory, payroll and tax features, and the current line is TallyPrime.
Read the full explanation →Which system mainly records the routine day-to-day transactions of an organisation?
- A.Transaction processing system
- B.Executive information system
- C.Decision support system
- D.Knowledge management system
Show answer
A TPS serves the operational level, capturing sales, deposits, bookings, issues of material and payroll entries as they happen, where accuracy, speed and reliability matter more than analysis; it is also the source of the data that higher systems later summarise.
Read the full explanation →SAP, Oracle and Microsoft Dynamics are well-known products in which category?
- A.Antivirus suites
- B.ERP software
- C.Image editors
- D.Operating systems
Show answer
All three are sold as enterprise resource planning suites, with modules for finance, human resources, materials, manufacturing and sales working on one shared database; Infor belongs to the same list, and Odoo and the Indian ERPNext are the open-source examples.
Read the full explanation →