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 data dictonary on oracle ?
Data Dictionary - Data dictionaries are the system tables in which contain descriptions of the database objects and how they are structured.
What is self-transition? If there is a transition which goes back to same state, it is known as "self- transition." With a trigger action exit action would be executed f
Define a view and a trigger. Construct a view for the above relations that have the information about suppliers and the elements they supply. The view holds the S#, SNAME, P# , PNA
Which is an advantage of view? The Advantages of view is Data security, Derived columns and Hiding of complex queries
What are the aggregate objects in the data dictionary? Views Match codes Lock objects.
Normal 0 false false false EN-US X-NONE X-NONE
Authorisation Authorisation is the culmination of the administrative policies of the organisation. As the name shows, authorisation is a set of rules that can be used to verif
What are stored-procedures? And what are the advantages of using them? Stored procedures are database objects that perform a user defined operation. A stored procedure can have
What is serialization? Where it is used and why? Serialization is a basic term used for mechanisms which enable objects and object structures to be converted into portable for
What is vertical fragmentation? Vertical fragmentation divides the relation by decomposing the scheme R of relation r.
Define Hash files organization a. Hashing includes computing the address of a data item by calculating a function on the search key value. b. A hash function h is a functi
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