MySQL Stored procedure interview Questions and Answer

Question: What is stored procedure?
A stored procedure is Structured Query Language (SQL) statements which has a name, a parameter list, and SQL statement(s) stored in MySQL Server.



Question: Give example of stored procedure?

DELIMITER $$
CREATE PROCEDURE getUsersAscending()
BEGIN
	SELECT 
		first_name, 
		last_name, 
		email
	FROM
		users
	ORDER BY first_name;    
END$$
DELIMITER ;

Question: Give example of stored procedure with parameter details?

DELIMITER $$
CREATE   PROCEDURE `getUsersDetails`(IdSearch INT)    
    BEGIN
	SELECT 
		first_name, 
		last_name, 
		email
	FROM
		users
	WHERE id=IdSearch;      

    END$$
DELIMITER ;

Question: To show all stored procedures:

SHOW PROCEDURE STATUS;

Question: How to show stored procedures in a specific database

SHOW PROCEDURE STATUS WHERE Db = 'db_name';

Question: MySQL stored procedures advantages?

1. Reduce network traffic
2. Make database more secure

Question: MySQL stored procedures dis-advantages?

1. Resource usages: If you use many stored procedures, the memory usage of every connection will increase substantially.
2. Troubleshooting:MySQL does not provide any facilities to debug stored procedures like other enterprise database products such as Oracle and SQL Server
3. Maintenances Developing and maintaining stored procedures often requires a specialized skill set that not all application developers possess.

Question: How to call stored procedure with OR without arguments?
Call without argument

call getUsersAscending();

Call With argument

call getUsersDetails(10);

Question: How to delete the procedure?

DROP PROCEDURE IF EXISTS getUsersAscending;

Question: What if i am trying to delete the stored procedure for non-exist.?
It will give warning only, if you have used "IF EXISTS"
It will give Error, if you have used not used "IF EXISTS"


Question: How to Alter a stored procedure in mysql?
1: Delete the Stored procedure. 

2: Re-Create the Stored procedure.

AWS Elastic Beanstalk Interview Questions and Answers

Question: What is Elastic Beanstalk in AWS?
AWS Elastic Beanstalk is End-to-end web application management.


Question: Can we use Elastic beanstalk to deploy the web application which is made in Node OR PHP?
Yes, AWS Elastic Beanstalk is service for deploying and scaling web applications and services developed with Java, .NET, PHP, Node.js, Python, Ruby, Go, and Docker on familiar servers such as Apache, Nginx, Passenger, and IIS.


Question: How does works Elastic Beanstalk?
You simply upload your code and Elastic Beanstalk automatically handles the deployment, from capacity provisioning, load balancing, and automatic scaling to web application health monitoring, with ongoing fully managed patch and security updates.


What are Benefits and features of Elastic Beanstalk?

1. Easy to get started
   Elastic Beanstalk is the simplest way to deploy and run your web application on AWS.
2. Complete resource control
   You have the freedom to select the AWS resources, such as Amazon EC2 instance types, that are optimal for your web application.
3. Fully managed: update your web application with the latest platform security and patch updates.
4. Automatic application health monitoring
   Elastic Beanstalk automatically collects more than 40 key metrics and attributes to determine the health of your web application

Question: What Language Supported by Elastic Beanstalk

1. Go
2. Java SE
3. Java with Tomcat
4. NET on Windows Server with IIS
5. Node.js
6. PHP
7. Python
8. Ruby
9. Packer Builder

Question: How is AWS CloudFormation different from AWS Elastic Beanstalk?
AWS CloudFormation helps you provision and describe all of the infrastructure resources that are present in your cloud environment. On the other hand, AWS Elastic Beanstalk provides an environment that makes it easy to deploy and run applications in the cloud.
AWS CloudFormation supports the infrastructure needs of various types of applications, like legacy applications and existing enterprise applications. On the other hand, AWS Elastic Beanstalk is combined with the developer tools to help you manage the lifecycle of your applications.



Question: Who should use AWS Elastic Beanstalk?
Those who want to deploy and manage their applications within minutes in the AWS Cloud. You don’t need experience with cloud computing to get started. AWS Elastic Beanstalk supports Java, .NET, PHP, Node.js, Python, Ruby, Go, and Docker web applications.