0
Oracle and Access are both RDBMS's (Relational Database Management Systems). Consequently they both use tables which have 'keys' to retrieve rows, and use 'foreign keys' to other tables to 'relate' those rows together. Oracle and Access also both use SQL (Structured Query Language) to allow you to use the database (for example: "select * from customer_table where customer_number = '12345'"), although you can use tools which provide a more graphical environment to produce the underlying SQL. The real difference between the two is that Oracle is an industrial strength RDBMS.
Still curious? Ask our experts.
Chat with our AI personalities
Steve
Jordan
ReneThere are very less similarities ;) . on the top of my mind i can tell you that , Oracle (10g) and SQL Server (2005) has almost similay at the network level. by which i am refering to the the way a client communicates with the DBMS (db server).
In oracle communication is established using Oracle Net Services which uses TNS protocol - [ Transparent Network Substrate (TNS) data stream protocol ] to communicate with the server. In SQL server it uses TDS protocol [ Tabular Data stream ] to communicate.
Add your answer:
Earn +20 pts
What are the characteristics of DBMS?
Database management system is full form of DBMS . Characteristics of a DBMS are following : 1) It maintains data integrity. 2) It reduces redundancy. 3) make access to data easy.
Who are actors on the scene in DBMS?
SOURCE: http://jeenuutreja.blogspot.in/2012/07/actors-on-scene-in-dbms-in-this-topic.htmlI'd copy paste this here but these guys have earned a visit!
What is structural database design?
The logic structure is independent of any kind of data model,in the practical application, the general database used by theenvironment has given (such as SQL Server or Oracel or MySQL. Due to the current use of the database basically is relational database, so the first thing to the E-R diagram into relation model, and then according to the characteristics andlimitations of specific DBMS conversion for the specificsupport of DBMS data model, the final optimization
Value set in DBMS?
Each simple attribute of an entity type is associated with a value set (or domain of values), which specifies the set of values that may be assigned to that attribute for each individual entity. If the range of ages allowed for employees is between 16 and 70, we can specify the value set of the Age attribute of EMPLOYEE to be the set of integer numbers between 16 and 70. Similarly, we can specify the value set for the Name attribute to be the set of strings of alphabetic characters separated by blank characters, and so on. Value sets are not displayed in ER diagrams, and are typically specified using the basic data types available in most programming languages, such as integer, string, Boolean, float, enumerated type, sub-range, and so on.
