Database-administration-computer-science-homework-help

1)

Recovery of data is crucial and is one of the core tasks performed by a Database Administrator. Discuss with suitable examples, the guidelines that a Database Administrator should consider when configuring a database instance redo log. Your solution should include the necessary SQL commands (as screenshots) to configure the redo logs.

Note:

The solution must be written in 4 to 7 pages.

You must execute the SQL commands so as to take the screenshots.

# Discuss in brief redo log buffer// log writer// redo log file// Archiver (ARCn).

All the configuration of redo log are required. #

The solution for this task must be written in 4 to 6 pages).)

2)

((Database Auditing – Security Considerations))

Detailed solution should be written.#

# The solution for this task must be written in 4 to 5 pages.