Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
21 Cards in this Set
- Front
- Back
A group of programs that manipulate the database and provide an interface between the database and the user of the database and other application programs is called a(n)
a. GUI b. operating system c. DBMS d. productivity software |
DBMS
|
|
A(n) _______________ is a skilled and trained IS professional who directs all activities related to an organization’s database.
|
database administrator
|
|
3. Data redundancy is a desirable quality in a database. True or False?
|
False
|
|
4. A(n) _______________ is a field or set of fields that uniquely identifies a database record.
a. attribute b. data item c. key d. primary key |
D primary key
|
|
5. A(n) _______________ uses basic graphical symbols to show the organization of and relationships between data.
|
Entity relationship diagram
|
|
6. What database model places data in two-dimensional tables?
a. relational b. network c. normalized d. hierarchical |
A
|
|
7. _______________ involves combining two or more database tables.
|
Joining
|
|
8. After data has been placed into a relational database, users can make inquiries and analyze data. Basic data manipulations include selecting, projecting, and optimizing. True or False?
|
False
|
|
9. Because the DBMS is responsible for providing access to a database, one of the first steps in installing and using a database involves telling the DBMS the logical and physical structure of the data and relationships among the data in the database. This description of an entire database is called a(n) _______________.
|
Schema
|
|
10. The commands used to access and report information from the database are part of the ______________.
a. data definition language b. data manipulation language c. data normalization language d. schema |
B
|
|
11. Access is a popular DBMS for _______________.
a. personal computers b. graphics workstations c. mainframe computers d. supercomputers |
A
|
|
12. A new trend in database management, known as Database as a Service, places the responsibility of storing and managing a database on a service provider. True or False?
|
True
|
|
13. A(n) _______________ holds business information from many sources in the enterprise, covering all aspects of the company’s processes, products, and customers.
|
Data warehouse
|
|
14. An information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse is called _______________.
a. a data mart b. data mining c. predictive analysis d. business intelligence |
B
|
|
15. _______________ allows users to predict the future based on database information from the past and present.
|
Predictive analysis
|
|
Which position is responsible to plan, design, create, operate, secure, monitor and maintain organizational databases?
|
Database administrator
|
|
A data dictionary provides a detailed description of all the data used in the database. T or F
|
True
|
|
SQL is defined as
|
Structured Query Language
|
|
What information analysis tool involves the automated discovery of patterns and relationships in a data warehouse?
|
Data Mining
|
|
_________ is a collection of instructions and commands used to define and describe data and relationships in a specific database
|
Data definition language
|
|
What is the difference between flat file, single user, and multiple user database types?
|
Flat file => a simple database program whose records have no relationship to one another
- e.g. MS OneNote Single User => a database installed on a personal computer is typically meant for a single user - e.g. MS Access Multiple Users => for sharing information throughout the organization over a network |