| 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 happens when the column is set to AUTO INCREMENT and
you reach the maximum value for that table? | | 1 |
| about foregine | | 2 |
| How many tables will create when we create table, what are
they? | | 2 |
| What are the differences between drop a table and truncate
a table? | | 6 |
| SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
| HCL | 3 |
| What is SERIAL data type in MySQL? | | 2 |
| Explain MySQL locks? | | 1 |
| Explain the difference between FLOAT, DOUBLE and REAL. | | 3 |
| How can we find the number of rows in a table using MySQL? | | 1 |
| SQL:
1. Write a queryto retrieve the author who was
published a book at the youngest age?
2. write a query to retrieve the no. of books
published a each year in various languages?
3. write a query to retrieve no. of books published by
them only those authors who have published more than 1 book?
4. write a query to retrieve who has not published any
books during the year 2006?
5. write a query to retrieve the authors who has
published any books during the birth date write this query
in 2 ways 1)joins 2)sub query
6. write a query to retrieve all the books which was
published during jan 2007 & title containing India or
published in the language hindi?
1. table name is liberary managemnt and two column is
there one is authors and another one is books .
2.four fields will comes under authours like nationality,
birthdate ,first-language,second-language
3.four fields will comes under books like
authour,title ,language,publish date to write query using
this details | Covansys | 3 |
| Use mysqldump to create a copy of the database? | | 1 |
| please give me the answer for this:
query which generates the second highest integer in the table? | | 4 |
| Give the syntax of GRANT commands? | | 1 |
| Explain federated tables? | Tech-Mahindra | 2 |
| what are the optimization techniques for
Query optimization
performance issues and
faster execution of queries | | 1 |
| How do you prevent MySQL from caching a query? | | 1 |
| 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 MySQL optimization? | | 1 |
| What is maximum size of a database in MySQL? | V2-Solutions | 9 |
| |
| For more MySQL Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
