Technology Questions

Traceability matrix is a cross matrix for recording the requirements through each stage of the requirements gathering process. This matrix should also take into account any changes in the scope during the life of the project. 

     At the end of the project this matrix should show each function built into a system, its source and the reason that any stated requirements may not have been delivered. 

Bitmap indexes make use of bit arrays (bitmaps) to answer queries by performing bitwise logical operations.

Bitmap indexes are useful in the data warehousing applications.

Bitmap indexes have a significant space and performance advantage over other structures for such data.

Tables that have less number of insert or update operations can be good candidates.

The advantages of Bitmap indexes are:

   - They have a highly compressed structure, making them fast to read.

   - Their structure makes it possible for the system to combine multiple indexes together so that they can      access the underlying table faster.

The Disadvantage of Bitmap indexes is:

  - The overhead on maintaining them is enormous. 

You can deploy an ASP.NET Web application using either the Windows Installer deployment or ClickOnce deployment technique.

Supply the DD cards just as you would for files referred to in the main program.

User defined data-types in SQL is an extension to the base SQL server data-types by provision of a descriptive name.

We use them to format the database and segregate specific repetitions of rows and columns in the database.

Generating random passwords in PHP can be done in multiple ways depending on how much security the application demands:-

Md5 function can be passed one parameter as uniqid() function which in turn generates a random number. Passing the parameter as TRUE in uniqid() adds additional uniqueness.

<?php
   $passwd = md5(uniqid(rand(), true));
   Echo $passwd;
?>

.Net allows developers to write program logic in at least 25 languages. The classes written in one language can be used by other languages in .Net. This service of .Net is possible through CTS which ensure the rules related to data types that all language must follow. It provides set of types that are used by all .NET languages and ensures .NET language type compatibility.