Check out Monetary establishment For MODERN DATABASE MANAGEMENT 12TH EDITION BY HOFFER

ISBN: 9780133544619

Desk of Contents

I. The Context of Database Administration

1. The Database Environment and Progress Course of

II. Database Analysis

2. Modeling Info throughout the Group

3. The Enhanced E-R Model

III. Database Design

4. Logical Database Design and the Relational Model

5. Bodily Database Design and Effectivity

IV. Implementation

6. Introduction to SQL

7. Superior SQL

8. Database Software program Progress

9. Info Warehousing

V. Superior Database Issues

10. Info Top quality and Integration

11. Large Info and Analytics

12. Info and Database Administration

Glossary of Acronyms

Glossary of Phrases

Index

On-line Chapters

13. Distributed Databases

14. Object-Oriented Info Modeling

Appendices

Appendix A. Info Modeling Devices and Notation

Appendix B. Superior Common Varieties

Appendix C. Info Buildings

Description

Chapter 11   Info And Database Administration

1) Which Of The Following Is True Of Poor Info And/Or Database Administration?

1. A) Info Timing Points
2. B) A variety of Entity Definitions
3. C) Unknown Meanings Of Saved Info
4. D) All Of The Above

Reply:  D

Diff: 2    Net web page Ref: 464

Matter:  Introduction

AACSB:  Use Of Data Experience

2) ________ Is A Technical Function Accountable For Database Design, Security, And Disaster Restoration.

1. A) Info Administration
2. B) Database Administration
3. C) Tech Help
4. D) Operations

Reply:  B

Diff: 1    Net web page Ref: 466

Matter:  Introduction

AACSB:  Use Of Data Experience

3) An Data Repository Offers Data To:

1. A) Prospects.
2. B) Automated CASE Devices.
3. C) Database Administration Packages.
4. D) All Of The Above.

Reply:  D

Diff: 2    Net web page Ref: 466

Matter:  The Roles Of Info And Database Administrators

AACSB:  Use Of Data Experience

Subtopic:  Typical Database Administration

4) Which Of The Following Options Do Value/Revenue Fashions?

1. A) Database Planning
2. B) Database Analysis
3. C) Database Design
4. D) Operations

Reply:  A

Diff: 2    Net web page Ref: 468

Matter:  The Roles Of Info And Database Administrators

AACSB:  Use Of Data Experience

Subtopic:  Evolving Approaches To Info Administration

5) Which Of The Following Options Develop Integrity Controls?

1. A) Database Planning
2. B) Database Analysis
3. C) Database Implementation
4. D) Database Design

Reply:  D

Diff: 2    Net web page Ref: 468

Matter:  The Roles Of Info And Database Administrators

AACSB:  Use Of Data Experience

Subtopic:  Evolving Approaches To Info Administration

6) Which Of The Following Options Model Enterprise Tips?

1. A) Database Planning
2. B) Database Analysis
3. C) Database Design
4. D) Operations

Reply:  B

Diff: 2    Net web page Ref: 468

Matter:  The Roles Of Info And Database Administrators

AACSB:  Use Of Data Experience

Subtopic:  Evolving Approaches To Info Administration

7) A Info Warehouse Administrator Has Which Of The Following Duties?

1. A) Assemble And Administer An Environment Supportive Of Decision-Help Functions
2. B) Assemble A Safe Construction For The Info Warehouse
3. C) Develop Service Stage Agreements With Suppliers And Consumers Of Info For The Info Warehouse
4. D) All Of The Above

Reply:  D

Diff: 1    Net web page Ref: 470

Matter:  The Roles Of Info And Database Administrators

AACSB:  Use Of Data Experience

Subtopic:  Info Warehouse Administration

8) An Group Must Have One Info Warehouse Administrator For Every:

1. A) 100 Prospects.
2. B) 100 Gigabytes Of Info In The Enterprise Info Warehouse.
3. C) Division.
4. D) Processor.

Reply:  B

Diff: 2    Net web page Ref: 470

Matter:  The Roles Of Info And Database Administrators

AACSB:  Analytic Experience, Use Of Data Experience

Subtopic:  Info Warehouse Administration

9) An Open-Provide DBMS Is:

1. A) A Free Provide-Code RBMS That Provides The Efficiency Of An SQL-Compliant DBMS.
2. B) A Beta Launch Of A Industrial RDBMS.
3. C) An Object-Oriented Database Administration System.
4. D) Provide Code For A Industrial RDBMS.

Reply:  A

Diff: 1    Net web page Ref: 471

Matter:  The Open-Provide Movement And Database Administration

AACSB:  Use Of Data Experience

10) Which Of The Following Threats Consists of Open air Occasions Using Data To Embarrass A Agency?

1. A) Unintended Loss
2. B) Theft And Fraud
3. C) Loss Of Confidentiality
4. D) Loss Of Info Integrity

Reply:  C

Diff: 2    Net web page Ref: 473, 474

Matter:  Database Software program program Info Security Choices

AACSB:  Use Of Data Experience

Subtopic:  Threats To Info Security

11) Pointers For Server Security Must Embody All Of The Following EXCEPT:

1. A) Securing The Group Between Shopper And Server.
2. B) Pointers For Password Lengths.
3. C) Password Naming Conventions.
4. D) Pointers For Frequency Of Password Modifications.

Reply:  A

Diff: 2    Net web page Ref: 475

Matter:  Establishing Shopper/Server Security

AACSB:  Use Of Data Experience

Subtopic:  Server Security