Font size
WorksheetsIntro to DBMS
Total questions: 15
Worksheet time: 3mins
Which of the following are disadvantages of a traditional file-based system?
Data redundancy
Data integrity
Concurrency
Additional hardware cost
Data inconsistency
Application programs that perform services for the end users where each program defines and manages its own data
File systems
Database systems
File-based systems
Application software
This is incredibly important for any business but the data will serve no purpose unless there is a way to organize it into usable information.
Data mining
Database
Data collection
Data analysis
These can be facts, figures, statistics, and numbers
Information
Statistics
Census
Data
Knowledge
Highest value can be achieved from what level in the knowledge pyramid?
Data
Wisdom
Knowledge
Information
Action
Which of the following are roles of a database in a business?
Analyze data for reports
Enables transforming data
Collect data in a central place
Produce data required for business
A database is a collection of (a) data.
Data in a vacuum (without context) is ____
worth it
useful
meaningless
processed
Databases should represent some aspects of the real world or a collection of data elements representing real-world information
False
True
Partially False
A data item is stored in a column, which is also called
a table
a record
a field
an element
Data in a database should be
Connected
Related
Coherent
has inherent meaning
This is a collection of programs that enables users to create, maintain, and control access to databases.
Database System
Database
Application program
Database Management System
It is a function of a DBMS where data is queried to be retrieved
Share
Construct
Manipulate
Define
The following are advantages of DBMS
Data consistency
Reduced data redundancy
Concurrency
Data integrity
Complexity
This includes the cost of downtime and migration when transitioning to a DBMS system.
Cost of DBMS
Hardware costs
Cost of conversion
Performance
