DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Relational
|
|
|
NoSQL
|
|
|
Data Warehouse
|
|
|
None of the above
|
Detailed explanation-1: -Which Databases are ACID compliant? One safe way to make sure your database is ACID compliant is to choose a relational database management system. These include MySQL, PostgreSQL, Oracle, SQLite, and Microsoft SQL Server.
Detailed explanation-2: -ACID Compliance All of the major relational DBMSs adhere to the ACID principles. They all include features that ensure that the data maintains consistent throughout software and hardware crashes, as well as any failed transactions.
Detailed explanation-3: -Every relational database such as MySQL, postgresql, oracle and microsoft sql guarantees ACID properties of transaction.
Detailed explanation-4: -The short answer is that ACID, an acronym for “Atomicity, Consistency, Isolation, and Durability, ” is a set of principles that ensure database transactions are processed reliably. When any data storage system upholds those principles, it is said to be ACID compliant.