View note:Mysql-interview-questions-intermediate-



Questions of this subject!.

QuestionLikes!Dislikes!Answers!
1)How would you check if MySql service is running or not?

001
2) If the service is running/stop how would you stop/start the service?

001
3)How will you obtain list of all the databases?

001
4). How will you switch to a database, and start working on that?

000
5)how can we manage the MySQL server for their OLAP services?

000
6)Which is the best engine in MySQL

001
7)What are engines in MySQL

001
8)Which MySQL Datatype should be used for storing boolean values

001
9) What is referential Integrity

001
10)Which is better, a higher Normal Form or a lower Normal Form?

001
11)How do we scale a MySQL database

001
12) How would you shard a database in MySQL

001
13)Do we have to make changes in the application code to access shards?

000
14) Can we perform Join Operations on Shards?

001
15)Explain ACID properties

001
16)Describe Joins

001
17)Why should we use joins?

000
18)Define clauses in MySQL

000
19)What is the difference between INNER JOIN and LEFT JOIN?

001
20) What is the difference between LEFT JOIN and RIGHT JOIN

000
21). How should data be structured to facilitate JOIN clauses in a one-to-many relationship?

000
22)Can database be secured with MySql server

001
23)Can default port number vary from system to system

000
24)Write a SQL query to fetch only even rows from table.

001
25) Write a SQL query to create a new table with data and structure copied from another table.

001
26)Write a SQL query to create an empty table with same structure as some other table

001
27)Write a SQL query to fetch records that are present in one table but not in another table

001
28) Write a SQL query to fetch top n records?

001
29)Write SQL query to find the nth highest salary from table.

001
30)Write SQL query to find the 3rd highest salary from table without using TOP/limit keyword

001
31)Write an SQL Query to check whether date passed to Query is the date of given format or not.

001
32)Write an SQL Query to print the name of the distinct employee whose DOB is between 01/01/1960 to 31/12/1975.

000
33)Write an SQL Query to find an employee whose Salary is equal or greater than 10000.

001
34)Write an SQL Query to find the year from date.

001
35)There is a table which contains two column Student and Marks, you need to find all the students, whose marks are greater than average marks i.e. list of above average students.

000