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.
|
| |
|
| 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. |
| |
|
| 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. |
| |
|
| 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.
|
| |
|
| 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. |
| |
|
Gk Questions with Answers