D426 Study Guide (Red Text ONLY)
Study online at https://quizlet.com/_ftm35k
1. Database Appli- A _______________ is software that helps business users interact with database
cation systems
2. Database Admin- Database Role:
istrator What role is responsible for securing the database system against unauthorized
users. This role enforces procedures for user access and database system avail-
ability.
3. Authorization Many database users should have limited access to specific tables, columns,
or rows of a database. What database "special requirement" allows database
systems to allow individual users access to specific data?
4. Rules Database special requirements:
Database systems ensure data is consistent with structural and busi-
ness______________.
5. Query Processor Architecture Question:
This interprets Queries, creates a plan to modify the database or retrieve data, and
returns query results to the application.
6. Query Optimiza- Architecture Question:
tion The query processor performs ___________ to ensure the most efficient instruc-
tions are executed on the data.
7. Storage Manager Architecture Question:
This translates the query processor instructions into low level file system com-
mands that modify or retrieve data.
8. Indexes Database sizes range from megabytes to many terabytes, so the storage manager
uses __________ to quickly locate data.
9. Transaction Man- Architecture Question:
ager The ______________ ensures the following:
, D426 Study Guide (Red Text ONLY)
Study online at https://quizlet.com/_ftm35k
- Ensures transactions are properly executed.
- Prevents conflicts between concurrent transactions.
- Restores the database to a consistent state in the event of transaction or system
failure.
10. Metadata General Database Systems Question:
This is data about the database, such as column names, number of rows in a table,
etc.
11. Open-Source Is the MongoDB database engine Open-Source, Private, Free, or Commercial?
12. NoSQL What is the MongoDB database Engine type?
13. INSERT SQL statement:
This command inputs rows into a table.
14. SELECT SQL Statement:
This command retrieves data from a table
15. UPDATE SQL Statement:
This command modifies data in a table.
16. DELETE SQL Statement:
This command deletes rows from a table.
17. CREATE TABLE SQL Statement:
This statement makes a new table by specifying the table and column names.
18. Data Type During creation, each column is assigned a ____________ that indicates the
format of column values. These can be numeric, textual, or complex.
19. INT Data Type Question:
This data type stores integer values.
, D426 Study Guide (Red Text ONLY)
Study online at https://quizlet.com/_ftm35k
20. DECIMAL Data Type Question:
This datatype stores fractional numeric values.
21. VARCHAR Data Type Question:
This datatype stores textual values.
22. DATE Data Type Question:
This datatype stores year, month, and day.
23. Analysis Name for the first phase of database design.
24. Logical Design Name for the second phase of database design.
25. Physical Design Name for the third phase of database design.
26. Analysis Database Design phases:
This phase specifies database requirements without regard to a specific database
system. Requirements are represented as entities, relationships, and attributes.
27. Relationship Database Design Related Question:
A(n) ____________ is a link between entities.
28. Attribute Database Design Related Question:
A(n) _______________ is a descriptive property of an entity.
29. Analysis Database Design Related Question:
The following are other names for what phase: Conceptual Design, Entity-Rela-
tionship Modeling, and Requirements Definition
30. Logical Design Database Design Related Question:
This phase implements database requirements in a specific database system.
31. Logical
Study online at https://quizlet.com/_ftm35k
1. Database Appli- A _______________ is software that helps business users interact with database
cation systems
2. Database Admin- Database Role:
istrator What role is responsible for securing the database system against unauthorized
users. This role enforces procedures for user access and database system avail-
ability.
3. Authorization Many database users should have limited access to specific tables, columns,
or rows of a database. What database "special requirement" allows database
systems to allow individual users access to specific data?
4. Rules Database special requirements:
Database systems ensure data is consistent with structural and busi-
ness______________.
5. Query Processor Architecture Question:
This interprets Queries, creates a plan to modify the database or retrieve data, and
returns query results to the application.
6. Query Optimiza- Architecture Question:
tion The query processor performs ___________ to ensure the most efficient instruc-
tions are executed on the data.
7. Storage Manager Architecture Question:
This translates the query processor instructions into low level file system com-
mands that modify or retrieve data.
8. Indexes Database sizes range from megabytes to many terabytes, so the storage manager
uses __________ to quickly locate data.
9. Transaction Man- Architecture Question:
ager The ______________ ensures the following:
, D426 Study Guide (Red Text ONLY)
Study online at https://quizlet.com/_ftm35k
- Ensures transactions are properly executed.
- Prevents conflicts between concurrent transactions.
- Restores the database to a consistent state in the event of transaction or system
failure.
10. Metadata General Database Systems Question:
This is data about the database, such as column names, number of rows in a table,
etc.
11. Open-Source Is the MongoDB database engine Open-Source, Private, Free, or Commercial?
12. NoSQL What is the MongoDB database Engine type?
13. INSERT SQL statement:
This command inputs rows into a table.
14. SELECT SQL Statement:
This command retrieves data from a table
15. UPDATE SQL Statement:
This command modifies data in a table.
16. DELETE SQL Statement:
This command deletes rows from a table.
17. CREATE TABLE SQL Statement:
This statement makes a new table by specifying the table and column names.
18. Data Type During creation, each column is assigned a ____________ that indicates the
format of column values. These can be numeric, textual, or complex.
19. INT Data Type Question:
This data type stores integer values.
, D426 Study Guide (Red Text ONLY)
Study online at https://quizlet.com/_ftm35k
20. DECIMAL Data Type Question:
This datatype stores fractional numeric values.
21. VARCHAR Data Type Question:
This datatype stores textual values.
22. DATE Data Type Question:
This datatype stores year, month, and day.
23. Analysis Name for the first phase of database design.
24. Logical Design Name for the second phase of database design.
25. Physical Design Name for the third phase of database design.
26. Analysis Database Design phases:
This phase specifies database requirements without regard to a specific database
system. Requirements are represented as entities, relationships, and attributes.
27. Relationship Database Design Related Question:
A(n) ____________ is a link between entities.
28. Attribute Database Design Related Question:
A(n) _______________ is a descriptive property of an entity.
29. Analysis Database Design Related Question:
The following are other names for what phase: Conceptual Design, Entity-Rela-
tionship Modeling, and Requirements Definition
30. Logical Design Database Design Related Question:
This phase implements database requirements in a specific database system.
31. Logical
