DATABASE FUNDAMENTALS
DATABASE ADMINISTRATION AND SECURITY
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
access plan
|
|
active data dictionary
|
|
information systems architecture
|
|
security policy
|
Detailed explanation-1: -enterprise database-The overall company data representation, which provides support for present and expected future needs. centralized DBMS-A database management system that supports a database located at a single site.
Detailed explanation-2: -The DBA must supervise the installation of all software and hardware designated to support the data administration strategy. The DBA function provides data modeling and design services to the end-user community, often through coordination with an application development group within the data-processing department.
Detailed explanation-3: -A passive data dictionary is one that is updated automatically with every database access to keep its access information up to date.
Detailed explanation-4: -Training people to use the DBMS and its tools is not included in the responsibilities of a DBA. The maintenance activities of the DBA are an extension of the operational activities. A security breach is a weakness in a system component that could be exploited to allow unauthorized access or cause service disruptions.