What is the CAP theorem?



What is the CAP theorem?..

Answer / hr@tgksolutions.com

The CAP theorem states that a distributed database can achieve at most two of the following three properties:
• Consistency (C) – All nodes have the same data at the same time.
• Availability (A) – System continues to function even if nodes fail.
• Partition Tolerance (P) – System continues to operate despite network failures.
No system can provide all three simultaneously.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

What is difference between truncate and delete?

1 Answers  


What are the execution control statements in oracle?

1 Answers  


What WHERE CURRENT OF clause does in a cursor?

2 Answers  


Explain the use of grant option in imp command.

1 Answers  


How does Oracle guarantee data integrity of data changes?

1 Answers  


How many data types are supported?

1 Answers  


What is meant by an index?

1 Answers  


How to run queries on external tables?

1 Answers  


What is a nested table and how is it different from a normal table?

1 Answers  


What is oracle sid?

1 Answers  


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1 Answers   Oracle,


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)