SWERS|GRADED A+|PASS ON FIRST ATTEMPT|BRAND NEW
A _______________ is software that helps business users interact with database systems -
ANSWER Database Application
Database Role:
What role is responsible for securing the database system against unauthorized users? This
role enforces procedures for user access and database system availability. - ANSWER Da-
tabase Administrator
Many database users should have limited access to specific tables, columns, or rows of a da-
tabase. What database "special requirement" allows database systems to allow individual
users access to specific data? - ANSWER Authorization
Database special requirements:
Database systems ensure data is consistent with structural and business______________. -
ANSWER Rules
Architecture Question:
This interprets Queries, creates a plan to modify the database or retrieve data, and returns
query results to the application. - ANSWER Query Processor
Architecture Question:
The query processor performs ___________ to ensure the most efficient instructions are ex-
ecuted on the data. - ANSWER Query Optimization
Architecture Question:
1
,This translates the query processor instructions into low level file system commands that
modify or retrieve data. - ANSWER Storage Manager
Database sizes range from megabytes to many terabytes, so the storage manager uses
__________ to quickly locate data. - ANSWER Indexes
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. -
ANSWER Transaction Manager
General Database Systems Question:
This is data about the database, such as column names, number of rows in a table, etc. - AN-
SWER Metadata
Is the MongoDB database engine Open-Source, Private, Free, or Commercial? - ANSWER
Open-Source
What is the MongoDB database Engine type? - ANSWER NoSQL
SQL statement:
This command inputs rows into a table. - ANSWER INSERT
SQL Statement:
This command retrieves data from a table - ANSWER SELECT
SQL Statement:
2
, This command modifies data in a table. - ANSWER UPDATE
SQL Statement:
This command deletes rows from a table. - ANSWER DELETE
SQL Statement:
This statement makes a new table by specifying the table and column names. - ANSWER
CREATE TABLE
During creation, each column is assigned a ____________ that indicates the format of col-
umn values. These can be numeric, textual, or complex. - ANSWER Data Type
Data Type Question:
This data type stores integer values. - ANSWER INT
Data Type Question:
This datatype stores fractional numeric values. - ANSWER DECIMAL
Data Type Question:
This datatype stores textual values. - ANSWER VARCHAR
Data Type Question:
This datatype stores year, month, and day. - ANSWER DATE
Name for the first phase of database design. - ANSWER Analysis
Name for the second phase of database design. - ANSWER Logical Design
3
A _______________ is software that helps business users interact with database systems -
ANSWER Database Application
Database Role:
What role is responsible for securing the database system against unauthorized users? This
role enforces procedures for user access and database system availability. - ANSWER Da-
tabase Administrator
Many database users should have limited access to specific tables, columns, or rows of a da-
tabase. What database "special requirement" allows database systems to allow individual
users access to specific data? - ANSWER Authorization
Database special requirements:
Database systems ensure data is consistent with structural and business______________. -
ANSWER Rules
Architecture Question:
This interprets Queries, creates a plan to modify the database or retrieve data, and returns
query results to the application. - ANSWER Query Processor
Architecture Question:
The query processor performs ___________ to ensure the most efficient instructions are ex-
ecuted on the data. - ANSWER Query Optimization
Architecture Question:
1
,This translates the query processor instructions into low level file system commands that
modify or retrieve data. - ANSWER Storage Manager
Database sizes range from megabytes to many terabytes, so the storage manager uses
__________ to quickly locate data. - ANSWER Indexes
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. -
ANSWER Transaction Manager
General Database Systems Question:
This is data about the database, such as column names, number of rows in a table, etc. - AN-
SWER Metadata
Is the MongoDB database engine Open-Source, Private, Free, or Commercial? - ANSWER
Open-Source
What is the MongoDB database Engine type? - ANSWER NoSQL
SQL statement:
This command inputs rows into a table. - ANSWER INSERT
SQL Statement:
This command retrieves data from a table - ANSWER SELECT
SQL Statement:
2
, This command modifies data in a table. - ANSWER UPDATE
SQL Statement:
This command deletes rows from a table. - ANSWER DELETE
SQL Statement:
This statement makes a new table by specifying the table and column names. - ANSWER
CREATE TABLE
During creation, each column is assigned a ____________ that indicates the format of col-
umn values. These can be numeric, textual, or complex. - ANSWER Data Type
Data Type Question:
This data type stores integer values. - ANSWER INT
Data Type Question:
This datatype stores fractional numeric values. - ANSWER DECIMAL
Data Type Question:
This datatype stores textual values. - ANSWER VARCHAR
Data Type Question:
This datatype stores year, month, and day. - ANSWER DATE
Name for the first phase of database design. - ANSWER Analysis
Name for the second phase of database design. - ANSWER Logical Design
3
