Windows Azure Interview Questions

1. What is cloud computing?
http://azurelearning.blogspot.in/2013/01/what-is-cloud-computing.html 

2. What are the three types of roles in Compute component in Windows Azure?
Web, Worker and VM.
Web and worker roles are essentially same except that web roles have IIS enabled on them.

http://stackoverflow.com/questions/7118942/in-windows-azure-what-are-web-role-worker-role-and-vm-role
http://www.techrepublic.com/blog/networking/windows-azure-web-worker-and-vm-roles-demystified/4017
http://blogs.msdn.com/b/silverlining/archive/2012/06/27/windows-azure-websites-web-roles-and-vms-when-to-use-which.aspx


3. Difference between Web and Worker Roles in Windows Azure?
The main difference between the two is that an instance of a web role runs IIS, while an instance of a worker role does not. Both are managed in the same way, however, and it's common for an application to use both.For example, a web role instance might accept requests from users, then pass them to a worker role instance for processing.


4. What is Azure Fabric Controller?
The Windows Azure Fabric Controller is a resource provisioning and management layer that manages the hardware, and provides resource allocation, deployment/upgrade, and management for cloud services on the Windows Azure platform. 
http://blogs.msdn.com/b/windowsazure/archive/2013/01/16/details-of-the-december-28th-2012-windows-azure-storage-disruption-in-us-south.aspx
http://searchcloudcomputing.techtarget.com/definition/Windows-Azure-Fabric-Controller
http://www.cooper.fi/2013/05/understanding-windows-azure-fabric-controller-error-handling-model/


5. What is AutoScaling?
Scaling by adding additional instances is often referred to as scaling out. Windows Azure also supports scaling up by using larger role instances instead of more role instances.
By adding and removing role instances to your Windows Azure application while it is running, you can balance the performance of the application against its running costs.
An autoscaling solution reduces the amount of manual work involved in dynamically scaling an application.
 http://msdn.microsoft.com/en-us/library/hh680945(v=pandp.50).aspx
http://www.windowsazure.com/en-us/develop/net/how-to-guides/autoscaling/


6. Difference between Block and Page BLOBs.

http://msdn.microsoft.com/en-us/library/windowsazure/ee691964.aspx
https://sites.google.com/a/cloudenablers.com/blog/windowsazure/block-blob-page-blob
http://shayyannay.wordpress.com/2012/04/16/understanding-block-blobs/

7. Why should you use Windows Azure Storage as opposed to Local Resources/Storage?


8. Difference between VM role and Virtual Machines on Windows Azure Offerings.

9. Difference between IAAS, PAAS and SAAS.
http://apprenda.com/library/paas/iaas-paas-saas-explained-compared/
http://www.networkworld.com/news/2011/102511-tech-argument-iaas-paas-saas-252357.html

10. Difference between Azure Storage Tables and Azure SQL Database.

11. Difference between On-Premise SQL Server and Azure SQL Database.

12. Limitations on Azure SQL Database.



http://msdn.microsoft.com/en-us/library/windowsazure/ff394102.aspx
http://msdn.microsoft.com/en-us/library/windowsazure/ee336245.aspx

13. Explain the Billing model for Windows Azure.
http://blogs.msdn.com/b/windowsazure/archive/2010/02/22/windows.aspx
http://www.windowsazure.com/en-us/support/contact/

14. Explain Windows Azure Cloud Service Lifecycle.
http://msdn.microsoft.com/en-us/library/windowsazure/hh127476.aspx
http://www.azurecloudpro.com/the-windows-azure-service-life-cycle/

15. Difference between Windows Server AppFabric and Windows Azure AppFabric

16. Difference between Vertical and Horizontal scaling
http://stackoverflow.com/questions/5401992/what-does-scale-horizontally-and-scale-vertically-mean
http://singinghorsestudio.com/horizontal-vs-vertical-scaling/
http://social.msdn.microsoft.com/Forums/en-US/architecturegeneral/thread/0e47ddf3-4505-4943-95cc-1bc1af26197a
http://en.wikipedia.org/wiki/Scalability#Horizontal_and_vertical_scaling


17. How to manage/handle Session support on Windows Azure compute environment

18. Difference between Azure storage Queues and Azure Service Bus Queues.


For more details
Azure Learning Resources: http://azurelearning.blogspot.com

SQL Server Interview Questions and Answers

Links to External Sites


SQL Interview Q & A

Top 10 Developer Interview Questions About SQL Server

Top 10 SQL Server DBA Interview Questions

SQL Interview Questions

SQL Server Interview Questions and Answers

SQL Azure Interview Questions

1. What is SQL Azure?

2. What is cloud computing?

3. How is SQL Azure different than SQL server?

4. How many replicas are maintained for each SQL Azure database?

5. How can we migrate from SQL server to SQL Azure?

6. Which tools are available to manage SQL Azure databases and servers?

7. Tell me something about security and SQL Azure.

8. What is SQL Azure Firewall?

9. What is the difference between web edition and business edition?

10. How do we synchronize On Premise SQL server with SQL Azure?

11. How do we Backup SQL Azure Data?

12. What is the current pricing model of SQL Azure?

13. What is the current limitation of the size of SQL Azure DB?

14. How do you handle datasets larger than 50 GB?

15. What happens when the SQL Azure database reaches Max Size?

16. How many databases can we create in a single server?

17. How many servers can we create in a single subscription?

18. How do you improve the performance of a SQL Azure Database?

19. What is code near application topology?

20. What were the latest updates to SQL Azure service?

21. When does a workload on SQL Azure get throttled?

For answers, please refer: http://blog.sqlauthority.com/2011/07/25/sql-server-azure-interview-questions-and-answers-guest-post-by-paras-doshi-day-25-of-31/ 

Ref: http://parasdoshi.com/2011/07/26/sql-azure-interview-questions-and-answers-guest-blog-on-pinal-sirs-blog/ 

PHP Interview Questions

1.What are the differences between require and include, include_once?
2.What is the difference between $message and $$message
3.What is the difference between echo and Print?
4. $i = 0123; echo $i; What is the output?
5.How to differentiate isset and empty?
6.What are magic quotes in PHP?
7.How to execute a PHP script using command line?
8.What is the difference between urlencode and urldecode?
9.What is the difference between unlink and unset?
10.How are the different ways to store values in session?
11.What are the ways we can destroy a session variable?
12.What Is a Persistent Cookie?
13.How do you maintain session in a load balancing system?
14.How many ways can we get the value of current session id?
15.How can we destroy the session, how can we unset the variable of a session?
16.How can we destroy the cookie?
17.How many ways we can pass the variable through the navigation between the pages?
18.What is meant by nl2br()?
19.Why is LAMP popular?
20.How can we encrypt password using PHP?
21.What are the differences between public, private, protected access modifiers?
22.What are the different types of errors in PHP?
23.What is the functionality of the function strstr and stristr?
24.What is the use of the function htmlentities()?
25.How can we convert the time zones using PHP?
26.How can we get the properties (size, type, width, height) of an image using PHP image functions?
27.How can we get the browser properties using PHP?
28.What is the maximum size of a file that can be uploaded using PHP and how can we change this?
29.How can we increase the execution time of a PHP script?
30.What are the differences between GET and POST methods in form Submission?
31.What is the use of header() function in php
32.How to upload files using PHP?
33.How will you create a bi-lingual site (multiple languages) in PHP?
34.In what are the ways you can encrypt the password?
35.How can we know the number of days between two given dates using PHP?
36.How to convert a timezone from one to another?
37.How to get seconds from current date using date function
38.What is the difference between ereg_replace and eregi_replace?
39.Write a regular expression to get the value xxx from the string 'xxx@abc.com'
40.What is the difference between ereg_replace() and eregi_replace()?
41.How to get the URL domain name in PHP?
42.What are the different functions in sorting an array?
43.How can we know the count/number of elements of an array?
44.How can we create a database using PHP and mysql?
45.What are the different ways we can retrive the mysql results using php ? Explain each
46.What is the difference between mysql_fetch_object and mysql_fetch_array?
47.In how many ways we can retrieve the date in the result set of mysql using PHP?
48.Explain the difference between mysql and mysqli interfaces in PHP?
49.What is difference between mysql_fetch_array(), mysql_fetch_row() and mysql_fetch_object()?
50.What is differenc between mysql_connect and mysql_pconnect?
51.What is the PHP predefined variable that tells the What types of images that PHP supports?
52.How can I make a script that can be bilanguage (supports English, Spanish, French)?
53.What are the difference between abstract class and interface?
54.Is it possible to serialize private properties?
55.What is $GLOBALS['GLOBALS']?
56.How can maintain a hit counter in PHP?
57.How I can get IP address of the user viewing the webpage?
58.How to check that user is logged in or not?
59.List out the predefined classes in PHP
60.Is Inheritance supported in PHP?
61.What are the new features in PHP6?
62.How to send email using PHP?
63.What is PEAR?
64.What is PECL?
65.What are the different ways to parse XML in PHP?

MySQL Interview Questions

1.Define candidate key, alternate key, composite key?
2.What is the difference between Primary Key and Unique Key?
3.Difference between clustered and non clustered index
4.Difference between HAVING and WHERE clause
5.Explain Normalization and De-normalization
6.What is the difference between inner join and outer join?
7.Which will be faster out of queries with explicit INNER JOIN and implicit one?
8.How to create Indexes in MySQL?
9.How to remove duplicate records from a table?
10.Is it possible to remove a column from a table?
11.How to rename a table in MySQL?
12.Is it possible to do a FULL OUTER JOIN in MySQL?
13.How do you start and stop MySQL on Windows?
14.How do you start MySQL on Linux?
15.What’s the default port for MySQL Server?
16.How do you change a password for an existing user via mysqladmin?
17.How to backup a database in MySQL?
18.Different table types in MySQL?
19.How to repair a MYISAM table?
20.Explain advantages of InnoDB over MyISAM?
21.Explain advantages of MyISAM over InnoDB?
22.What are HEAP tables in MySQL?
23.What are CSV tables?
24.Explain federated tables.
25.If you specify the data type as DECIMAL (5,2), what’s the range of values that can be stored in this table?
26.If I created a column with data type VARCHAR(3), how is it stored in a MySQL table?
27.What does SET SQL_AUTO_IS_NULL =1 do?
28.What is ON DELETE CASCADE?
29.What is the usage of SAVEPOINTS?
30.What is referential integrity constraint?
31.What is an integrity constraint?
32.What is WITH ROLLUP clause in MySQL?
33.What is difference between TRUNCATE & DELETE?
34.How can we take a backup of a mysql table and how can we restore it. ?
35.How can we optimize or increase the speed of a mysql select query?
36.What are the different tables present in MySQL? Which is the default?
37.How can we encrypt and decrypt a data present in a mysql table using mysql?
38.Given an employee table, how would you find out the second highest salary?
39.Given an employee table, Print the Employee's and their respective Managers.
40.How do you handle MySQL security?
41.What is SQL Injection?
42.How do you perform MySQL query Optimization?

Java Interview Questions

1.What is the difference between a constructor and a method?
2.Difference b/w Passby Value and Pass by Reference
3.What are the causes of exceptions in java?
4.what is threadsafe?Is Vector is threadsafe ?
5.What is an abstract class?
6.Difference between an Interface and an Abstract class?
7.What is 'this' keyword in Java?
8.What is 'final' keyword in Java?
9.Explain 'overload' VS 'override'
10.Explain immutable classes, Name some
11.What is class.ForName?
12.What is MVC architecture, how is MVC2 different from MVC?
13.What is Polymorphism?
14.How to resolve null pointer exception
15.Explain use of GC(Garbage collection) in Java
16.Difference between Vector and ArrayList?

Javascript Interview Questions

1.How can we submit a form without a submit button?
2.How can we refresh a page every 30 seconds in HTML without using JS?
3.How can we send mail using JavaScript?
4.How to create 3 dimensional Array in Javascript?
5.How can I know that a variable is a number or not using a JavaScript?
6.Max cookies per Domain per User?
7.What is CAPTCHA?

Flex Interview Questions

http://doinflex.wordpress.com/2008/09/08/flex-questions/

PHP Questions with answers

http://www.psexam.com/mcq/php/132-php-multiple-choice-questions-mcqs-objective-questions-set-1.html

http://blog.agoraproduction.com/index.php?/archives/23-Zend-PHP5-Certification-self-test.html

Zend PHP Self Test

Web Programming - Learning Resources

http://php.net
http://phpvideotutorials.com/
http://www.killerphp.com/
http://www.softwaretrainingtutorials.com/php-beginners.php
http://www.webstockbox.com/php/php-video-tutorials-for-beginners/
http://www.chrisfinke.com/2007/05/04/video-tutorial-the-javascript-programming-language/
http://www.pixel2life.com/tutorials/javascript/javascript_general_basics/
http://www.1018-media.com/ext-perience/ext-javascript/javascript-video-tutorials-lectures/
http://www.gotmyidea.com/cat/javascript-video-tutorials
http://www.pixel2life.com/tutorials/javascript/ajax/
http://www.gotmyidea.com/cat/html-video-tutorials

Links

http://www.nickhalstead.com/2007/05/23/php-interview-questions-from-yahoo/
http://booleandreams.wordpress.com/php-mysql-interview-question/
http://booleandreams.wordpress.com/php-mysql-interview-question/php-mysql-interview-questions-2/
http://mycodings.blogspot.com/2008/07/php-mysql-interview-questions.html
http://www.possibility.com/wiki/index.php?title=MySQLInterviewQuestions