| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
| HCL | 3 |
| how to delete duplicate rows in sql server 2005? | Reliance | 1 |
| How do you start and stop MySQL on Windows? | | 2 |
| What are HEAP tables in MySQL? | | 1 |
| For the database from the previous question, please give an
SQL query which returns the invoice number of all invoices
which contain the article with the number ?1234?. The query
should be able to run under a MySQL 4.0 database. | | 1 |
| Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE
CURRENT_TIMESTAMP. | | 1 |
| How do you start MySQL on Linux? | | 3 |
| Explain federated tables? | Tech-Mahindra | 2 |
| what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage | ABC | 3 |
| Ondelete clause is specified with
a.)Drop table
b.)Delete command
c.)Create table
d.)Select command | AMDOC | 4 |
| What is the difference between mysql_fetch_array and
mysql_fetch_object? | CTS | 2 |
| Explain advantages of MyISAM over InnoDB? | | 1 |
| What is the maximum length of a table name, a database name,
or a field name in MySQL? | | 1 |
| about foregine | | 2 |
| What is the difference between GROUP BY and ORDER BY in
Sql? | Renault-Nissan | 4 |
| 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 |
| What are the other commands to know the structure of table
using MySQL commands except explain command? | SigmaTree | 2 |
| What is the difference between CHAR and VARCHAR data types? | | 1 |
| Give the syntax of GRANT commands? | | 1 |
| what is JOIN? Give example & types of join? | iMedia | 8 |
| |
| For more MySQL Interview Questions Click Here |
Site Map
