Which one of the following is a disadvantage of the database approach for an organization?

1. Centralized control

   Inhaltsverzeichnis Show

   • Answer (Detailed Solution Below)
   • Which of the following is the disadvantages of a database approach?
   • What are the advantages and disadvantages of database approach?
   • Which of the following is a disadvantage of using file
   • Which of the following are common drawbacks disadvantages of a file

2. High acquisition costs

3. Improved data integrity

4. Shared data

Answer (Detailed Solution Below)

Option 2 :

High acquisition costs

Free

Teaching Aptitude Mock Test

10 Questions 20 Marks 12 Mins

Database management system(DBMS)

1. "A database management system (DBMS) is a collection of programs that manages the database structure and controls access to the data stored in the database".  
2. The DBMS serves as the intermediary between the user and the database. The database structure itself is stored as a collection of files, So, we can access the data in those files through the DBMS.
3. The DBMS receives all application requests and translates them into the complex operations required to fulfill those requests. The DBMS hides much of the database’s internal complexity from the application programs and users.

Advantages of Database Management System (DBMS)

1. Improved data sharing

• An advantage of the database management approach is, the DBMS helps to create an environment in which end users have better access to more and better-managed data.
• Such access makes it possible for end-users to respond quickly to changes in their environment.

2. Improved data security

• The more users access the data, the greater the risks of data security breaches. Corporations invest considerable amounts of time, effort, and money to ensure that corporate data are used properly.
• A DBMS provides a framework for better enforcement of data privacy and security policies.

3. Better data integration

• Wider access to well-managed data promotes an integrated view of the organization’s operations and a clearer view of the big picture.
• It becomes much easier to see how actions in one segment of the company affect other segments.

4. Minimized data inconsistency

• Data inconsistency exists when different versions of the same data appear in different places.
• For example, data inconsistency exists when a company’s sales department stores a sales representative’s name as “Bill Brown” and the company’s personnel department stores that same person’s name as “William G. Brown,” or when the company’s regional sales office shows the price of a product as $45.95 and its national sales office shows the same product’s price as $43.95.
• The probability of data inconsistency is greatly reduced in a properly designed database.

 5. Improved data access

• The DBMS makes it possible to produce quick answers to ad hoc queries.
• From a database perspective, a query is a specific request issued to the DBMS for data manipulation—for example, to read or update the data.
• Simply put, a query is a question, and an ad hoc query is a spur-of-the-moment question.
• The DBMS sends back an answer (called the query result set) to the application. For example, end-users, when dealing with large amounts of sales data, might want quick answers to questions (ad hoc queries) such as:
  • What was the dollar volume of sales by-product during the past six months?
  • What is the sales bonus figure for each of our salespeople during the past three months?
  • How many of our customers have credit balances of 3,000 or more?

6. Improved decision making

• Better-managed data and improved data access make it possible to generate better-quality information, on which better decisions are based.
• The quality of the information generated depends on the quality of the underlying data.
• Data quality is a comprehensive approach to promoting the accuracy, validity, and timeliness of the data. While the DBMS does not guarantee data quality, it provides a framework to facilitate data quality initiatives.

7. Increased end-user productivity

• The availability of data, combined with the tools that transform data into usable information, empowers end users to make quick, informed decisions that can make the difference between success and failure in the global economy.

1. Increased acquisition costs

• One of the disadvantages of DBMS is Database systems require sophisticated hardware and software and highly skilled personnel.
• The cost of maintaining the hardware, software, and personnel required to operate and manage a database system can be substantial.
• Training, licensing, and regulatory compliance costs are often overlooked when database systems are implemented.

Therefore, High acquisition costs are not the advantage of a database management system.

Last updated on Nov 25, 2022

University Grants Commission (Minimum Standards and Procedures for Award of Ph.D. Degree) Regulations, 2022 notified. As, per the new regulations, candidates with a 4 years Undergraduate degree with a minimum CGPA of 7.5 can enroll for PhD admissions. The UGC NET Final Result for merged cycles of December 2021 and June 2022 was released on 5th November 2022.Along with the results UGC has also released the UGC NET Cut-Off.  With tis, the exam for the merged cycles of Dec 2021 and June 2022 have conclude. The notification for December 2022 is expected to be out soon. The UGC NET CBT exam consists of two papers - Paper I and Paper II. Paper I consists of 50 questions and Paper II consists of 100 questions. By qualifying this exam, candidates will be deemed eligible for JRF and Assistant Professor posts in Universities and Institutes across the country.

Which of the following is the disadvantages of a database approach?

What are the advantages and disadvantages of database approach?

Which of the following is a disadvantage of using file

Which of the following are common drawbacks disadvantages of a file