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.
Describe the tools that are available for managing MySQL Server. Given below are the tools to manage MySQL server: mysqld - MySQL server daemon. This is used to begain t
Synonyms It allows short names or alternative names for objects. Example : CREATE SYNONYM D30 FOR EMPD30; Now if we give command:
For every multivalued attribute 'A', we make a new relation R that contains an attribute corresponding to plus the primary key attribute k of the relation that shows the entity typ
What is Alternate Key Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, the
Determine the benefits of Object oriented design OOD also gives reusability, which saves time, costs and productivity gains through direct mapping to properties of Object-Orie
Using Literal Character String Example: To print IS A as one string with column name employee SELECT ENAME || ' IS A ' || JOB AS "EMPLOYEE" FROM EMP;
User error : This contains errors in the program (e.g., Logical errors) with errors made by online users of database. These types of errors can be avoided by applying some check
Define the terms entity, attribute, role and relationship between the entities, giving examples for each of them. Ans: Entity: An entity is a "thing" or "object" in th
employee(empid,empname,dept,telno,mobno, add,sssno,tinno,WEdates,WEcomp,WEadd,WEpos,WEres) this is a employee record which is need to be normalize.the WE means work experience
recovey techniques based on deferred update and immediate update
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