DATABASE FUNDAMENTALS
DATABASE ADMINISTRATION AND SECURITY
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
change tracker
|
|
|
digital footprint
|
|
|
paper trail
|
|
|
audit log
|
Detailed explanation-1: -The DBA can use an audit log to automatically record a brief description of the database operations performed by the users.
Detailed explanation-2: -Availability refers to the accessibility of data whenever required by authorized users and for authorized purposes. To ensure data availability, the entire system (not only the data component) must be protected from service degradation or interruption caused by any source (internal or external).
Detailed explanation-3: -System support activities cover all tasks directly related to the day-to-day operations of a DBMS and its applications. 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.
Detailed explanation-4: -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-5: -A standard operating procedure is a set of written instructions that describes the step-by-step process that must be taken to properly perform a routine activity.