Correct Answer: COM is short for Component Object Model It is a Microsoft technology that allows developers to make use of reusable components and services provided by Microsoft COM technology includes COM+, DCOM and ActiveX
2. What files are important in a bootable Windows XP operating system?
Correct 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
4. What is the difference between a Windows server operating system and a workstation version?
Correct Answer: 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
Correct Answer: Windows XP supports four major file systems: FAT12, FAT16, FAT32 and NTFS This means that Windows XP can be installed on these file systems The use of NTFS is preferred especially when using a bigger hard drive space
Correct Answer: Dual boot system allows you to install and maintain two operating systems on a single PC The purpose for this is to maintain compatibility between older and newer software For example, there maybe programs that only work under Windows 98, therefore having a dual boot system between Windows 98 and another version like Windows XP is a good choice
7. Explain the basic difference between 32-bit and 64-bit operating system?
Correct Answer: A 32 bit processor is faster than a 64 bit processor, 64 bit processors are very commonly used that you can find it easily in any home pc but the main difference is the hardware you are having on your machine For 32 bits there isn't any need of any wide main bus to carry 32 bits at a time but for 64 bits its must that you should have a wider bus to carry 64bits
Correct Answer: UDP (User Datagram Protocol) is a communications protocol that offers a limited amount of service when messages are exchanged between computers in a network that uses the Internet Protocol (IP)
Correct 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
10. Define stored procedure. What are its advantages and disadvantages?
Correct 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