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!
PHYSICAL DBMS ARCHITECTURE
The physical architecture defines the software components used to process and enter data, and how these software components are related and interconnected. Though it is not possible to simplify the component structure of a DBMS, it is possible to recognize a number of key functions which are similar to most database management systems. The components that normally execute these functions are shown in Figure , which depicts the physical architecture of a typical DBMS.
Figure: DBMS Structure
Based on many functions, the database system may be partitioned into the following modules. Some functions (for example, file systems) may be given by the operating system.
What is a primary index? A primary index is an index whose search key also explains the sequential order of the file.
What are the aggregate objects in the data dictionary? Views Match codes Lock objects.
Define cardinality and participation constraints on a relationship type, completeness constraint on generalization. Ans: Cardinality defines the number of entities to wh
What is the use of unique function? UNIQUE function: If UNIQUE is specified then only unique values are used to computed the mean.
Ask questiwhat is row indicator in database on #Minimum 100 words accepted#
Describe the types of Inheritance 1. Single inheritance 2. Multiple inheritance 3. Hierarchical inheritance 4. Multilevel inheritance
Explain outer join? Outer Join - If there are any values in one table which do not have corresponding value(s) in the other, in an equi-join which will not be chosen. Such ro
What do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is
What is meant by computing the closure of a set of functional dependency? The closure of F denoted by F + is the set of functional dependencies logically implied by F.
Define instance and schema? Instance: Collection of data kept in the data base at a particular moment is known as an Instance of the database. Schema: The o
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