Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Explain the disadvantages of using DBMS
There could be a few disadvantages of using DBMS.
As DBMS requires computers, we have to invest a good amount in acquiring the hardware, software, installation facilities and training of users.
We have to keep regular backups because a failure can happen any time. Taking backup is a lengthy process and the computer system cannot perform any other job at this time.
Whereas data security system is a boon for using DBMS, it must be very robust. If someone can bypass the security system then the database would become open to any type of mishandling
Backward Recovery (UNDO): In this system the uncommitted changes made by a transaction to a database are undone. Instead the system is reset to the last consistent state of databa
Let us now talk about the relational operations: SELECT The select operation is used to select few specific record from the database based on different criteria, This is a un
Describe the four main ways of optimising disk block access. Ans: a. Disk b. Non-volatile writes buffers c. File organization (Clustering) d. Log-based file system
Normal 0 false false false EN-US X-NONE X-NONE
Example : Create a sequence named SEQSS that starts at 105, has a step of 1 and can take maximum value as 2000. CREATE SEQUENCE SEQSS START WITH 105 INCREMENT BY 1 MAX VA
Failures and Recovery In practice various things might occur to prevent a transaction from completing. Recovery methods are used to bring database, which does not satisfy consi
Define what Immediate database modification technique uses? Ans: Both undo and redo.
With the help of a suitable diagram gives module wise explanation of system architecture of DBMS.on..
wh
Consider employee (e_no, e_name, e_salary, d_code), dept (d_code, d_name) and dependent (depndt_name, e_no, relation). Show the names of employees in purchase and accounts departm
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd