Quiz
Chapter 16 (Multiple Choice) CIS 3365
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (40)
11.A DBMS facilitates ____.
- AA) interpretation and presentation of data in useful formats
- BB) destruction of data and information to the right people at the right time
- CC) data presentation and data usage monitoring for adequate periods of time
- DD) automatic auditing of all data changes
22. At the level of middle management, the database must be able to ____.
- AA) represent and support the company operations as closely as possible
- BB) deliver the data necessary for tactical decisions and planning
- CC) produce query results within specified performance levels
- DD) provide access to external and internal data to identify growth opportunities and to chart the direction of such growth
33.When introducing a database into an organization, a(n) ____ impact is likely because the database approach creates a more controlled and structured information flow and thus affects people, functions, and interactions.
- AA) cultural
- BB) managerial
- CC) technical
- DD) operational
44.The person responsible for the control of the centralized and shared database is the database ____.
- AA) analyst
- BB) administrator
- CC) programmer
- DD) user
55.It is common practice to define the DBA function by dividing the DBA operations according to the____ phases.
- AA) SLA
- BB) DBLC
- CC) SDLC
- DD) MRA
66.There is a growing trend toward ____ in the data-management function.
- AA) cross-training
- BB) encapsulation
- CC) specialization
- DD) centralization
77.The ____ administrator is responsible for strategic planning.
- AA) system
- BB) data
- CC) database
- DD) program
88.The DBA’s ____ role is focused on personnel management and on interactions with the end-user community.
- AA) administrative
- BB) arbitration
- CC) technical
- DD) managerial
99. As a manager, the DBA must concentrate on the ____ dimensions of the database administration function.
- AA) control and planning
- BB) conflict and problem-resolution
- CC) policies and standards
- DD) security and privacy
1010.The DBA’s ____ role covers activities involving the use of the DBMS.
- AA) administrative
- BB) arbitration
- CC) technical
- DD) managerial
1111.____ are general statements of direction or action that communicate and support DBA goals.
- AA) standards
- BB) policies
- CC) documentation
- DD) procedures
1212.____ are more detailed and specific than policies and describe the minimum requirements of a given DBA activity.
- AA) guidelines
- BB) standards
- CC) procedures
- DD) documentation
1313.____ are written instructions that describe a series of steps to be followed during the performance of a given activity.
- AA) policies
- BB) standards
- CC) documentation
- DD) procedures
1414.“All users must have passwords” is an example of a ____.
- AA) rule
- BB) policy
- CC) standard
- DD) procedure
1515.Instructions to create a password are an example of a ____.
- AA) rule
- BB) policy
- CC) standard
- DD) procedure
1616. The ____ is responsible for ensuring database security and integrity.
- AA) database programmer
- BB) systems analyst
- CC) data administrator
- DD) database security office
1717.Procedures and standards must be revised at least ____ to keep them up-to date.
- AA) weekly
- BB) monthly
- CC) every six months
- DD) annually
1818.Current data distribution philosophy makes it easy for ____end users to access the database.
- AA) limited
- BB) unauthorized
- CC) authorized
- DD) any
1919.A(n) ____ plan is a set of instructions generated at application compilation time that predetermine show the application will access the database at run time.
- AA) access
- BB) completion
- CC) application
- DD) communications
2020.____activities cover all tasks directly related to the day-to-day operations of the DBMS and its applications.
- AA) Backup and recovery
- BB) system support
- CC) performance monitoring and tuning
- DD) security auditing and monitoring
2121.____deals with ensuring that data is protected against unauthorized access, and if the data are accessed by an authorized user, that the data are used only for an authorized purpose.
- AA) integrity
- BB) compliance
- CC) availability
- DD) confidentiality
2222.____ security breaches include database access by computer viruses and by
hackers whose actions are designed to destroy or alter data.- AA) Dangerous
- BB) Preserving
- CC) Corrupting
- DD) Authorized
2323.____ management is designed to limit access to the database.
- AA) Authorization
- BB) User access
- CC) View
- DD) DBMS utility
2424. Some common physical security practices found in large database installations include secured entrances, password-protected workstations, ____, closed-circuit video, and voice-recognitiontechnology.
- AA) drug testing
- BB) fingerprinting
- CC) electronic personnel badges
- DD) retina scans
2525.User-access management is a subset of ____.
- AA) password protection
- BB) authorization management
- CC) data integrity
- DD) managerial control
2626.Classifying users into ____ according to common access needs facilitates the DBA’s job of controlling and managing the access privileges of individual users.
- AA) user groups
- BB) sections
- CC) authorization schemes
- DD) policy definitions
2727.Several DBMS packages contain features that allow the creation of a(n) ____, which automatically records a brief description of the database operations performed by all users.
- AA) change tracker
- BB) digital footprint
- CC) paper trail
- DD) audit log
2828.A(n) ____ data dictionary is automatically updated by the DBMS with every database access.
- AA) dynamic
- BB) active
- CC) passive
- DD) static
2929.A(n) ____ data dictionary is not updated automatically and usually requires a batch process to be run.
- AA) active
- BB) passive
- CC) static
- DD) dynamic
3030.____ CASE tools provide support for the planning, analysis, and design phases.
- AA) Front-end
- BB) Back-end
- CC) Vertical
- DD) Horizontal
3131.____ CASE tools provide support for the coding and implementation phases.
- AA) Front-end
- BB) Back-end
- CC) Vertical
- DD) Horizontal
3232.The ____ component of a CASE tool produces the information system’s input/output formats.
- AA) analysis
- BB) graphics
- CC) program document generator
- DD) screen painter and report generator
3333.____ allows for the translation of the company’s strategic goals into the data and applications that will help the company achieve those goals.
- AA) Access Management
- BB) Business Intelligence
- CC) Information engineering (IE)
- DD) MOLAP
3434.A(n) ____ serves as the basis for planning, development, and control of future information systems.
- AA) access plan
- BB) active data dictionary
- CC) information systems architecture (ISA)
- DD) security policy
3535.A(n) ____ is a logical storage space in Oracle.
- AA) audit log
- BB) datafile
- CC) schema
- DD) tablespace
3636.In the Oracle Enterprise Manager, a ____ is basically any object created by end users; for example, tables, views, indexes, stored procedures, and triggers.
- AA) component
- BB) database object
- CC) policy
- DD) role
3737.A ____ is a uniquely identifiable object that allows a given person to log on to the database.
- AA) user
- BB) role
- CC) profile
- DD) manager
3838.A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.
- AA) user
- BB) role
- CC) profile
- DD) manager
3939.A ____ is a named collection of settings that control how much of the database resource a given user can use.
- AA) user
- BB) role
- CC) profile
- DD) manager
4040.One of the important functions provided by the database ____ is to reserve the resources that must be used by the database at run time.
- AA) security component
- BB) authorization manager
- CC) initialization parameters
- DD) administrator
Information
- Description
- asdf Quiz on Chapter 16 (Multiple Choice) CIS 3365, created by . . on 08/09/2016.
- Author
- . .
- Language
- English
- Views
- 562
- Tags
- Rating
- No ratings yet Rate this quiz