Oracle DBA Interview Questions and Answers
Q30) How can we monitor these space allocations in a database? Answer: DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES Read More Oracle Dba Online Training Q31) Defined by Recovery Catalog? Answer: Recovery Catalog is a means by database schema that holds by the metadata managed by RMAN for restoration data and recovery data processes. Q32) What is means by Database Writer? Answer: DBWR is a background process that writes changed data blocks of defense amounts over this data file. This changed information blocks move called dirty blocks. Q33) What are the specific disk components? Answer: Data files Redo Logs Control files Password files and Parameter files Q34) What is mean by Oracle DBA PGA? Answer: PGA is a memory distance used by Oracle database. It is expected to save session specific information. Q35) When effects DBWR write to the data file? Answer: When checkpoint occurs When number from infected blocks provides...