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!
How is the database organised in Oracle?
Database organized within Oracle in terms of table and table holds attributes and values.
A database consists of one or more logical units known as table spaces. Each table space within turn, consists of one or more physical structures known as data files. These might be either, files managed through the operating system or raw devices.
Oracle database consists of subsequent table spaces.
(i) System (ii) Table spaces to store user data (iii) Temporary table spaces.
The space in table space is separated into units, called segments, that each contains data for a specific data structure. These are four kinds of segments:
(i) Data segments (ii) Index segments (iii) Temporary segments (iv) Rollback segments
Explain how you can define an object model of a system. A list of terms that shall be used by end users to describe state and behaviour of objects in system. Different use
Aggregation Aggregation is stronger form of association. It represents the "has-a" or "part-of" relationship. An aggregation association depicts a complex object which is comp
The need for three level architecture The aim of the three level architecture is to divide each user's view of the database from the way the database is physically shown.
1 NF Normal Form The domain of attribute must add only atomic (simple, indivisible) values First normal form (Minimal Form or 1NF) is a normal form need in database normalizat
What is Interaction Diagram An interaction diagram shows an interaction, comprises of a set of objects and their relationships including the messages that may be dispatched be
what is the importance of back up files
draw er diagram using entities crop,employee,department,plot,cultivation plan,machinery,seed,fertilizer
Derived horizontal fragmentation: Some applications may include a join of two or more relations. If the relations are stored at dissimilar locations, there may be a major overhead
Super keys of a relation can have extra attributes. Candidate keys are minimal super key, i.e. such a key have no extraneous attribute. An attribute is known as extraneous if even
Define check point and its impact on data base recovery. Ans: There could be hundreds of transactions handled per minute, in a large on-line database system.
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