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!
What is serializability? Explain its types?
The data base system must control concurrent implementation of transactions, to ensure that the data base state remains consistent. There are dissimilar forms of schedule equivalence they lead to the notions of
a) Conflict serializability
B) View serializability
Conflict serializability
We say that ii and I j conflict if they are operations by dissimilar transaction on the similar data item and at least one of these instruction is a write operations
Which is an advantage of view? The Advantages of view is Data security, Derived columns and Hiding of complex queries
The need for three level architecture The aim of the three level architecture is to divide each user's view of the database from the way the database is physically shown.
Define DBA database administrator? DBA : A database administrator (DBA) is a person who is responsible for the environmental aspects of a database. In common, these involves:
What is object containment? References among objects can be used to model dissimilar real-world concepts.
System error :These contain errors in database system or the OS, example, deadlocks.Such errors are fairly hard to detect and need reprogramming the erroneous components of the sys
What is a heterogeneous distributed database? In a heterogeneous distributed database, dissimilar sites may use different schemas, and dissimilar dbms s/w. The sites may not be
Information about a bank is about customers and their account. Customer has a name, address that consists of house number, area and city, and one or more phone numbers. Account ha
how many types of data model in DBMS? explain data abstraction with its different level
Self-Join: In a self join a table is joined with itself. Let consider the following sample partial data of EMP table EMPNO ENAME MGRID
What is data block? Data Block - In oracle the data blocks are referred to as tablespaces. A tablespace is an fields of disk consisting of one or more disk files. A tablespace
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