/
Database Concepts Overview
Save to my account
Sign up
Database Concepts Overview
Database Concepts Overview
Study
1
Question
What is data inconsistency?
Answer
Different versions of the same data appear in different places.
2
Question
What is data quality?
Answer
Promoting accuracy, validity, and timeliness of data.
3
Question
What are types of databases?
Answer
Classifies according to number of users, database locations, expected type and extent of use.
4
Question
What is a single-user database?
Answer
Supports one user at a time.
5
Question
What is a desktop database?
Answer
Runs on a PC.
6
Question
What is a multi-user database?
Answer
Supports multiple users at the same time.
7
Question
What is a workgroup database?
Answer
Supports a small number of users or a specific department.
8
Question
What is an enterprise database?
Answer
Supports many users across many departments.
9
Question
What is a centralized database?
Answer
Data is located at a single site.
10
Question
What is a distributed database?
Answer
Data is distributed across different sites.
11
Question
What is a cloud database?
Answer
Created and maintained using cloud data services.
12
Question
What is a general-purpose database?
Answer
Contains a wide variety of data used in multiple disciplines.
13
Question
What is a discipline-specific database?
Answer
Contains data focused on specific subject areas.
14
Question
What is an operational database?
Answer
Designed to support a company's day-to-day operations.
15
Question
What is an analytical database?
Answer
Stores historical data and business metrics.
16
Question
What is a data warehouse?
Answer
Stores data in a format optimized for decision support.
17
Question
What is Online analytical processing (OLAP)?
Answer
Enables retrieving, processing, and modeling data from the data warehouse.
18
Question
What is Business intelligence?
Answer
Captures and processes business data to generate info that support decision making.
19
Question
What is unstructured data?
Answer
Exists in their original state.
20
Question
What is structured data?
Answer
Results from formatting.
21
Question
What is structure in data?
Answer
Applied based on type of processing to be performed.
22
Question
What is semi-structured data?
Answer
Processed to some extent.
23
Question
What is Extensible Markup Language (XML)?
Answer
XML represents data elements in textual format.
24
Question
Why is a well-designed database important?
Answer
Facilitates data management and generates accurate and valuable information.
25
Question
What does a poorly designed database cause?
Answer
Causes difficult-to-trace errors.
26
Question
What is database design?
Answer
Focuses on the design of the database structure that will be used to store and manage end-user data.
27
Question
What are manual file systems?
Answer
Accomplished through a system of file folders and filing cabinets.
28
Question
Who is a Data processing (DP) specialist?
Answer
Created a computer-based system that would track data and produce required reports.
29
Question
What are modern end-user productivity tools?
Answer
Includes spreadsheet programs such as Microsoft Excel.
30
Question
What are the reasons for studying file systems?
Answer
Complexity of database design is easier to understand. Understanding file system problems helps to avoid problems with DBMS. Knowledge of file system is useful for converting file system to database system.