One Stop GATE eBooks Guides Discussions Group

1 Message

Digest #1951

Top 50 MySql Interview Questions & Answers by "Janvi" a.maheshi

Message

1 Top 50 MySql Interview Questions & Answers

Fri Jul 4, 2014 9:48 pm (PDT) . Posted by:

"Janvi" a.maheshi

________________________________

MYSQL INTERVIEW QUESTIONS

Download Free Interview Questions eBook of 500 Questions

(If you do not have a Yahoo! account, you can get it by simply sending a blank email to CoolInterview-Subscribe@yahoogroups.com and confirm the verification email received. Once your email is confirmed, we will instantly send the download link to you.)
MYSQL Interview Questions
* What is SERIAL data type in MySQL?
http://www.coolinterview.com/interview/18109/

* What's the default port for MySQL Server?
http://www.coolinterview.com/interview/18094/

* Explain about database design?
http://www.coolinterview.com/interview/23218/

* What does "tee" command do in MySQL?
http://www.coolinterview.com/interview/18095/

* How to connect mysql from jsp(Java Server Page)?
http://www.coolinterview.com/interview/12633/

* What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
http://www.coolinterview.com/interview/18110/

* Explain the difference between MyISAM Static and MyISAM Dynamic
http://www.coolinterview.com/interview/18103/

* How to display nth highest record in a table for example?How to display 4th highest (salary) record from customer table?
http://www.coolinterview.com/interview/7761/

* How will retrieve nth level categories from one query in mysql ?
http://www.coolinterview.com/interview/18119/

* Which version of MySQL supports Subquery?
http://www.coolinterview.com/interview/18125/

* what is difference between candidate key and primary key
http://www.coolinterview.com/interview/18116/

* What does myisamchk do?
http://www.coolinterview.com/interview/18104/

* Can you save your connection settings to a conf file?
http://www.coolinterview.com/interview/18096/

* Describe the use of PL/SQL tables
http://www.coolinterview.com/interview/18132/

* How do you use Outer Join in MySQL
http://www.coolinterview.com/interview/18117/

* What are some good ideas regarding user security in MySQL?
http://www.coolinterview.com/interview/18102/

* How do you change a password for an existing user via mysqladmin?
http://www.coolinterview.com/interview/18097/

* Explain the difference between mysql and mysqli interfaces in PHP?
http://www.coolinterview.com/interview/18093/

* What is the Oracle rowid counterpart in MySQL?
http://www.coolinterview.com/interview/18118/

* Describe the use of %ROWTYPE and %TYPE in PL/SQL
http://www.coolinterview.com/interview/18130/

* What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?
http://www.coolinterview.com/interview/18115/

* State some security recommendations while using MYSQL?
http://www.coolinterview.com/interview/23217/

* Explain the difference between BOOL, TINYINT and BIT.
http://www.coolinterview.com/interview/18111/

* Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
http://www.coolinterview.com/interview/18114/

* Explain about MYSQL and its features?
http://www.coolinterview.com/interview/23207/

* When is a declare statement needed ?
http://www.coolinterview.com/interview/18133/

* How to see the database architecture in MySQL??
http://www.coolinterview.com/interview/18126/

* How do you start and stop MySQL on Windows?
http://www.coolinterview.com/interview/18091/

* What are the advantages of mysql comparing with oracle?
http://www.coolinterview.com/interview/18120/

* State two considerations which can improve the performance of MYSQL?
http://www.coolinterview.com/interview/23224/

* What Is "mysqladmin" in MySQL?
http://www.coolinterview.com/interview/39310/

* How To Create a New View in MySQL?
http://www.coolinterview.com/interview/39395/

* Use mysqldump to create a copy of the database?
http://www.coolinterview.com/interview/18098/

* What are the advantages of Mysql comparing with oracle?
http://www.coolinterview.com/interview/7762/

* how to add video or audio file database
http://www.coolinterview.com/interview/42952/

* Explain about the rules which should be followed while assigning a username?
http://www.coolinterview.com/interview/23215/

* State some of the features of MYSQL?
http://www.coolinterview.com/interview/23210/

* How to create MYSQL new users?
http://www.coolinterview.com/interview/23214/

* Explain about normalization?
http://www.coolinterview.com/interview/23223/

* How we can count duplicate entery in particular table against Primary Key ? What are constraints?
http://www.coolinterview.com/interview/7763/

* How many drivers in MYSQL?
http://www.coolinterview.com/interview/18122/

* Write a C/C++ program to add a user to MySQL. The user should be permitted to only "INSERT" into the given database.
http://www.coolinterview.com/interview/43880/

* What happens if a table has one column defined as TIMESTAMP?
http://www.coolinterview.com/interview/18112/

* How do you control the max size of a HEAP table?
http://www.coolinterview.com/interview/18106/

* How To Drop an Existing View in MySQL
http://www.coolinterview.com/interview/39396/

* How do you start MySQL on Linux?
http://www.coolinterview.com/interview/18092/

* Explain some of the uses of MYSQL?
http://www.coolinterview.com/interview/23209/

* What packages (if any) has Oracle provided for use by developers?
http://www.coolinterview.com/interview/18131/

* What are HEAP tables in MySQL?
http://www.coolinterview.com/interview/18105/

* What happens when we don't use Console option?
http://www.coolinterview.com/interview/23213/