Introduction to DB Flashcards
1
Q
What are three ways data can vary?
A
Scope, format, and access
2
Q
Describe scope
A
The amount of data produced and collected
3
Q
Describe format
A
Data may be produced as numbers, text, image, audio, or video
4
Q
Describe access
A
Some data sources are private while others are public
5
Q
What is a database?
A
a collection of data in a structured format
6
Q
What is a DBMS?
A
database management systems are software for reading and writing into databases
7
Q
- What is a query?
A
- A request to change or retrieve something in the database
8
Q
- What is a query language?
A
- A special programming language for managing database operations
9
Q
- What is a database application?
A
- Special software that helps business users intact with databases.
10
Q
- What is an information management system?
A
- Software that manages corporate database for specific business function. Usually includes DBMS, UI, logs, and interfaces to other systems.
11
Q
- What is a database administrator?
A
- Responsible for securing the database systems against unauthorized users
12
Q
- What does a database designer do?
A
- Makes decisions about the format of data, response times, and support for rules that govern data
13
Q
- What does a database programmer do?
A
- Integrates database languages and other languages into a program that accesses databases.
14
Q
- Describe a database user
A
- Accesses the data in a database
15
Q
- What are 5 special requirements for large databases to manage?
A
- Performance, authorization, security, rules, and recovery
16
Q
- Describe performance
A
- Manages response time by structuring data and processing queries correctly
17
Q
- Describe authorization
A
- Authorize individual users to access specific data
18
Q
- Describe security
A
- Authorized users only access permissible data
19
Q
- Describe rules
A
- Ensure data is consistent with structural and business rules