Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/purvgwtw/public_html/tutorials/common.php on line 7
MySQL Interview Questions & Answers
Sponsered Links
Categories
Sponsered Links

MySQL Interview Questions & Answers

 What is Primary Key?
A primary key is a single column or multiple columns is defined to have unique values that can be used as a row identifications.

What is Transaction?

MySQL server is introduced the transaction concept to allow users to group one or more SQL statements into a single transaction, so that the effects of all the SQL statements in a transaction can be either all committed or all rolled back. A transaction is a logical unit of work requested by a user to be applied to the database objects.

What are the indexes?

An index is an internal structure which is provided quick access to rows of a table based on the values of more than one columns.

What is a foreign key?

A foreign key is a constraint associates one or more columns in a table with an identical set of columns on which a primary key has been defined in another table. A foreign key may refer to the primary key of another table or same table.

What is the advantages of MySQL against oracle?

MySQL are many advantages in comparison to Oracle.

  1. MySQL is Open a source, which can be available any time
  2. MySQL has no cost of development purpose.
  3. MySQL has most of features , which oracle provides
  4. MySQL day by day updating with the new facilities.
  5. Good for small application.
  6. Easy to learn and to become master.
  7. MySQL has a good power these days.

Sponsered Links
Latest Updates
 
All Content of this site is for learning only. We do not warrant the correctness of its content. The risk from using it lies entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.
Copyright © 2014 PURVACOMPUTERS.COM All Right Reserved