Microsoft Interview Questions

A stored procedure is a segment of declarative SQL statements stored inside the database catalog. A stored procedure can be invoked by triggers, other stored procedures or applications such as Java, C#, PHP, etc.

Advantages 

- Typically stored procedures help increase the performance of the applications. Once created, stored procedures are compiled and stored in the database. However MySQL implements the stored procedures slightly different. MySQL stored procedures are compiled on demand. After compiling a stored procedure, MySQL puts it to a cache. And MySQL maintains its own stored procedure cache for every single connection. If an application uses a stored procedure multiple times in a single connection, the compiled version is used, otherwise the stored procedure works like a query.

- Stored procedures helps reduce the traffic between application and database server because instead of sending multiple lengthy SQL statements, the application has to send only name and parameters of the stored procedure.

- Stored procedures are reusable and transparent to any applications. Stored procedures expose the database interface to all applications so that developers don’t have to develop functions that are already supported in stored procedures.

- Stored procedures are secure. Database administrator can grant appropriate permissions to applications that access stored procedures in the database without giving any permission on the underlying database tables.

Disadvantages

- If you use a lot of stored procedures, the memory usage of every connection that is using those stored procedures will increase substantially. In addition, if you overuse a large number of logical operations inside store procedures, the CPU usage will also increase because database server is not well-designed for logical operations.

- A constructs of stored procedures make it more difficult to develop stored procedures that have complicated business logic.

- It is difficult to debug stored procedures. Only few database management systems allow you to debug stored procedures. Unfortunately, MySQL does not provide facilities for debugging stored procedures.

-It is not easy to develop and maintain stored procedures. Developing and maintaining stored procedures are often required specialized skill set that not all application developers possess. This may lead to problems in both application development and maintenance phases.

The main types of system calls are as follows:

Process Control: These types of system calls are used to control the processes. Some examples are end, abort, load, execute, create process, terminate process etc.

File Management: These types of system calls are used to manage files. Some examples are Create file, delete file, open, close, read, write etc.

Device Management: These types of system calls are used to manage devices. Some examples are Request device, release device, read, write, get device attributes etc.

Information Maintenance: These types of system calls are used to set system data and get process information. Some examples are time, OS parameters, id, time used etc.

Communications: These types of system calls are used to establish a connection. Some examples are send message, received messages, terminate etc

Arrays can store data in a fix allotted space. The use of linked list allows more flexibility because space is dynamically allocated as needed.

The main reason why the scope resolution operator (::) cannot be overloaded is that only operators that take in values as parameters can be overloaded. The scope resolution operator does not take a value as parameter.

Microsoft security patches are intended to solve certain security loopholes and problems, while at the same time upgrading any existing security features. This would provide better protection by reducing vulnerabilities in security.

The server version of a Windows operating system is designed to provide more optimized networking services over a network. It can manage domains better and it includes more security feature and data backup support. Workstation versions act merely as clients and therefore do not need to have as much resources when compared to the server versions.

By setting the columnSpan property for cells of each row as required.

Creating partition may serve different purposes. The common reason is that a separate partition can be used to store data files so that when Windows needs to be reinstalled, the main partition can be formatted without fear of loosing data, which are stored on the other partition.