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!
Describe disk manager and their work?
Disk Manager: Responsible for fetching data regulated through file Manager from disk storage within Main memory and deciding what data to cache in memory. It is a part of the O.S. of host computer and all physical input and output operations are performed through it. It gives disk abstraction to file Manager s.t. file Manager need not be concerned along with the physical features of the underlying storage media.
Define Outer join Outer join - If there are any type of values in the one table that do not have corresponding value(s) in the other, in an equi-join which will not be selected
Question 1 Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? Question 2 With a necessary example explain (i)
Define Fifth Normal form is concerned with Ans : Fifth Normal form is concerned with Join dependency.
Nested Queries Let us see some more complex queries in this section. Sub-queries: Some of the basic concerns of sub-queries are: A sub-query is a SELECT statemen
Parallelism of transaction execution: A transaction can be divided into various sub-queries that can operate on fragments in parallel. This enhances the degree of concurrency in t
What is conceptual schema? The schemas at the view level are known as subschema that describe dissimilar views of the database.
explain the mapping constraints
What is known as clustering file organization? In the clustering file organization, records of several dissimilar relations are stored in the similar file.
Give an example of enforcement in Typing. You can understand the idea of enforcement as it makes sure objects of dissimilar classes may not be interchanged as below: Exampl
(A) For the relation; CarSales (RegNo, BuyerName, Address, SalesPerson, Make, Model, Commission) The following functional dependences hold, RegNo _ID à Make, Model Reg
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