Database Design, Chapter 10

An entity ____ might be viewed as a separate entity by one or more departments.
1. subtype
2. synonym
3. homonym
4. conflict
Maintenance and enhancement are part of the ____ phase of the SDLC.
1. planning
2. maintenance
3. detailed systems design
4. implementation
____ are usually provided by the DBMS to check for access violations.
1. Access rights
2. Diskless workstations
3. Security devices
4. Audit trails
The assignment of ____ may restrict operations on predetermined objects such as databases, tables, views, queries and reports.
1. diskless workstations
2. password security
3. access rights
4. audit trails
The initial assessment and feasibility study are part of the SDLC's ____ phase.
1. planning
2. analysis
3. detailed systems design
4. implementation
The user requirements, existing system evaluation, and logical system design are part of the ____ phase of the SDLC.
1. planning
2. analysis
3. detailed systems design
4. implementation
The detailed system specification is part of the ____ phase of the SDLC.
1. planning
2. analysis
3. detailed systems design
4. implementation
____ design is likely to be employed when the problem itself is spread across several operational sites and each element is a subset of the entire data set.
1. Normalized
2. Denormalized
3. Decentralized
4. Centralized
The implementation of ____-produced applications tends to prolong the operational life of systems by making them easier to update and maintain.
1. database
2. network
3. CASE
4. design
____ can be used to render data useless to unauthorized users who might have violated some of the database security layers.
1. Data encryption
2. Diskless workstations
3. Access rights
4. Audit trails
____ design is productive when the data component is composed of a relatively small number of objects and procedures.
1. Normalized
2. Denormalized
3. Decentralized
4. Centralized
The logical systems design is created during the ____ phase of the SDLC.
1. planning
2. analysis
3. implementation
4. maintenance
____ design first identifies the data elements (items), then groups them together in data sets.
1. Top-down
2. Bottom-up
3. Analysis
4. Conceptual
The database initial study phase of the DBLC involves ____.
1. defining objectives
2. introducing changes
3. testing the database
4. installing the DBMS
Once the data have been loaded into the database, the ____ tests and fine-tunes the database for performance, integrity, concurrent access and security constraints.
1. programmer
2. manager
3. database administrator
4. systems administrator
A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.
1. user
2. role
3. profile
4. manager
The DBA's ____ role covers activities involving the use of the DBMS.
1. administrative
2. arbitration
3. technical
4. managerial
____ are general statements of direction or action that communicate and support DBA goals.
1. Standards
2. Policies
3. Documentation
4. Procedures
A way of identifying the user and verifying that the user is allowed to access some restricted data or application is through _________________.
1. user authentication
2. policies and procedures
3. data encryption
4. audit trails
The ____ administrator is responsible for providing a global and comprehensive administrative strategy for all of the organization's data.
1. system
2. data
3. database
4. program

Database Design, Chapter 10

Quiz