Mysql interview question and answers | Mysql interview questions | Download Mysql interview Questions | Mysql Question | Mysql Technical Interview Questions and Answers| Mysql Questions.
1. What’s MySQL?
MySQL the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers, that builds its business by providing services around the MySQL database management system.
2. Why use the MySQL Database Server?
The MySQL Database Server is very fast, reliable, and easy to use. it is possible for anyone to use and modify the software. Anybody can download the MySQL software from the Internet and use it without paying anything.
3. What is the technical features of MySQL Server?
The MySQL Database Software is a client/server system that consists of a multi-threaded SQL server that supports different backends, several different client programs and libraries, administrative tools, and a wide range of application programming interfaces (APIs).
4. What are the column comparisons operators?
The = , ‹›, ‹=, ‹, ›=, ›,‹‹,››, ‹=›, AND, OR, or LIKE operators may be used in column comparisons to the left of the FROM in SELECT statements.
5. How do you get the number of rows affected by query?
SELECT COUNT (user_id) FROM users;
6. What are HEAP tables in MySQL?
HEAP tables are in-memory. They are usually used for high-speed temporary storage.
No TEXT or BLOB fields are allowed within HEAP tables.
You can only use the comparison operators = and ‹=›.
HEAP tables do not support AUTO_INCREMENT.
Indexes must be NOT NULL.
7. How do you return the a hundred books starting from 25th?
SELECT book_title FROM books LIMIT 25, 100;
8. How would you write a query to select all teams that won either 2, 4, 6 or 8 games?
SELECT team_name FROM teams WHERE team_won IN (2, 4, 6, 8).
9. What is the default port for MySQL Server?
The default port is 3306.
10. How would you select all the users, whose phone number is null?
SELECT user_name FROM users WHERE ISNULL(user_phonenumber);
0 comments:
Post a Comment