Database Related

Question 1

What is CAP theorem

Answer 1

A dis distributed system can only have two of consistency, availability or partition tolerance

Question 2

What CAP theorem characteristics does relation database has?

Answer 2

Availability and Consistancy

Question 3

What are the types of database consistency? What consistency type do relational databases have? What about nonrelational DBS?

Answer 3

Types of consistency

        1. Strict consistency
         2. Eventual Consistency

RelationsDBs have strict consistency. (changes are reflected immediately)
nonrelational DBS Eventual Consistency(changes are not reflected immediately)

Question 4

What is serialiazable interface in java

Answer 4

Serializable is a marker interface your classes must implement if they are to be serialized and deserialized.

Serialization in Java allows us to convert an Object to a stream that we can send over the network or save it as file or store in DB for later usage.

Question 5

What is Referential integrity

Answer 5

Referential integrity is a property of data stating that all its references are valid. In the context of relational databases, it requires that if a value of one attribute (column) of a relation (table) references a value of another attribute (either in the same or a different relation), then the referenced value must exist