Answered step by step
Verified Expert Solution
Question
1 Approved Answer
10:35 Answer 1 of 1 Basically DBMS have following characteristics ACID Properties-DBMS follows the concepts of Atomicity, Consistency, Isolation, and Durability (normally shortened as
10:35 Answer 1 of 1 Basically DBMS have following characteristics ACID Properties-DBMS follows the concepts of Atomicity, Consistency, Isolation, and Durability (normally shortened as ACID). These concepts are applied on transactions, which manipulate data in a database ACID properties help the database stay healthy in multi- transactional environments and in case of failure Stores any kind of data-A database management system kind of data that exists in the real world can be stored in Pred to work with all kinof Backup and recovery-There are many chances of failure of whole database. At that time no one will be able to get the database back and for sure company will be in a big loss. The only solution is to take backup of database and whenever it is needed, it can be stored back. All the databases must have this characteristic But from this Provied artical i can call out the following as characteristics Alational dia DMS that prosents the data tabular form of rows and cols table is a pation of ity. A table is a combination of column and rows. Each colle stribute of the entity, also known as fields or properties ROBSES allow Create, Read Update, and De (CRUD) operati SQL provides DMI (Data Manipulation Lang commands that are used insert, update and deleted Common DML commands are INSERT, UPDATE DELETE SQL DDL (Data Definition Language command a ed to manipulate the database objects such as data tell, table, and other object RDBMS, but also provides functionality for Cloud, Document Store, Graph DBMS, Keyalar g BLOG, and PDF Sages Recently Oracle just ced as feature that allows the PostgreSQL is for its architecture, reliability dedication of the community behind the IBM DB2 database is relational database that deli advanced data management and analytics capabilities for your transactional and warehousing workload. This operational database is designed to deliver high perfarms, actionable insights, data availability, and The Dbl database software includes advanced features such as in-memory technology, advanced manag and development tools, storage optimization, workad management, actionable compression, and conti In short Real-world entity- Relation-based tables- Isolation of data and application- Less redundancy Consistency Query Language ACID Properties Multiuser and Concurrent Access- Multiple views Security- Examples proved in artical consider and works on all this characterstics Done
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started