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 about database system structure?
Storage manager
Authorization and integrity manager
Transaction manager
File manager
Buffer manager
Storage manager executes several data structure as a part of physical system execution
Data function
Data dictionary
Indices
The query processor
DDL interpreter
DML
Query evaluation engine
What are the advantages of object ID? The main advantages of Object IDs are as below: i) IDs are not changing ii) IDs are completely independent of the changes in data v
How is concurrency identified? Concurrency in objects can be identified by the way they alter their state. Current objects can change their state independently. Aggregation imp
Sub query in the UPDATE command : Example : //Double the commission for employees, who have got at least 2 increments. UPDATE EMP SET COMM = COMM * 2 WHERE
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
what do you mean by consistency in rdbms?
Define blocks? The database system resides eternally on non-volatile storage, and is into fixed-length storage units known as blocks.
What are the objectives of query processing? Ans: The objectives of query processing is to transform a query written in a high level language into a accurate and efficien
what is the need of a log in dbms
This project will involve designing and creating a database for an organization. In the design of a database, there is no single "perfect" design. So your database design may not
What is a candidate key? Minimal super keys are known as candidate keys.
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