Oracle Dba Interview Question and Answers

46. What is RAC Cluster?
 
  • RAC Cluster is a database with a shared cache architecture that overcomes the limitations of traditional shared nothing and shared disk approaches.
  • It is a key component of Oracle’s private cloud architecture.
 
Your Name Your Email-ID
Your Answer
47. What is checkpoint?
  A checkpoint is point when a background process updates the headers of all datafiles and control files to synchronize the files. At checkpoint, DataBase Writer(DBWR)writes the dirty buffers to the datafile.
 
Your Name Your Email-ID
Your Answer
48. What is Logical Change Record?
  LCR contains database change. Streams require the changes to be captured in specific format. LCR keeps the changes in that format.
 
Your Name Your Email-ID
Your Answer
49. What is the difference between Oracle Streams and Change Data Capture?
 
  • Oracle Streams are based on advanced queues. The streams provides a mechanism to synchronize data between two servers.
  • Streams ensure reliable data synchronization between the servers based on the defined rules.
  • Both Oracle CDC and Streams are generally used for data synchronization between Oracle database servers.
  • With Oracle CDC, you could write your own export routines, which create flat files for the purpose of synchronization between two database servers; whereas, with Streams must have a network link between the 2 servers.
 
Your Name Your Email-ID
Your Answer
50. What is a Tablespace?
  A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together.
 
Your Name Your Email-ID
Your Answer