Technology Questions

The letters XP actually stands for eXPerience. It was designed as an enhancement of Windows 2000, with a totally different and more attractive user interface/console.

NTFS is short for New Technology File System. It is the standard file system that is being used by operating systems starting from Windows NT, Windows 2000, Windows XP, and even the newer versions like Vista and 7. It was originally designed to have a better performance on file storage and retrieval under the Windows NT family.

In a nutshell, a temp table is a temporary storage structure. It means you can use a temp table to store data temporarily so you can manipulate and change it before it reaches its destination format.

In table_user.gender column change ‘male to female’ and ‘female to male’ in one SQL statement.

UPDATE table_user

SET gender =

CASE gender

WHEN ‘male’ THEN ‘female’

WHEN ‘female’ THEN ‘male’

ELSE gender

END

Eucalyptus stands for “Elastic Utility Computing Architecture for Linking Your Programs to Useful Systems” and provides an open source software infrastructure to implement clusters in cloud computing platform. It is used to build private, public and hybrid clouds. It can also produce your own datacenter into a private cloud and allow you to extend the functionality to many other organizations. Eucalyptus provides APIs to be used with the web services to cope up with the demand of resources used in the private clouds.

IDMS uses record locks to prevent another run-unit from updating the same record.

Requirements tracing, a process of documenting the links between the requirements and the work products developed to implement and verify those requirements. Requirement Traceability Matrix (RTM) is a document which records the mapping between the high-level requirements and the test cases in the form of a table. The RTM captures all requirements and their traceability in a single document delivered at the conclusion of the life cycle. 

That’s how it ensures that the Test Plan covers all the requirements and links to their latest version.

Every Analysis server has a repository to store metadata for the objects like cubes, data sources etc. It’s by default stored in a MS Access database which can be also migrated to a SQL Server database.