Security and recovery are two important functions of a Database Management System, which are also of interest to Database Administration. Various facilities can be provided to aid both these functions. Explain what these facilities are and with examples, show how Database Administration could effectively use them.
What will be an ideal response?
The examples should be given using the current DBMS that is in use. The focus is on security and
recovery. Security may include authorization mechanisms and associated granting of access
privileges. Views and encryption procedures may also be described. These mechanisms should be
elaborated. Recovery functions include backup procedures and safe storage of the media,
journaling and checkpointing, and the recovery manager. The database administration role should
be linked to their use.
You might also like to view...
What is the file containing the program called after it has been translated into machine language?
What will be an ideal response?
Data ___________ language allows you to configure the logical security in the database.
Fill in the blank(s) with the appropriate word(s).
How can you calculate expressions when the data is not immediately available in a table? What is this called and how did you use this technique to answer the manager's questions for Jasmine?
What will be an ideal response?
Which of the following was specifically created to protect credit card transactions?
A. SSL B. TLS C. SET D. SSH