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.
List the SQL domain Types? SQL supports the following domain types. 1) Char(n) 2) varchar(n) 3) int 4) numeric(p,d) 5) float(n) 6) date.
Shared lock or Read Lock It is requested by a transaction that needs to just read the value of data item. A shared lock on a data item does not permit an exclusive lock
What is a hashing function? What are the properties of a good hashing function? Describe the folding technique for hashing functions. Ans: Hashing function is a method
Define data model? A data model is a collection of conceptual tools for explaining data, data relationships, data semantics and consistency constraints.
Given the subsequent relations: vehicle (reg_no, make, colour) Person (eno, name, address) Owner (eno, reg_no) Write expressions
What will be create when a primary key if combined with a foreign key? A primary key if combined with a foreign key it creates Parent-Child relationship between the tables that
let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation
Database Administrator One of the main perpose for having the database management system is to have control of both data or programs accessing that data. The person having li
Differentiate OO development from structured development. Structured approach of problem solving is based upon the idea of decomposition of system into subsystem. In this appro
Question (a) Concurrent access to data from a database is a normal part of application program usage. Describe three approaches to concurrency control (b) Distinguish among
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