Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Practice InterviewNew Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

MySQL Interview Questions and Answers

Ques 21. Explain what Is MySQL?

Ans. MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. MySQL has the following main features:

* Works on many different platforms.
* APIs for C, C++, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl are available.
* Fully multi-threaded using kernel threads. It can easily use multiple CPUs if they are available.
* Provides transactional and non-transactional storage engines.
* Uses very fast B-tree disk tables (MyISAM) with index compression.
* A very fast thread-based memory allocation system.
* Very fast joins using an optimized one-sweep multi-join.
* In-memory hash tables, which are used as temporary tables.
* SQL functions are implemented using a highly optimized class library and should be as fast as possible. Usually there is no memory allocation at all after query initialization.
* The server is available as a separate program for use in a client/server networked environment. It is also available as a library that can be embedded (linked) into standalone applications. Such applications can be used in isolation or in environments where no network is available.

Is it helpful? Add Comment View Comments
Ques 22. How To Install MySQL?
Ans. MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. You can download a copy and install it on your local computer very easily. Here is how you can do this:

* Go to http://dev.mysql.com/downloads/mysql/5.1.html.
* Select the "Windows" and "Without installer" version.
* Find a mirror site and download "mysql-noinstall-5.1.50-win32.zip".
* Unzip the file, you will get a new sub-directory, ".mysql-5.1.50-win32".
* Move and rename this sub-directory to mysql.
* The installation is done and your MySQL server is ready.
Is it helpful? Add Comment View Comments
Ques 23. How To Start MySQL Server?
Ans. If you want to start the MySQL server, you can run the "mysqld" program in a command window as shown in the following tutorial:

>cd mysqlbin >mysqld

"mysqld" will run quietly without printing any message in you command window. So you will see nothing after entering the "mysqld" command. You should trust "mysqld" and believe that MySQL server is running ok on your local computer now.

Another way to start the MySQL server is double-click mysqlbinmysqld.exe on your file explorer window.
Is it helpful? Add Comment View Comments
Ques 24. How Do You Know If Your MySQL Server Is Alive?
Ans. If you want to know whether your MySQL server is alive, you can use the "mysqladmin" program in a command window as shown in the following tutorial:

>cd mysqlbin >mysqladmin -u root ping mysqld is alive

The "mysqld is alive" message tells you that your MySQL server is running ok. If your MySQL server is not running, you will get a "connect ... failed" message.
Is it helpful? Add Comment View Comments
Ques 25. How Do You Know the Version of Your MySQL Server?
Ans. If you want to know the version number of your MySQL server, you can use the "mysqladmin" program in a command window as shown in the following tutorial:

>cd mysqlbin
>mysqladmin -u root version
mysqladmin Ver 8.41 Distrib 5.0.24, for Win32 on ia32
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB ...
Server version 5.0.24-community

Protocol version 10

Connection localhost via TCP/IP

TCP port 3306

Uptime: 25 min 9 sec

Threads: 1 Questions: 2 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.001

The output in the above example tells you that the version number is 5.0.24.
Is it helpful? Add Comment View Comments

Most helpful rated by users:

©2020 WithoutBook