Skip to main content

MYSQL Interview question..



MySQL is an open source relational database management system RDBMS based on Structured Query Language SQL

MySQL runs on virtually all platforms, including Linux, Unix, Windows. Although it can be used in a wide range of applications, MySQL is most often associated with web-based applications and online publishing and is an important component of an open source enterprise.


1) What is SQL?

  • SQL stands for Structured Query Language.
  • SQL was initially developed at IBM in 1970s.
  • SQL is the standard language to communicate with relational database management systems like Oracle, MS Access, MS SQL Server, MySQL, DB2 etc.
  • It is used to connect the objects with the database.

2)what is the Purpose of SQL?

•SQL is used to Create New Databases.
• SQL is used to Create New Tables in a Database.
• SQL is used to Insert, update, Delete records in a Database.
• SQL is used to Retrieve data from a Database.
• SQL is used to execute queries against a Database.
• SQL can set permissions on tables, procedures and views.
• SQL is used to Create stored procedures in a Database.
• SQL is used to Create views in a Database.

3) Who should learn SQL?

Database Developers

• Design and deploy Database table structures, forms, reports and queries etc.

4)what is the subset of SQL?

DCL: Data Control Language.

DDL: Data Definition Language.

DML: Data Manipulation Language.

 5) What is DDL?

  • Create
  • Alter
  • Drop
  • Truncate
  • Rename

6)What is DCL?

  • Grant: It will access the database objects to the user
  • Revoke: It will remove user access rights database access 
  • Deny: It will deny the user Permission.

7)What is DML?

      *Select
      *Insert
      *Delete
      *Update   

8)what are the Joins in MySQL?       

  • Inner Join
  • Outer Join
  • Left Join
  • Right Join
  • Full Join

Comments

Post a Comment

Popular posts from this blog

Commonly asked Top 26 Java Interview Questions

1.what is a transient variable? A transient variable is a variable that may not be serialized. If you don't want to serialize any objects then we have to use Transient Keyword. 2. Why do threads block on I/O? Threads block on i/o (that enters the waiting state) so that other threads may execute while the i/o Operation is performed. So your blocked thread of execution blocks only that: the thread of execution. 3. How are Observer and Observable used? Objects that subclass the Observable class maintain a list of observers. When an Observable object is updated it invokes the update() method of each of its observers to notify the observers that it has changed state. The Observer interface is implemented by objects that observe Observable objects(refer 1.4). 4. What is synchronization and why is it important?                      With respect to multithreading, synchronization is the capability to control the...
Post a Comment
Read more

Decode of the image file from hibernate and struts

Create a java file for the decoding the image Image.java package com.img.action; import java.awt.image.BufferedImage; import java.io.ByteArrayOutputStream; import java.util.ArrayList; import java.util.Iterator; import java.util.LinkedHashMap; import java.util.List; import java.util.Map; import javax.imageio.ImageIO; import javax.servlet.ServletRequest; import javax.servlet.http.HttpServletRequest; import org.apache.struts2.ServletActionContext; import com.img.dao.ConnectionDAO; import com.img.pojo.Film_TablePojo; import com.img.pojo.imagePojo; import com.opensymphony.xwork2.ActionSupport; public class Show extends ActionSupport { List<Object> values = new ArrayList<Object>();  public List<Object> getValues() { return values; } public void setValues(List<Object> values) { this.values = values; } /*HttpServletRequest request;     public void setServletRequest(HttpS...
Post a Comment
Read more

Top Most Important Multithreading interview question and answers

1) What is Thread in java? Threads consumes CPU in best possible manner, hence enables multi processing. Multi threading reduces idle time of CPU which improves performance of application. Thread are light weight process. It belongs to java.lang package. It can run mutiple threads simutaneously .                                                               2) How to implements threads in java?         By   implementing java.lang.Runnable interface or extending java.lang.Thread class and then extending run method.   Thread creation by implementing java.lang.Runnable interface.      And then create Thread object by calling constructor and passing reference of Runnable interface i.e. runnable object          Thread threa...
Post a Comment
Read more