0
Advantages:
- It allows for better quality data, as you restrict what data goes into a column or a table.
- It allows for data to be linked between tables, using foreign key constraints
Disadvantages:
- Takes a little longer to set up a table as the constraints need to be identified and added into the script.
Wiki User
∙ 8y ago
Wiki User
∙ 13y agoI have used Oracle software for over 12 years, I actually love the database software.
Two disadvantages if I had to give two would be:
1. Price, the single most expensive Enterprise Database Software on the market (but for a reason, IMHO it is the best).
2. Bulky software bundles. Most installations (sometimes 5-10 on one server) have similar tree structures, all containing the same java/perl/etc files, scripts. Most of them have not been changed since 9i. It would probably benefit from a central file system maybe, that all Oracle homes could share.
Wiki User
∙ 15y agoAnswering "Advantage and disadvantage of oracle dbms?"
Ashley Guerrero Ordo...
Add your answer:
Earn +20 pts
Who has the largest DBMS market share?
Oracle.
Name two of dominate DBMS vendors and their latest products please specify in which way they are the dominating DBMS vendor?
oracle, Microsoft, SyBase and oracle.
Advantage and disadvantage of data dase manage ment system?
Advantages of DBMS:Redundancies and inconsistencies can be reducedthe advanrage of DBMS is to help you in the future
What are the components of dbms in oracle?
I dont know :D
Default maxpipesize in DBMS PIPE in oracle?
81 92
What are advantages of rdbms over dbms?
Some advantages of relational database management systems (RDBMS) over traditional database management systems (DBMS) include data integrity through the use of constraints, normalization to reduce redundancy, support for ACID transactions, and standardized SQL language for data manipulation. RDBMS also offer scalability and flexibility for complex data structures and relationships.
Examples for dbms and rdbms?
My sql, Microsoft sql , Microsoft Access, dBase, Filemaker pro are the examples for dbms and oracle and sql server are the examples for rdbms
What is the advantage of an oracle?
The advantage of an oracle is its ability to use the centralized management system.
Sample of DBMS?
SAMPLE DBMS includes Oracle, DB2, MS Access, MS SQL SERVER, PostgreSQL, MySQL, Sybase.
What is a snapshot IN DBMS?
A DBMS snapshot in Oracle can also be referred to as a materialized view. Basically a snapshot is a refreshable view that can be refreshed on command or commit.
What are the advantage and disadvantage of fidelio?
What are the advantage and disadvantage of fidelio?"
List some dbms and rdms software?
The name of few DBMS are FOXPRO, MS-ACCESS, SQL Server, My SQL, ORACLE, etc.
