A vital part of managing and administrating a large database is that of Database Backup and Database Recovery. Discuss this statement outlining the key issues.
Also outline the options, and their requirements, available in implementing a Database Backup and Database recovery procedure with reference to the Oracle environment.
What are some threats that exist to data and features included in modern DBMS to enhance security?
Is cloud computing solution in Backup and recovery good?
What is data_dictionary?
Outline what type of information is held in the DATA_DICTIONARY, and the uses of this information.
Give examples of the type of queries and information available.
What role does the DATA_DICTIONARY play in backup and recovery of a database?
What information IS HELD IN THE DATA-DICTIONARY FOR EXAMINING TABLESPACES AND THEIR STATUS
What are the major inputs into the physical database design process> What decisions are influenced by those inputs.
With an Oracle Database in mind, outline the basic storage options available
What are default tablespaces that are implemented when u install oracle and whats their role?