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!
Views
A view is like a window by which data from tables can be changed or viewed. The table on which a view is based is known as Base table. The view is stored as a SELECT statement in the data dictionary. When the user needs to retrieve data, using view. Then the following steps are defined.
1) View definition is finding from data dictionary table. For example, the view definitions in oracle are to be finding from table name USER-VIEWS.
2) Checks access privileges for the view base table.
3) Changes the view query into an equivalent operation on the underlying base table
What is the use of a slotted-page structure and what is the information are there in the header? The slotted-page structure is used for organizing records within a one block.
Define Physical and Logical independence Ans: Physical data independence: The ability to modify physical level without causing application program to be rewritten. Logic
Multilevel Index The Multilevel Index is a modification of the secondary level index system. In this system we might be use even more number of levels in case the table is eve
What is a recursive relationship? Give an example not used in the text. A recursive relationship is a relationship among an entity and itself. For example, given the entity PER
Lack of standards and experience: The lack of standards has considerably limited the potential of distributed DBMSs. As well, there are no tools or methodologies to help users cha
How external/conceptual mapping and conceptual /internal mapping is performed
explain cascading rollback
Implementing software control To implement software control designer must redesign strategy of state event model which is present in dynamic model. There are three basic ap
List the data structures implemented by the storage manager. The storage manager executes the following data structure a) Data files b) Data dictionary c) indices
What is a view? A view is a logical view on one or more tables. A view on one or more tables i.e., the data from a view is not actually physically kept instead being derived f
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