Database Administration
Test Bank
Course Introduction
Database Administration explores the principles and practices involved in managing and maintaining database systems within an organization. Students learn about database installation, configuration, monitoring, backup and recovery, user management, and security. The course covers key administrative tasks for relational database management systems (RDBMS) such as performance tuning, troubleshooting, and implementing high availability solutions. Emphasis is placed on both theoretical concepts and hands-on experience using popular database platforms, preparing students to effectively oversee and safeguard critical data assets in real-world environments.
Recommended Textbook
Modern Database Management 12th Edition by Jeffrey A. Hoffer
Available Study Resources on Quizplus
14 Chapters
1469 Verified Questions
1469 Flashcards
Source URL: https://quizplus.com/study-set/1058
Page 2
Chapter 1: The Database Environment and Development Process
Available Study Resources on Quizplus for this Chatper
116 Verified Questions
116 Flashcards
Source URL: https://quizplus.com/quiz/20934
Sample Questions
Q1) A workgroup database is stored on a central device called a: A) client.
B) server.
C) remote PC.
D) network.
Answer: B
Q2) A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n):
A) relationship.
B) object.
C) attribute.
D) entity.
Answer: D
Q3) Discuss some of the costs associated with the database approach.
Answer: The database approach does not come without additional costs. These are specifically tied to the following:
1. New specialized personnel
2. Cost of installation and management
3. Conversion costs
4. Need for explicit backup and recovery
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Modeling Data in the Organization
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20935
Sample Questions
Q1) A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship.
A) optional
B) unidirectional
C) mandatory link
D) mandatory one
Answer: D
Q2) In an E-R diagram, there are/is ________ business rule(s) for every relationship.
A) two
B) three
C) one
D) zero
Answer: A
Q3) An attribute whose values can be calculated from related attribute values is called a derived attribute.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above.
4
Chapter 3: The Enhanced E-R Model
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20936
Sample Questions
Q1) Mapping existing data to new data in a packaged data model is useful for developing migration plans.
A)True
B)False
Answer: True
Q2) One of the major challenges in data modeling is to recognize and clearly represent entities that are almost the same.
A)True
B)False
Answer: True
Q3) It is easier to share information across organizations if companies in the same industry use the same universal data model as the basis for their organizational databases.
A)True
B)False
Answer: True
Q4) Specialization is the reverse of generalization.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Logical Database Design and the Relational
Model
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20937
Sample Questions
Q1) A functional dependency between two or more nonkey attributes is called a:
A) partial functional dependency.
B) partial nonkey dependency.
C) transitive dependency.
D) partial transitive dependency.
Q2) A primary key is an attribute that uniquely identifies each row in a relation.
A)True
B)False
Q3) Data integrity consists of powerful operations to manipulate data stored in relations.
A)True
B)False
Q4) The columns of a relation can be interchanged without changing the meaning or use of the relation.
A)True
B)False
Q5) A cascading delete removes all records in other tables associated with the record to be deleted.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Physical Database Design and Performance
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20938
Sample Questions
Q1) A detailed coding scheme recognized by system software for representing organizational data is called a(n):
A) DBMS code.
B) data type.
C) SQL.
D) DB layout.
Q2) In which data model would a code table appear?
A) Conceptual
B) Logical
C) Physical
D) Data layout
Q3) Denormalization is the process of transforming relations with variable-length fields into those with fixed-length fields.
A)True
B)False
Q4) The logical database design always forms the best foundation for grouping attributes in the physical design.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Introduction to SQL
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20939
Sample Questions
Q1) Relational databases are heavily based on the mathematical concept of:
A) Set Theory.
B) Bet Theory.
C) Get Theory.
D) Met Theory.
Q2) What result will the following SQL statement produce? Select Avg(standard_price) as average from Product_V;
A) The average of all products in Product_V
B) The average Standard_Price of all products in Product_V
C) The average price of all products
D) The mode of all prices
Q3) ________ is a set of commands used to control a database, including security.
A) DML
B) DDL
C) DCL
D) DPL
Q4) The FROM clause is the first statement processed in an SQL command. A)True
B)False
Q5) Explain the three classes of SQL commands and when they would be used.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Advanced SQL
Available Study Resources on Quizplus for this Chatper
107 Verified Questions
107 Flashcards
Source URL: https://quizplus.com/quiz/20940
Sample Questions
Q1) An SQL query that implements an outer join will return rows that do not have matching values in common columns.
A)True
B)False
Q2) The following code would include:
SELECT Customer_T.CustomerID,CustomerName, OrderID
FROM Customer_T RIGHT OUTER JOIN Order_T ON Customer_T.CustomerID = Order_T.CustomerID;
A) all rows of the Order_T Table regardless of matches with the Customer_T Table.
B) all rows of the Customer_T Table regardless of matches with the Order_T Table.
C) only rows that match both Customer_T and Order_T Tables.
D) only rows that don't match both Customer_T and Order_T Tables.
Q3) The most commonly used form of join operation is the:
A) outer join.
B) union join.
C) equi-join.
D) natural join.
Q4) What is a self-join and how is it used?
To view all questions and flashcards with answers, click on the resource link above.
Page 9
Chapter 8: Database Application Development
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20941
Sample Questions
Q1) Service-oriented architectures (SOA) are:
A) a set of tiers designed to serve each other.
B) a collection of services that communicate with each other in some manner.
C) architecture designed for the military.
D) architecture designed for Schools of Accountancy (SOA).
Q2) Which of the following is a component of processing logic?
A) Input
B) Output
C) Retrieval
D) Business rules
Q3) Open Database Connectivity is an application programming interface that provides a common language for application programs to access and process SQL databases independent of the particular RDBMS that is accessed.
A)True
B)False
Q4) According to the XML Query Working Group, XQuery is a standardized language for Combining documents, databases, Web pages and almost anything else.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Data Warehousing
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20942
Sample Questions
Q1) All of the following are ways to handle changing dimensions EXCEPT:
A) overwrite the current value with the new value.
B) for each dimension attribute that changes, create a current value field and as many old value fields as we wish.
C) create a new dimension table row each time the dimension object changes.
D) create a snowflake schema.
Q2) What is the surrogate key rule for the star schema, and what are the main reasons for this rule?
Q3) The characteristic that indicates that a data warehouse is organized around key high-level entities of the enterprise is:
A) subject-oriented.
B) integrated.
C) time-variant.
D) nonvolatile.
Q4) A data mart is a(n):
A) enterprisewide data warehouse.
B) smaller system built upon file processing technology.
C) data warehouse that is limited in scope.
D) generic on-line shopping site.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Data Quality and Integration
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20943
Sample Questions
Q1) Quality data are not essential for well-run organizations.
A)True
B)False
Q2) A data quality audit helps an organization understand the extent and nature of data quality problems.
A)True
B)False
Q3) Dirty data saves work for information systems projects.
A)True
B)False
Q4) In the ________ approach, one consolidated record is maintained, and all applications draw on that one actual "golden" record.
A) persistent
B) identity registry
C) federated
D) integration hub
Q5) What are the key steps in a data quality program?
Q6) What are some of the reasons for deteriorated data quality?
Q7) What is the difference between an incremental extract and a static extract?
Q8) Discuss Master Data Management.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Big Data and Analytics
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20944
Sample Questions
Q1) HP HAVEn integrates HP technologies with open source big data technologies.
A)True
B)False
Q2) The 'schema on read' approach often incorporates JSON or XML.
A)True
B)False
Q3) All of the following are applications for big data and analytics EXCEPT:
A) business.
B) science and technology.
C) security and public health.
D) personal finances.
Q4) Value (related to the five 'v's of big data) addresses the pursuit of a meaningful goal.
A)True
B)False
Q5) Predictive analytics answers the question: "How can we make it happen?"
A)True
B)False
Q6) Describe the Five Vs of Big Data.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Data and Database Administration
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/20945
Sample Questions
Q1) The repository information model defines types, which should be easy to extend.
A)True
B)False
Q2) A repository of information about a database that documents data elements of a database is called a:
A) schema.
B) subschema.
C) view.
D) data dictionary.
Q3) What are the most important security features for data management software?
Q4) Authorization rules are controls incorporated in the data management system that restrict access to data and also restrict the actions that people may take when they access the data.
A)True
B)False
Q5) In order to perform a restore/rerun, the database must be mirrored.
A)True
B)False
Q6) What are some of the core roles of a database administrator?
Q7) What are some of the core roles of the traditional data administrator?
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Distributed Databases
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/20946
Sample Questions
Q1) A(n) ________ is a database stored on multiple computers in multiple locations that are NOT connected by a data communications link.
A) distributed database
B) decentralized database
C) unlinked database
D) data repository
Q2) A local transaction is one that requires reference only to data that are stored at the site where the transaction originates.
A)True
B)False
Q3) A synchronized replication strategy has a(n) ________ reliability.
A) excellent
B) good
C) fair
D) medium
Q4) A replicated database with snapshots is very manageable.
A)True
B)False
Q5) What is data replication?
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Object-Oriented Data Modeling
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20947
Sample Questions
Q1) A class that has direct instances is called a(n) ________ class.
A) abstract
B) multiplicity
C) large
D) concrete
Q2) When specifying a business rule between graphical symbols, a dashed arrow is drawn from one element to the other.
A)True
B)False
Q3) In addition to specifying the multiplicity of an association role, you can also specify other properties, for example, if the objects playing the role are ordered or not.
A)True
B)False
Q4) A query operation does not alter the state of an object.
A)True
B)False
Q5) A state represents how an object acts.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 16