what is the difference bet., MYSQL and ORACLE

Answer Posted / vikas kumar

1.Some syntactic differences between Mysql and Oracle.
2.Oracle is not open source mysql is open source database.
3.Mysql does not have a language such as PL/SQL, but
instead allows.
4.Mysql support auto increment function. Oracle does not
support auto increment function.
5.Oracle support sub queries. Mysql does not support sub
queries.
6.Mysql does not supports views, trigger, indexing,
sequence. Store procedure oracle support.
7.Oracle is generally use for much larger applications then
mysql.
8.Oracle requires much more setup and tuning then mysql.

Is This Answer Correct ?    21 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is branch testing and what is boundary testing?

841


hey, i recently attended 2 interviews and they asked whether I used qamonitor of softsmith. any help on what it does?

1542


What is exploratory testing and specification-driven testing?

651


What is difference between retesting and regression testing?

653


Describe bottom-up and top-down approach in testing?

674






What are the common problems with software automation?

611


Hi I have found a web site of online shopping (www.safetots.co.uk).PLEASE write possible "Test scenario" by seeing that site.Please make the end of mine and others doubt in Test scenario.Thanks in advance.

1555


What is negative testing? How is it different from positive testing?

622


Field level test cases are developed using AF TOD to validate individual fields on a screen using a black box testing methodology. IN THIS CONTEXT WHAT IS "AF TOD"

3016


What is the most critical bug you found in your latest project or overall in your career ?

5593


What if there is not enough time for thorough testing?

571


hi Can anyone tell me abt how to do the virtual objects and how to pass input and output parameters in qtp? Plz send the answer in detail. Thanks Priya

1511


We have a directory structure /usr/local/jboss/server/{$app_name}/log/*.log which contains 1000 log files. A web application has been logging to the cloud.log file, the attempts of a user called test. The code logs the following way: log.debug(username); where the username equals “test”. What command line application and or combinations of applications will you call in order to create a file named user_log.csv that contains the following lines, where the timestamp is sorted: timestamp,username

1758


Tell me in which of the software testing phase is qa involved & qc not involved?

618


What is the difference between quality assurance (qa) and quality control (qc)?

625