Microsoft Interview Questions

Q:

What are the different types of system calls?

Answer

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

Report Error

View answer Workspace Report Error Discuss

0 1551
Q:

Why is it that you cannot overload the scope resolution operator (::)?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

0 1527
Q:

What are Microsoft security patches?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

0 1505
Q:

Define stored procedure. What are its advantages and disadvantages?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

0 1485
Q:

Differentiate linked list from arrays.

Answer

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

Report Error

View answer Workspace Report Error Discuss

0 1482
Q:

How can you have different number of cells for each row of a table?

Answer

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

Report Error

View answer Workspace Report Error Discuss

0 1479
Q:

What are the three file types in NT ?

Answer

NTFS, FAT & FAT 32 are the file systems of NT.

Report Error

View answer Workspace Report Error Discuss

1 1477
Q:

What is the purpose of creating partitions for a Windows operating system?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

1 1476