Database Management Quiz

What is a database?

• A collection of related files containing records on people, places, or things

• A software used to manage databases

• A tool for obtaining useful information from internal and external systems

• A system for organizing and managing data

What are the principles of a database management system?

• Control of data redundancy, data consistency, data dependence, and fixed queries

• Sharing of data, improved data integrity, improved security, and increased productivity

• Data definition capabilities, querying and reporting, data warehouses, and data mining

• Control of data redundancy, data consistency, data dependence, and enforcement of standards

What are the principal tools and technologies for accessing information from databases?

• Data definition capabilities, querying and reporting, data warehouses, and data mining

• Relational databases, non-relational databases, cloud databases, and distributed databases

• Data warehouses, Hadoop, in-memory computing, and analytic platforms

• Select, join, and project operations

Why are information policy, data administration, and data quality assurance essential?

• To control data redundancy, complexity, size, and cost

• To ensure data consistency, sharing of data, improved data integrity, and improved security

• To manage databases, enforce standards, and improve maintenance through data independence

• To organize, manage, store, and share information effectively

What is a file-based system?

• A collection of application programs that perform services for the end users

• A traditional system for organizing and managing data

• A system where each program maintains its own set of data

• A system that uses separate files to store data

What are the limitations of a file-based approach?

• Separation and isolation of data, duplication of data, and fixed queries

• Data redundancy, incompatible file formats, and proliferation of application programs

• Complexity, size, and additional hardware costs

• Data dependence, wasted space, and performance

What is a relational database?

• A database that organizes data into two-dimensional tables with columns and rows

• A database management system used to manage databases

• A database that handles large data sets of unstructured data

• A database provided by cloud computing services

What are the capabilities of a database management system?

• Data definition capabilities, querying and reporting, data warehouses, and data mining

• Control of data redundancy, data consistency, data dependence, and fixed queries

• Sharing of data, improved data integrity, improved security, and increased productivity

• Data warehouses, Hadoop, in-memory computing, and analytic platforms

What is Hadoop?

• A software ecosystem that allows for massively parallel computing

• A database that stores current and historical data

• A tool for obtaining useful information from internal and external systems

• A system for organizing and managing data

What is in-memory computing?

• A database that stores current and historical data

• A software ecosystem that allows for massively parallel computing

• A system that relies on computer's main memory for data storage

• A tool for obtaining useful information from internal and external systems