NEW
Font size
Worksheetschptr 3
Total questions: 15
Worksheet time: 8mins
What is a database management system (DBMS)?
A collection of related data stored in a central location
A method for accessing files in a random order
A type of data hierarchy involving fields, records, and files
Software for creating, storing, maintaining, and accessing database files
What is the purpose of a data warehouse?
To create a logical view of information for users
To support decision-making applications and generate business intelligence
To store internal data collected from within an organization
To manage a high demand for information from many users
What is the main goal of database marketing?
To retrieve data in a sequential order based on a primary key
To improve database efficiency and eliminate redundant data
To use information within the database to implement marketing strategies
To create a hierarchical model of relationships between records
What is the purpose of the data dictionary in the relational model?
Eliminates redundant data and ensures related data is stored in a table
Stores definitions such as data types for fields and default values
Helps retrieve data from tables using operations like select and join
Uniquely identifies every record in a relational database
What is the significance of the Big Data Era?
Uses data and statistical methods to gain insight and provide information to decision makers
Involves voluminous data with dimensions like volume, variety, and velocity
Stores data on multiple servers throughout an organization for better reflection of the firm's structure
Acts as an interface to a database and retrieves data for users
What is the purpose of prescriptive analytics in business analytics?
Provides information to act on and improve decision making
Reviews past events and analyzes data to prepare for the future
Recommends a course of action for decision makers to follow
Discovers patterns and relationships in data using data-mining analysis
What is the main advantage of using data marts over data warehouses?
Improved response time for users with different needs
Faster access to data due to its smaller size
Effective targeting of users based on specific functions
Easier creation process due to its size and simplicity
What is the purpose of ETL in a data warehouse?
Analyzing large amounts of historical data quickly
Creating and maintaining the data dictionary in the relational model
Extraction, transformation, and loading of data from various sources
Storing definitions and data types for fields in the database
What is the main function of the database engine in a DBMS?
Responsible for data storage, manipulation, and retrieval
Used for tasks such as backup and recovery, security, and change management
Designs elements of an application using a database
Used to add, delete, modify, and retrieve records from a database
What is the purpose of a hierarchical model in logical database design?
Relationships between records form a tree-like structure
Used to improve database efficiency and eliminate redundant data
Records can be accessed in any order regardless of physical locations
Determines how data is created, represented, and organized
What is the main advantage of using a distributed database management system (DDBMS)?
Supports decision-making applications and generates business intelligence
Acts as an interface to a database and retrieves data for users
Stores data on multiple servers throughout an organization
Local data storage reduces response time and minimizes effects of computer failure
What is the purpose of object-oriented databases?
Contain data and relationships in a single object with attributes and methods
Collection of data from a variety of sources to support decision-making
Acts as an interface to a database and retrieves data for users
Stores definitions such as data types for fields and default values
What is the main function of the data administration component in a DBMS?
Used for tasks such as backup and recovery, security, and change management
Designs elements of an application using a database
Responsible for data storage, manipulation, and retrieval
Creates and maintains the data dictionary and defines database file structure
What are recent trends in database design and use?
Include data-driven websites, natural language processing, and distributed databases
Used to improve database efficiency and eliminate redundant data
Acts as an interface to a database and retrieves data for users
Determines how data is created, represented, and organized
What is the purpose of descriptive analytics in business analytics?
Discovers patterns and relationships in data using data-mining analysis
Recommends a course of action for decision makers to follow
Proactively prepares decision makers for future events
Reviews past events, analyzes data, and provides a report on what happened
