DATABASE FUNDAMENTALS
DATABASE ADMINISTRATION AND SECURITY
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -When adopting a new DBMS, the DBA is responsible for designing, implementing and maintaining the database system. Often, that includes installing the DBMS and setting up the IT infrastructure to allow applications to access databases.
Detailed explanation-2: -designing maintenance procedures and putting them into operation. ensuring that databases meet user requirements. liaising with programmers, applications/operational staff, IT project managers and other technical staff. managing database security/integrity and backup procedures.
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: -How does DBA’s responsibility regard to the data dictionary? DBA maintains the data dictionary, establishes naming conventions for its contents, and provides information from it to others in the organization.