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!
Define Query Processing
Query processing is the process of selecting the best plan or strategy to be employed in responding to a database request. The plan is then executed to produce a response. The component of the DBMS accountable for generating this strategy is known as a query processor. It is a step by step process. The first or initial step is to transform the query into a standard from. For instance, a query in QBE looked into by the research community. Query might be transformed into a relational algebraic expression; the optimization is carried out by substituting equivalent expressions for those in the query. In the next step a number of strategies known as access pans are generated for evaluating the transformed query. The physical characteristics of the data and any supporting access method are taken into account in producing alternate access pans. The cost of each access plan is calculated and the optimal one is selected and executed.
explain five responsibilities of DBA?
explain exhaustively the problems associated with ER diagrams. include illustrations in your answer
What are the costs to be considered when a transaction has to be rolled back when recovering from deadlock? Ans: A few transaction will must rolled back (made a victim)
Write short notes on Schema diagram. A database schema along with primary key and foreign key dependencies can be depicted pictorially by schema diagram. Every relation appears
Explain degree of relation? Degree of a Relation - The degree or arity of a relation is the number of attributes n of its relation schema.
Package classes and associations into models Programs are made of separate physical units which could be edited, imported, complied or otherwise manipulated. The careful part
Explain the Functional Mode with help of an example. Functional Model The functional model shows a computation and functional derivation of data values in it without ind
Creating views with check option : This option limits those updates of data values that cause records to go off the view. The following instance tells this in more detail: Examp
Fragmentation: It is definite as partitioning of a relation into various fragments.Every fragment can be stored at a dissimilar site.
Explain the systems development life cycle. This is the traditional method to develop, maintain, and replace information systems that contains the project identification and se
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