| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 if you really want to store the timestamp data, such
as the publication date of the article? | | 2 |
| How to load data from a text file into a table? | Sasaa | 4 |
| How can you do the fine tunning? | ACC | 3 |
| how we can use more then one primary key in Single Table | Systematix | 8 |
| What is the maximum length of a table name, database name,
and fieldname in MySQL? | TISL | 1 |
| How many ways we can we find the current date using MySQL? | | 1 |
| how to display only 4 records from a table based on a
condition
for ex
i have a table called products
in that nid,prodname are fields
i want to display only any 4 records of perticular product
plz tell me | | 4 |
| How to find out the second largest element from mysql table | | 11 |
| What is the difference between CHAR and VARCHAR data types? | | 1 |
| What?s the difference between query_cache_type 1 and 2? | | 1 |
| What are the different table present in MYsql? | | 2 |
| Fname Lname City Pin
ramesh kumar salem 365241
Query to generate a code having the firstletter of
Fname,Lname & 3letter of city Last 3letter of pin,all in
capital letters
| | 1 |
| Explain the difference between FLOAT, DOUBLE and REAL. | | 3 |
| How to get full name of monthname ? | | 3 |
| 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 |
| A select query over a large table runs very slow because of
the growing number of entries in that table. What different
measures could be taken to improve speed? | | 3 |
| What are some good ideas regarding user security in MySQL? | | 2 |
| Explain the difference between BOOL, TINYINT and BIT? | | 1 |
| How many tables will create when we create table, what are they? | | 3 |
| |
| For more MySQL Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
