| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to get full name of monthname ? | | 3 |
| How MySQL is different from SQL? | HCL | 14 |
| What happens if a table has one column defined as TIMESTAMP? | | 1 |
| The table tbl_sites contains the following data:
-----------------------------------------------------
Userid sitename country
------------------------------------------------------
1 sureshbabu indian
2 PHPprogrammer andhra
3 PHP.net usa
4 PHPtalk.com germany
5 MySQL.com usa
6 sureshbabu canada
7 PHPbuddy.com pakistan
8. PHPtalk.com austria
9. PHPfreaks.com sourthafrica
10. PHPsupport.net russia
11. sureshbabu australia
12. sureshbabu nepal
13. PHPtalk.com italy
Write a select query that will displayed the duplicated
site name and how many times it is duplicated? | Afixi | 3 |
| Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP . | Zensar | 2 |
| Explain the difference between mysql and mysqli interfaces
in PHP? | | 3 |
| How would you backup and restore a big MySQL database? What
are the advantages of the approach which you have taken
over the others? | | 2 |
| What is maximum size of a database in MySQL? | V2-Solutions | 9 |
| What happens when the column is set to AUTO INCREMENT and
you reach the maximum value for that table? | | 1 |
| Can you save your connection settings to a conf file? | | 1 |
| How many tables will create when we create table, what are they? | | 3 |
| i made a table in sql server 2000 and in a column i want to
add image path of a picture present in my hardisk... so
using insert statement how will i insert the path of the
image in the table?? | WebTech | 1 |
| please give me the answer for this:
query which generates the second highest integer in the table? | | 4 |
| How many values can the SET function of MySQL take? | Creative-Informatics | 2 |
| What is the difference between mysql_fetch_array and
mysql_fetch_object? | CTS | 2 |
| Please suggest me any course and institute which provide
training on the below skills.
• Knowledge of data extraction concepts and tools
• QMF (query management facility)queries
• Experience and expertise in QMF queries
• Excellent ability to write, read, and interpret QMF
queries against the Source Data Warehouse base level (daily
and monthly) and month-end affinity comp tables
• RDBMS & ER
• Knowledge of Relational Databases (RDBMS) and
Entity Relationship (ER) Diagrams
• SOURCE Data Warehouse
• Experience and expertise in Source Data Warehouse
or data warehouses on the mainframe.
• MS SQL Server
• Experience in MS SQL Server
• Excellent skill in writing/interpreting SQL queries
and running Data Transformation Services (DTS) or open
query packages.
• Knowledge of writing/interpreting Visual Basic code.
| | 1 |
| what is the Dynamic management views? where can you use? | ACC | 1 |
| What is SERIAL data type in MySQL? | | 2 |
| What is the difference between mysql_connect() and
mysql_pconnect()? | | 3 |
| What is the maximum length of a table name, database name,
and fieldname in MySQL? | TISL | 1 |
| |
| For more MySQL Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
