There are various conditions in which one might perform a complete recovery, incomplete recovery, block level recovery, flashback query, flashback table…

Database back and recovery is a key element in database technology because timely data availability is very important in this information age. However, …

The competition in the software industry is ruthless; and many software corporations are striving to provide quality of the products to its customers. Q…

1.Create a copy of the PFILE and save it as an original copy. SQL> CREATE PFILE='C:\TEMP\INIT.ORA' FROM SPFILE; 2.Configure the SGA accor…

1. After re-examining the performance problem set out at the start of the chapter, answer the following questions: a. Define Joe Doe’s problem in your…

1. Which dynamic performance view would you use to see what objects are present in the cache buffer? a. V$BUFFER_STATISTICS b. V$BUFFER_POOL c. V$BH…

1. You can use a formula to configure the size of the buffer cache. (True/False)___ FALSE ___ 2. The buffer cache does not support tablespaces with mu…

Chapter 1 Review Questions & Solutions: 1.    DBAs must be involved in the database design to ensure that all functional specification requirements…