What are the advantages and disadvantages of DBMS-SQL

Questions by ddkdhar   answers by ddkdhar

Showing Answers 1 - 5 of 5 Answers

we use package DBMS_SQL to execute SQL statements dynamically, but wewant better performance, something easier to use, or functionality thatDBMS_SQL lacks such as support for objects and collections.

  Was this answer useful?  Yes


    it needs good skilled administrator. (disadvantage)

  
      This is a large database. we can use efficiently to store and retrieval of data.

              This is much security. (advantage)

  Was this answer useful?  Yes


Speed: MySQL is fast. The developers contend that MySQL is about the fastest database you can get. You can investigate this claim by visiting performance-comparison page on the MySQL Web site.

Ease of use: MySQL is a high-performance but relatively simple database system and is much less complex to set up and administer than larger systems.

  Was this answer useful?  Yes

stshekhar

  • Jun 22nd, 2008
 

Disadvantage :
1) Executing DDL statements through dbms_sql sometime can result in deadlock. example : we are trying to drop one object at the time it is being accessed by other user.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions