Q1- Describe how an ERD can be taken as a logical representation, and implemented into a physical representation in a database.
Q2- Find and explain some more advanced SQL queries that a DBA might use to find some specific information about a database.
Q3- Please try to find different sql statements. and Explain what they do. IF possible, show some of the output as well.
Q4- How do you determine the optimum number of redolog files, their size and the number of groups you shuld have for your databse?
What is archivelog mode? What are the requirements for using archivelog mode? Describe what happens when in and not in archvelog mode.