Scribd
Upload
11 views4 pages

Database Advantages and Disadvantages Quiz

Uploaded by

Sora
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
11 views4 pages

Database Advantages and Disadvantages Quiz

Uploaded by

Sora
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Database Management Systems - Quiz

1. True or False: Normalization reduces update anomalies in databases.


2. The programming language used to define the database structure is called:■A. DML■B. SQL■C. DDL■D. HT
3. True or False: SQL is the ANSI standard query language for relational databases.
4. The programming language used to define the database structure is called:■A. DML■B. SQL■C. DDL■D. HT
5. DDL defines the database on three levels. Which is NOT one of them?■A. Internal view■B. Conceptual view■
6. True or False: SQL is the ANSI standard query language for relational databases.
7. An insertion anomaly occurs when:■A. Adding a new record is not possible without related data■B. Updating
8. The relational algebra functions include:■A. Restrict, Project, Join■B. Add, Delete, Update■C. Select, Modify,
9. Which of the following is a disadvantage of the database approach?■A. Increased redundancy■B. High imple
10. True or False: SQL is the ANSI standard query language for relational databases.
11. An insertion anomaly occurs when:■A. Adding a new record is not possible without related data■B. Updating
12. DDL defines the database on three levels. Which is NOT one of them?■A. Internal view■B. Conceptual view
13. True or False: Flat-file systems eliminate data redundancy.
14. The programming language used to define the database structure is called:■A. DML■B. SQL■C. DDL■D. H
15. DDL defines the database on three levels. Which is NOT one of them?■A. Internal view■B. Conceptual view
16. Which of the following is a disadvantage of the database approach?■A. Increased redundancy■B. High impl
17. Which of the following is a disadvantage of the database approach?■A. Increased redundancy■B. High impl
18. True or False: Flat-file systems eliminate data redundancy.
19. DDL defines the database on three levels. Which is NOT one of them?■A. Internal view■B. Conceptual view
20. Which database model portrays data as two-dimensional tables?■A. Hierarchical■B. Network■C. Relational
21. The relational algebra functions include:■A. Restrict, Project, Join■B. Add, Delete, Update■C. Select, Modif
22. Which of the following is a disadvantage of the database approach?■A. Increased redundancy■B. High impl
23. DDL defines the database on three levels. Which is NOT one of them?■A. Internal view■B. Conceptual view
24. True or False: Flat-file systems eliminate data redundancy.
25. Which of the following is NOT an advantage of a database system?■A. Data redundancy■B. Data sharing■C
26. DDL defines the database on three levels. Which is NOT one of them?■A. Internal view■B. Conceptual view
27. Which of the following is a disadvantage of the database approach?■A. Increased redundancy■B. High impl
28. Which of the following is NOT an advantage of a database system?■A. Data redundancy■B. Data sharing■C
29. An insertion anomaly occurs when:■A. Adding a new record is not possible without related data■B. Updating
30. An insertion anomaly occurs when:■A. Adding a new record is not possible without related data■B. Updating
31. The relational algebra functions include:■A. Restrict, Project, Join■B. Add, Delete, Update■C. Select, Modif
32. True or False: SQL is the ANSI standard query language for relational databases.
33. The relational algebra functions include:■A. Restrict, Project, Join■B. Add, Delete, Update■C. Select, Modif
34. Which database model portrays data as two-dimensional tables?■A. Hierarchical■B. Network■C. Relational
35. DDL defines the database on three levels. Which is NOT one of them?■A. Internal view■B. Conceptual view
36. The relational algebra functions include:■A. Restrict, Project, Join■B. Add, Delete, Update■C. Select, Modif
37. Which of the following is NOT an advantage of a database system?■A. Data redundancy■B. Data sharing■C
38. Which database model portrays data as two-dimensional tables?■A. Hierarchical■B. Network■C. Relational
39. DDL defines the database on three levels. Which is NOT one of them?■A. Internal view■B. Conceptual view
40. The programming language used to define the database structure is called:■A. DML■B. SQL■C. DDL■D. H
Financial and Reporting Systems - Quiz

1. Which of the following is the principal file used in the General Ledger System?■A. Budget Master File■B. Gen
2. True or False: XBRL taxonomies are classification schemes for financial data.
3. Which management decision type deals with long-term goals and high uncertainty?■A. Operational control■B
4. Which is an advantage of using DB technology in GL/FRS?■A. Delayed reconciliation■B. Real-time updates■
5. Responsibility centers include all EXCEPT:■A. Cost center■B. Profit center■C. Training center■D. Investmen
6. Which is an advantage of using DB technology in GL/FRS?■A. Delayed reconciliation■B. Real-time updates■
7. The general ledger system should NOT:■A. Validate transactions■B. Generate timely financial reports■C. Ha
8. True or False: XBRL taxonomies are classification schemes for financial data.
9. True or False: Improperly prepared journal entries pose a risk to GL/FRS.
10. Which of the following is the principal file used in the General Ledger System?■A. Budget Master File■B. Ge
11. Which type of responsibility center focuses only on keeping costs within limits?■A. Profit Center■B. Investme
12. Responsibility centers include all EXCEPT:■A. Cost center■B. Profit center■C. Training center■D. Investme
13. True or False: The Management Reporting System is primarily used for external reporting.
14. True or False: The Management Reporting System is primarily used for external reporting.
15. True or False: The Management Reporting System is primarily used for external reporting.
16. Which type of responsibility center focuses only on keeping costs within limits?■A. Profit Center■B. Investme
17. Which of the following is the principal file used in the General Ledger System?■A. Budget Master File■B. Ge
18. True or False: Improperly prepared journal entries pose a risk to GL/FRS.
19. Which is an advantage of using DB technology in GL/FRS?■A. Delayed reconciliation■B. Real-time updates
20. Responsibility centers include all EXCEPT:■A. Cost center■B. Profit center■C. Training center■D. Investme
21. True or False: Improperly prepared journal entries pose a risk to GL/FRS.
22. Responsibility centers include all EXCEPT:■A. Cost center■B. Profit center■C. Training center■D. Investme
23. Which reporting language is XML-based and used for financial reporting?■A. HTML■B. XBRL■C. SQL■D. D
24. Which type of responsibility center focuses only on keeping costs within limits?■A. Profit Center■B. Investme
25. Which of the following is the principal file used in the General Ledger System?■A. Budget Master File■B. Ge
26. True or False: XBRL taxonomies are classification schemes for financial data.
27. Which type of responsibility center focuses only on keeping costs within limits?■A. Profit Center■B. Investme
28. True or False: XBRL taxonomies are classification schemes for financial data.
29. True or False: Improperly prepared journal entries pose a risk to GL/FRS.
30. Which reporting language is XML-based and used for financial reporting?■A. HTML■B. XBRL■C. SQL■D. D
31. Which is an advantage of using DB technology in GL/FRS?■A. Delayed reconciliation■B. Real-time updates
32. True or False: The Management Reporting System is primarily used for external reporting.
33. Which reporting language is XML-based and used for financial reporting?■A. HTML■B. XBRL■C. SQL■D. D
34. Responsibility centers include all EXCEPT:■A. Cost center■B. Profit center■C. Training center■D. Investme
35. Which of the following is the principal file used in the General Ledger System?■A. Budget Master File■B. Ge
36. Which of the following is the principal file used in the General Ledger System?■A. Budget Master File■B. Ge
37. Which type of responsibility center focuses only on keeping costs within limits?■A. Profit Center■B. Investme
38. True or False: XBRL taxonomies are classification schemes for financial data.
39. Which is an advantage of using DB technology in GL/FRS?■A. Delayed reconciliation■B. Real-time updates
40. The general ledger system should NOT:■A. Validate transactions■B. Generate timely financial reports■C. H

Common questions

Powered by AI

Relational algebra functions are foundational to querying and manipulating relational databases. Functions like Restrict, Project, and Join allow for effective data retrieval and transformation by specifying how data should be filtered, displayed, or combined across tables. These functions are vital for constructing logical queries, optimizing database performance, and ensuring accurate data analysis .

Hierarchical and network database models lack the flexibility and simplicity of two-dimensional data representation provided by relational models. While hierarchical models represent data in a tree-like structure and network models use complex graph structures, relational models use tables, which are more intuitive for data manipulation and querying. This makes relational models better suited for handling evolving data relationships and supporting a broader range of applications .

Flat-file systems often lead to data redundancy because they store data in a single table format without relational integrity, causing repeated entries for similar data items. Additionally, flat-file systems don't support complex queries well, as they lack the relational structure found in databases that can efficiently manage and retrieve interrelated records. This makes them less effective for applications requiring complex data manipulation and structure .

Responsibility centers are organizational units assigned specific financial responsibilities, including cost centers (focus on controlling costs), profit centers (focus on generating profit), and investment centers (focus on ROI). Training centers, however, are not typically considered responsibility centers as they primarily focus on employee development rather than financial outcomes .

Real-time updating in GL/FRS is advantageous because it enables timely and accurate financial reporting, which is crucial for decision-making and regulatory compliance. It allows financial data to be updated instantly across all systems, reducing errors and eliminating the delays typically associated with batch processing, thereby enhancing the responsiveness of financial management processes .

DDL is essential in database management as it defines the database structure and schema. It specifies the database on three levels: internal, conceptual, and external views. These levels help organize how data is stored, viewed, and interacted with by users and various applications, offering a structured way to manage complex data relationships .

SQL's role as an ANSI standard query language is critical because it provides a standardized way to query and manipulate databases, ensuring compatibility and interoperability across different database systems. Standardization simplifies database interactions, promotes consistency across applications, and facilitates a shared understanding of data management practices in the industry .

Normalization reduces update anomalies by organizing data into related tables, which minimizes redundancy and ensures that updates to data only need to be performed in one place. This structure prevents inconsistent data updates across the database by ensuring that duplicate data is kept to a minimum or eliminated entirely .

XBRL taxonomies are classification schemes used to tag financial data, providing a framework for encoding data that enhances the automation of financial reporting and facilitates the exchange of data between different software applications. This standardized tagging system improves data comparability and transparency, enabling more efficient and accurate analysis and reporting of financial statements .

The database approach can introduce high implementation complexity as it requires sophisticated software for database management, which can increase the intricacy of setting up and maintaining the system. There might also be a perception of increased redundancy if the system is not properly normalized, leading to data duplication and associated anomalies. These challenges require careful planning and management to ensure efficient database performance .

You might also like