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...
Details about the Excel workbook that describe or identify the file, including the title, author name, subject, and keywords that identify the file's topic or contents, are called ________
A) shared information B) documents C) properties D) identifiers
What is the proper placement of parameters in a function or method definition?
A. Before the function name B. After the function name but before the parentheses C. Inside the parentheses D. After the parentheses