GeekInterview.com
Series: Subject: Topic:
Question: 242 of 490

What are the advantages and disadvantages of DBMS-SQL

Asked by: ddkdhar | Member Since Jun-2006 | Asked on: Mar 1st, 2007

View all questions by ddkdhar   View all 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.

  
Login to rate this answer.

    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)

  
Login to rate this answer.

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.

  
Login to rate this answer.
stshekhar

Answered On : Jun 22nd, 2008

View all answers by stshekhar

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.

  
Login to rate this answer.
neerajalatha

Answered On : Jul 7th, 2010

View all answers by neerajalatha

Disadvantages:It is slow when compared to native dynamic SQL and coding is also difficult when compared to native dynamic SQL.

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.