| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| suppose server is running Suddenly down . what can you do?
but i want do not down the server? | | 3 |
| What are the advantages of stored procedures, triggers,
indexes? | | 2 |
| How can increase the performance of MySQL select query? | Span-Systems | 2 |
| Which storage engines support transactions in MySQL? | | 1 |
| How can you do the fine tunning? | ACC | 3 |
| How many tables will create when we create table, what are
they? | | 2 |
| How do you control the max size of a HEAP table? | | 1 |
| what is JOIN? Give example & types of join? | iMedia | 8 |
| How can we change the name of a column of a table? | | 4 |
| How do you prevent MySQL from caching a query? | | 1 |
| Explain federated tables? | Tech-Mahindra | 2 |
| 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 |
| 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 |
| How many ways we can we find the current date using MySQL? | | 1 |
| Explain advantages of MyISAM over InnoDB? | | 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 |
| 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 are the different table present in MYsql? | | 2 |
| The structure of table view buyers is as follows:
+----------------+-------------+------+-----+---------+-----
-----------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-----
-----------+
| user_pri_id | int(15) | | PRI | NULL | auto_increment |
| userid | varchar(10) | YES | | NULL | |
+----------------+-------------+------+-----+---------+-----
-----------+
the value of user_pri_id the last row 2345 then What will
happen in the following conditions?
Condition1: Delete all the rows and insert another row
then. What is the starting value for this auto incremented
field user_pri_id ,
Condition2: Delete the last row(having the field value
2345) and insert another row then. What is the value for
this auto incremented field user_pri_id | | 2 |
| SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
| HCL | 3 |
| |
| For more MySQL Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
