Module 4 Database management tools (100%
Guaranteed)
defines and manages the data types and structures that dictate how the database is organized.
correct answers Data dictionary
the creation, update, and deletion of the data within the database. correct answers Data
management
using queries, data is retrieved and combined. correct answers Data retrieval
recovering corrupted information, and managing users and group access to the data. correct
answers Data administration, including maintaining data integrity
Which of the following is a major function of a database management system? correct answers
Data administration
There are many database tools and technologies that help with business performance. What
capabilities does a DBMS enable in a database? correct answers Input, modification, and
retrieval of data
When a bank keeps client financial information in several different files, the bank staff has to
update customer information in several locations. This is an example of what? correct answers
data redundancy
The DBMS for your bank contains many tables, and two of these tables are Loan and Customer.
If a bank teller accidentally deletes your mortgage loan from the DBMS, your file has missing
information and is in violation of what? correct answers data integrity
A DBMS for your bank contains many tables. If the address in your bank account is different
from the address on your monthly banking statement because customer information is stored in
several places, what is this an example of? correct answers data inconsistency
Recommendations and solutions for optimizing or maintaining banking data over the long term
would be a result of what? correct answers data quality audit
a Java based open (i.e., non-proprietary) programming framework that supports big data
collection, processing, and analytics of a distributed computing environment. correct answers
Hadoop
an extracted portion of a data warehouse that deals with summarized or highly specialized
subdivision of the whole. correct answers data marts
Guaranteed)
defines and manages the data types and structures that dictate how the database is organized.
correct answers Data dictionary
the creation, update, and deletion of the data within the database. correct answers Data
management
using queries, data is retrieved and combined. correct answers Data retrieval
recovering corrupted information, and managing users and group access to the data. correct
answers Data administration, including maintaining data integrity
Which of the following is a major function of a database management system? correct answers
Data administration
There are many database tools and technologies that help with business performance. What
capabilities does a DBMS enable in a database? correct answers Input, modification, and
retrieval of data
When a bank keeps client financial information in several different files, the bank staff has to
update customer information in several locations. This is an example of what? correct answers
data redundancy
The DBMS for your bank contains many tables, and two of these tables are Loan and Customer.
If a bank teller accidentally deletes your mortgage loan from the DBMS, your file has missing
information and is in violation of what? correct answers data integrity
A DBMS for your bank contains many tables. If the address in your bank account is different
from the address on your monthly banking statement because customer information is stored in
several places, what is this an example of? correct answers data inconsistency
Recommendations and solutions for optimizing or maintaining banking data over the long term
would be a result of what? correct answers data quality audit
a Java based open (i.e., non-proprietary) programming framework that supports big data
collection, processing, and analytics of a distributed computing environment. correct answers
Hadoop
an extracted portion of a data warehouse that deals with summarized or highly specialized
subdivision of the whole. correct answers data marts
