0
Transactions commit only after all transactions whose changes they read, commit
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What is recoverability in dbms?
I do not know exactly
Who is the father of DBMS?
Charlie Bachman
What is deadlock in DBMS?
A dead lock is a state of stalmate that may result two or more transaction are each waitting for lock held by the other to be released. in three condition dead lock is appear.... 1.circular wait 2.no premsive 3. matual execlusive.
What are the basic concepts of DBMS?
DBMS stands for DataBase Management System. The main concepts are the structure, the manipulation, and a set of integrity rules.
Explain the link between hardware and application software?
DBMS
Serial schedule differs serializable schedule in dbms?
Serial schedules are the schedules during which all statements in a transaction are executed consecutively. Serializable schedule is a schedule that is equivalent to a serial schedule
What are some of DBMS Types?
1. Following are the different types of dbmsMySQLMicrosoft SQL ServerMS AccessFoxproSAPdBASETibero 6
Explain the centralized DBMS architecture in detail?
combines everything into a single system including, DBMS software,hardware, application programs and user interface
What is scheduling in dbms?
schedule is an interleaving of action from a set of transactions where the action of any transaction is in the original order.
Draw a neat diagram of components of DBMS and explain?
errjklerjqlwrjqwewqerlkwrlqewlrkqwerqewrqwklrjqweklodo tari ma no chodu
Explain the types of dbms users?
There are four types of DBMS users,Naive UsersOnline UsersApplication Program UsersDatabase AdministratorNote: The description of above points is currently not available.
What is concurrent schedule in dbms?
A concurrent schedule in DBMS refers to multiple transactions running concurrently without interfering with each other. This allows for improved performance and efficiency in handling multiple operations simultaneously. However, it requires careful management to ensure data consistency and avoid conflicts such as race conditions.
Explain the three schema architecture of DBMS?
Physical schema,logical schema and sub schemas
What is main difference between dbms rdbms why it is called relational database?
There are mainly three different Database architectures and they are network, hierarchical and Relational. The DBMSystems that follow the Relational architectural concepts are known as RDBMS. This is supposed to be superior in design and performance to the other two and there are, to my knowledge, no functional DBMS following the other two concepts in the market today.
Functions of database manager in Database management system. explain the functions with example.?
functions of DBA in DBMS
