ACID
ACID is not something that can be directly used by end-users?
TRUE!
ACID is not something that can be directly used by end-users. Rather, it is a set of principles that are implemented by database management systems (DBMS) to ensure the reliability and consistency of data.
Inner Join returns only the rows that have matching values in both tables being joined?
TRUE!
This is the most common type of join. It returns only the rows that have matching values in both tables being joined. The result set includes only those rows where the join condition is true.
The replica databases are kept in Async with the master database, so that they can provide a backup mechanism for disaster recovery.
FLASE!
The replica databases are kept in sync with the master database, so that they contain the same data at all times.
What is ACID stands for?
1. Autonomously, Consistency, inherently and Durability
2. Amit, Cohen, Is , Dum
3. Atomicity, Consistency, Isolation, and Durability
4. Atomicity, Coherency, Isolation and Duplication
3. Atomicity, Consistency, Isolation, and Durability
Which types of join is not a standard SQL join type
1. Inner Join
2. Up join
3. Left Join
4. Cross Join
2. Up join
Which of these reasons accurately match this statment : "providing alternative copies of the database that can be used if the primary database becomes unavailable due to a hardware failure or other issue."
1. Disaster recovery
2. Scalability
3. Geographical distribution
4. High availability
4. High availability - Replication can improve system availability by providing alternative copies of the database that can be used if the primary database becomes unavailable due to a hardware failure or other issue.
What Consistency stand for?
This property ensures that a transaction cannot leave the database in an inconsistent state. The data must be valid according to all defined rules, constraints, and relationships.
What is Self Join, and what is it useful for?
Self Join: This join is used to join a table with itself. It is useful when you need to compare rows within a table.
Explain how database replication can help with Geographical distribution
Geographical distribution: Replication can enable you to distribute your data across different geographical locations, allowing users in different regions to access data more quickly and efficiently.