D426 Study Guide (Red Text ONLY)
1. A _______________ is software that helps business users interact with database
systems: Database Application
2. Database Role:
What role is responsible for securing the database system against unau-
thorized users? This role enforces procedures for user access and database
system availability.: Database Administrator
3. 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?: Authorization
4. Database special requirements:
Database systems ensure data is consistent with structural and busi-
ness______________.: Rules
5. Architecture Question:
This interprets Queries, creates a plan to modify the database or retrieve data,
and returns query results to the application.: Query Processor
6. Architecture Question:
The query processor performs ___________ to ensure the most efficient instruc-
tions are executed on the data.: Query Optimization
7. Architecture Question:
This translates the query processor instructions into low level file system
commands that modify or retrieve data.: Storage Manager
8. Database sizes range from megabytes to many terabytes, so the storage
manager uses __________ to quickly locate data.: Indexes
9. Architecture Question:
The ______________ ensures the following:
- 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.: Transaction Manager
10. General Database Systems Question:
This is data about the database, such as column names, number of rows in a
table, etc.: Metadata
, D426 Study Guide (Red Text ONLY)
q5
11. Is the MongoDB database engine Open-Source, Private, Free, or Commer-
cial?: Open-Source
12. What is the MongoDB database Engine type?: NoSQL
13. SQL statement:
This command inputs rows into a table.: INSERT
14. SQL Statement:
This command retrieves data from a table: SELECT
15. SQL Statement:
This command modifies data in a table.: UPDATE
16. SQL Statement:
This command deletes rows from a table.: DELETE
17. SQL Statement:
This statement makes a new table by specifying the table and column names.-
: CREATE TABLE
18. During creation, each column is assigned a ____________ that indicates the
format of column values. These can be numeric, textual, or complex.: Data Type
19. Data Type Question:
This data type stores integer values.: INT
20. Data Type Question:
This datatype stores fractional numeric values.: DECIMAL
21. Data Type Question:
This datatype stores textual values.: VARCHAR
22. Data Type Question:
This datatype stores year, month, and day.: DATE
23. Name for the first phase of database design.: Analysis
24. Name for the second phase of database design.: Logical Design
25. Name for the third phase of database design.: Physical Design
26. Database Design phases:
This phase specifies database requirements without regard to a specific data-
base system. Requirements are represented as entities, relationships, and
attributes.: Analysis
, D426 Study Guide (Red Text ONLY)
q5
27. Database Design Related Question:
A(n) ____________ is a link between entities.: Relationship
28. Database Design Related Question:
A(n) _______________ is a descriptive property of an entity.: Attribute
29. Database Design Related Question:
The following are other names for what phase: Conceptual Design, Entity-Re-
lationship Modeling, and Requirements Definition: Analysis
30. Database Design Related Question:
This phase implements database requirements in a specific database system.-
: Logical Design
31. Database Design Related Question:
For relational database systems, this type of design converts entities, relation-
ships, and attributes into tables, keys, and columns.: Logical
32. Database Design Related Question:
This phase adds indexes and specifies how tables are organized on storage
media.: Physical Design
33. Database Design Related Question:
This kind of design affects query processing speed but NEVER affects the
query result: Physical
34. Database Design Related Question:
The principle that physical design never affects query results is called
_______________.: Data Independence
35. Database Design Related Question:
To simplify the use of SQL with a general-purpose language, database pro-
grams typically use a(n)____________.: Application Programming Interface (API)
36. MySQL Related Question:
This is a text-interface included in the MySQL Server download.: MySQL Com-
mand-Line Client
37. MySQL Related Question:
MySQL returns a(n) ________________ and description when an SQL statement
is syntactically incorrect or the database cannot execute the statement.: Error
Code
1. A _______________ is software that helps business users interact with database
systems: Database Application
2. Database Role:
What role is responsible for securing the database system against unau-
thorized users? This role enforces procedures for user access and database
system availability.: Database Administrator
3. 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?: Authorization
4. Database special requirements:
Database systems ensure data is consistent with structural and busi-
ness______________.: Rules
5. Architecture Question:
This interprets Queries, creates a plan to modify the database or retrieve data,
and returns query results to the application.: Query Processor
6. Architecture Question:
The query processor performs ___________ to ensure the most efficient instruc-
tions are executed on the data.: Query Optimization
7. Architecture Question:
This translates the query processor instructions into low level file system
commands that modify or retrieve data.: Storage Manager
8. Database sizes range from megabytes to many terabytes, so the storage
manager uses __________ to quickly locate data.: Indexes
9. Architecture Question:
The ______________ ensures the following:
- 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.: Transaction Manager
10. General Database Systems Question:
This is data about the database, such as column names, number of rows in a
table, etc.: Metadata
, D426 Study Guide (Red Text ONLY)
q5
11. Is the MongoDB database engine Open-Source, Private, Free, or Commer-
cial?: Open-Source
12. What is the MongoDB database Engine type?: NoSQL
13. SQL statement:
This command inputs rows into a table.: INSERT
14. SQL Statement:
This command retrieves data from a table: SELECT
15. SQL Statement:
This command modifies data in a table.: UPDATE
16. SQL Statement:
This command deletes rows from a table.: DELETE
17. SQL Statement:
This statement makes a new table by specifying the table and column names.-
: CREATE TABLE
18. During creation, each column is assigned a ____________ that indicates the
format of column values. These can be numeric, textual, or complex.: Data Type
19. Data Type Question:
This data type stores integer values.: INT
20. Data Type Question:
This datatype stores fractional numeric values.: DECIMAL
21. Data Type Question:
This datatype stores textual values.: VARCHAR
22. Data Type Question:
This datatype stores year, month, and day.: DATE
23. Name for the first phase of database design.: Analysis
24. Name for the second phase of database design.: Logical Design
25. Name for the third phase of database design.: Physical Design
26. Database Design phases:
This phase specifies database requirements without regard to a specific data-
base system. Requirements are represented as entities, relationships, and
attributes.: Analysis
, D426 Study Guide (Red Text ONLY)
q5
27. Database Design Related Question:
A(n) ____________ is a link between entities.: Relationship
28. Database Design Related Question:
A(n) _______________ is a descriptive property of an entity.: Attribute
29. Database Design Related Question:
The following are other names for what phase: Conceptual Design, Entity-Re-
lationship Modeling, and Requirements Definition: Analysis
30. Database Design Related Question:
This phase implements database requirements in a specific database system.-
: Logical Design
31. Database Design Related Question:
For relational database systems, this type of design converts entities, relation-
ships, and attributes into tables, keys, and columns.: Logical
32. Database Design Related Question:
This phase adds indexes and specifies how tables are organized on storage
media.: Physical Design
33. Database Design Related Question:
This kind of design affects query processing speed but NEVER affects the
query result: Physical
34. Database Design Related Question:
The principle that physical design never affects query results is called
_______________.: Data Independence
35. Database Design Related Question:
To simplify the use of SQL with a general-purpose language, database pro-
grams typically use a(n)____________.: Application Programming Interface (API)
36. MySQL Related Question:
This is a text-interface included in the MySQL Server download.: MySQL Com-
mand-Line Client
37. MySQL Related Question:
MySQL returns a(n) ________________ and description when an SQL statement
is syntactically incorrect or the database cannot execute the statement.: Error
Code
