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 are the types of reference?explain it with suitable examples?
Object oriented language given the ability to refer the object attribute of the type can be referred to the specified type. We can describe the type dept with a field name and a field head which is reference to the type person and a table dept of the type dept as followed
Create type dept(
Name varchar(20),
Head ref(person)scope people
)
Create table dept of dept
The table definition must state that the reverence is derived and must still state a self referential attribute name. When interesting a tuple for dept we can then use
Insert into dept
Values('CS','john')
Ask qu. Write a XML with database with book details (Book ID, Title, Author, subject, published year, language, vendor, and price).estion #Minimum 100 words accepted#
what is stracture of dabms
Modular growth: In distributed environments, it is simple to expand. Latest sites can be added to the network without affecting the operations of other sites, as they are somewhat
An example of a weak entity is Staff because the availabilityID cannot be uniquely identified unless it is used in conjunction with the foreign key known as availabilityID in the A
Two Phase Locking (2PL) The two-phase locking protocol having of two phases: Phase 1 : The lock acquisition phase : If a transaction T needs to read an object, it wants to
comparison of oracle RDBMS with MySQL
Explain the integrity constraints: Not Null, Unique, Primary Key with an example each. Is the combination 'Not Null, Primary Key' a valid combination. Justify. Not Null - Shou
What are the two types of errors? The two types of errors are: a) Logical error b) System error
How many physical thing?
Replicating Data One approach that may support efficient access to dissimilar applications as above may be to give access to every of the applications from dissimilar replicate
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