Make MySql Interview Questions

View: 437    Dowload: 0   Comment: 0   Post by: hanhga   Category: Php&mySql   Fields: Other

MySql is one of the most used open-source database. In this article, i try to cover some of the most asked mysql interview questions. In my previous post i published PHP MCQ for Practice.

MySql Interview Questions

1Difference between Primary key and Unique Key ?

Answer – Both primary and unique is used to identify the rows uniquely. Here are some important differences.

i) Primary key cannot be null as compared to unique key which can be null for at least one value.
ii) In a table you can declare only one primary key, but unique keys can be multiple.
iii)In case of primary key clustered index is created, whereas Non-Clustered index is created in case of unique key.

2. What’s the difference between MyISAM and InnoDB storage engines.

Answer- MySql supports several storage engines out of which MyISAM and InnoDB are mostly used.

Check Complete Explanation.

3. How to create index in mysql and what are it’s advantage ?

Answer – Syntax for creating index in MySql

1
CREATE INDEX index_name ON table_name (column_name);

Let’s say i am creating index on salary column of employee table

create index salary_indx on employee (salary);

Advantage of Indexes-

It speeds up the search. Means when you query some data it will find the result very quickly.

4. What are the disadvantages of creating an index ?

Answer – i) Slower writes – Means your insert and update statement run slow.

ii) Takes more disk space.

5. How to select unique rows ?

Answer – Using distinct keyword in mysql, you can select unique rows.

select distinct fieldname from table_name;

6. How to sort the record in ascending or descending order in MySql.

Answer – Using order by with asc for ascending and desc for descending.

To select rows in ascending order

select * from table_name order by field_name asc;

Ex- suppose i have to show the result of an employee, from lowest to highest salary.

select * from employee order by salary asc;

To select rows in descending order

select * from table_name order by field_name desc;

7. How to select 100th record of a table.

select * from table_name limit 99,1;

8. Given a table products and product_review. Select the product name whose review is given by user.

+------+-----------------+---------+---------------------+
| p_id | p_name          | p_price | p_created           |
+------+-----------------+---------+---------------------+
|    1 | Dell Backpack   |     324 | 2014-07-09 17:55:40 |
|    2 | The White Tiger |     348 | 2014-07-01 17:55:40 |
|    3 | Iphone 5s       |   40000 | 2014-07-08 00:00:00 |
+------+-----------------+---------+---------------------+

Table Name – products_review

+------+-------------------+
| p_id | review            |
+------+-------------------+
|    2 | Excellent product |
|    3 | Amazing           |
+------+-------------------+

Here we have to fetch the record from two tables. In this case we need to use Join.

select p.p_name from products p inner join product_review pr on p.p_id=pr.p_id;
 
+-----------------+
| p_name |
+-----------------+
| The White Tiger |
| Iphone 5s |
+-----------------+

9. Default port on which MySql is running.

Answer Default for MySql is 3306.

To check the setting, open my.cnf file.

10. What’s the difference between inner join and left join.

Answer – Joins are used when we want to fetch data for more than one table.

Make MySql Interview Questions

MySql is one of the most used open-source database. In this article, i try to cover some of the most asked mysql interview questions. In my previous post i published PHP MCQ for Practice.

Posted on 06-10-2016 

Comment:

To comment you must be logged in members.

Files with category

  • SimpleXML is a PHP extension that allows us to easily manipulate and get XML data

    SimpleXML is a PHP extension that allows us to easily manipulate and get XML data

    View: 308    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    SimpleXML provides an easy way of getting an element's name, attributes and textual content if you know the XML document's structure or layout. SimpleXML turns an XML document into a data structure you can iterate through like a collection of arrays...

  • How to use the PHP download file script? Class Download PHP

    How to use the PHP download file script? Class Download PHP

    View: 186    Download: 1   Comment: 0

    Category: Php&mySql     Fields: Other

    This is my favorite PHP download script. I’ve used a different more simple method until a client wanted to be able to allow their site visitors to download a large file from a password protected directory. The PHP script works on Apache web servers...

  • Installing OCI8 & PHP 7.2 on RHEL or CentOS 6

    Installing OCI8 & PHP 7.2 on RHEL or CentOS 6

    View: 319    Download: 0   Comment: 0

    Category: Php&mySql     Fields: Other

    You’ll need to stop Apache (web server) using the following command. In any Linux commands I show in this article, it presumes you aren’t logged in as the root user, so you will need to use sudo to issue privileged commands.

  • PHP source code: get content of google search

    PHP source code: get content of google search

    View: 268    Download: 2   Comment: 0

    Category: Php&mySql     Fields: Other

    How to get the results of google search and display on your website. This PHP code can do that. Refer to the following code.

  • PHP as a Scripting Language for C#

    PHP as a Scripting Language for C#

    View: 201    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    When creating .NET applications (including desktop and web applications), it may be useful to allow extending the application using some scripting language. The users of the application can write simple scripts to configure the application, modify...

  • How to Picking the Brains of Your Customers with Microsoft’s Text Analytics

    How to Picking the Brains of Your Customers with Microsoft’s Text Analytics

    View: 4285    Download: 0   Comment: 0

    Category: Php&mySql     Fields: Other

    With the explosion of machine learning services in recent years, it has become easier than ever for developers to create “smart apps”. In this article, I’ll introduce you to Microsoft’s offering for providing machine-learning capabilities to apps.

  • How to MySqli Tutorial PHP MySqli Extension

    How to MySqli Tutorial PHP MySqli Extension

    View: 596    Download: 0   Comment: 0

    Category: Php&mySql     Fields: Other

    PHP provides three api to connect mysql Database.

  • Make Laravel Artisan Commands

    Make Laravel Artisan Commands

    View: 552    Download: 0   Comment: 0

    Category: Php&mySql     Fields: Other

    Artisan is the command line tool used in Laravel framework. It offers a bunch of useful command that can help you develop application quickly. Apart from Artisan available commands, you can create your own custom commands to improve your workflow.

 
File suggestion for you
File top downloads
Codetitle - library source code to share, download the file to the community
Copyright © 2018. All rights reserved. codetitle Develope by Vinagon .Ltd