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!
What is Oracle databse structure?
Oracle database structure: The relational model has three main aspects:
Structures: Structures are well-defined objects which store the data of a database. Structures and the data contained inside them can be manipulated through operations.
Operations: Operations are clearly described actions which permit users to manipulate the data and structures of a database. The operations on a database must adhere to a pre- described set of integrity rules.
Integrity Rule: Integrity rules are the laws in which govern those operations is permitted on the data and structures of a database. Integrity rules protect the data and the structures of a database.
An ORACLE database has both a physical and a logical structure. Through separating physical and logical database structure, the physical storage of data could be managed without affecting the access to logical storage structures.
What is Specialization? Specialization: Specialization permits you to describe new types of information (new structural types or latest domains of information), although reusin
Define identify relationship? Identifying relationship: An identifying relationship means in which the child table cannot be uniquely recognize without the parent. For exampl
Explain the integrity constraints: Not Null, Unique, Primary Key with an example each. Is the combination 'Not Null, Primary Key' a valid combination. Justify. Not Null - Shou
Question: One of the tasks a database management system must perform is to ensure that the data is still intact in the face of software and hardware failure. This task is known
WOUND-WAIT
Define an abstraction by which relationships are treated as higher level entities Ans: Aggregation. It is an abstraction by which relationships are treated as higher level
Explain what is Aggregation ? Aggregation: This is used whenever we intend to show a relationship between an entity and the relationship. There is no provision for this in th
Problem: You are given the following schema 1. Flights(flno, from, to, distance) 2. Aircraft(aid, flno, aname, cruisingRange) 3. Certified(eid, aid) 4. Employees(eid, ena
What are the various states through which a transaction passes through in its lifetime? Briefly discuss all the events that causes transition from one state to another. Ans:
Authorisation Authorisation is the culmination of the administrative policies of the organisation. As the name shows, authorisation is a set of rules that can be used to verif
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