| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is ACID? | | 2 |
| What is the difference between char and varchar data types? | | 3 |
| in a master-master replication with two masters and
alternate slaves running on two systems.can i have a script
or any mysql command to know which one is right now acting
as master. | | 1 |
| How can we know the number of days between two given dates
using MySQL? | Webworks | 2 |
| What does myisamchk do? | | 1 |
| A company wants to store their invoices in a database. They
already have their customers and articles in that database.
Both customer and article are each identified by an unique
integer value. Please create the SQL statements for
creating the necessary table(s) for storing the invoices in
a MySQL database. An invoice should hold information like
invoice number, customer, date, article(s) and quantity
etc. | | 1 |
| What is the difference between CHAR and VARCHAR data types? | | 1 |
| How do you start and stop MySQL on Windows? | | 2 |
| How do you index just the first four bytes of the column? | | 2 |
| What are the other commands to know the structure of table
using MySQL commands except explain command? | SigmaTree | 2 |
| How MySQL is different from SQL? | HCL | 14 |
| how to delete duplicate rows in sql server 2005? | Reliance | 1 |
| Explain the difference between FLOAT, DOUBLE and REAL. | | 3 |
| What is the difference between mysql_fetch_array and
mysql_fetch_object? | CTS | 2 |
| Use mysqldump to create a copy of the database? | | 1 |
| Which one of the following is the correct way to select all
columns and all rows from "vtable"?
Choice 1
SELECT FROM vtable SELF JOIN vtable
Choice 2
SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = *
Choice 3
SELECT EVERYTHING FROM vtable
Choice 4
SELECT vtable.* WHERE vtable = vtable
Choice 5
SELECT * FROM vtable WHERE 1 = 1 | | 3 |
| Explain federated tables? | Tech-Mahindra | 2 |
| What is SERIAL data type in MySQL? | | 2 |
| what is JOIN? Give example & types of join? | iMedia | 8 |
| Explain multi-version concurrency control in MySQL? | | 2 |
| |
| For more MySQL Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
