D426 Study Guide Questions with complete solution 2025
1. Database A is software that helps business users interact with
Appli- cation database systems
2. Database Database Role:
Admin-
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 Architecture Question:
Processor
This interprets Queries, creates a plan to modify the database or retrieve
data, and
returns query results to the application.
6. Query Architecture Question:
Optimiza-
tion The query processor performs to ensure the most eflcient
instruc-
tions are executed on the data.
7. Storage Architecture Question:
Manager
1/
31
,D426 Study Guide Questions with complete solution 2025
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:
2/
31
,D426 Study Guide Questions with complete solution 2025
-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.
3/
31
,D426 Study Guide Questions with complete solution 2025
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
4/
31
1. Database A is software that helps business users interact with
Appli- cation database systems
2. Database Database Role:
Admin-
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 Architecture Question:
Processor
This interprets Queries, creates a plan to modify the database or retrieve
data, and
returns query results to the application.
6. Query Architecture Question:
Optimiza-
tion The query processor performs to ensure the most eflcient
instruc-
tions are executed on the data.
7. Storage Architecture Question:
Manager
1/
31
,D426 Study Guide Questions with complete solution 2025
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:
2/
31
,D426 Study Guide Questions with complete solution 2025
-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.
3/
31
,D426 Study Guide Questions with complete solution 2025
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
4/
31
