Technology Questions

There are four important files in order to make a bootable Windows XP operating system. These are Ntldr, Ntdetect, Boot.ini and Ntfs.sys

Data warehousing is a process of repository of electronic data of an organization. For the purpose of reporting and analysis, data warehousing is used. The essence concept of data warehousing is to provide data flow of architectural model from operational system to decision support environments. 

EXECUTE IMMEDIATE command can be used to call DDL statements. 

Example:

BEGIN

EXECUTE IMMEDIATE  'TRUNCATE TABLE employee';

END;

The Active Directory database is stored on domain controllers and is accessible by network applications. All domains can be domain controllers and keep a copy of the Active Directory database in C:\windows\Ntds\Ntds.dit

- %FOUND

 This is a Boolean variable which evaluates to TRUE if the last row is successfully fetched.

- %NOTFOUND

 This is a Boolean variable which evaluates to TRUE if the last row is not successfully fetched. This means there are no more rows to fetch.

- %ROWCOUNT

 Returns the number of rows fetched by the cursor.

- %ISOPEN

If the cursor is open, it evaluates to TRUE else FALSE.

Star schema: A highly de-normalized technique. A star schema has one fact table and is associated with numerous dimensions table and depicts a star.

Snow flake schema: The normalized principles applied star schema is known as Snow flake schema. Every dimension table is associated with sub dimension table.

Differences:

- A dimension table will not have parent table in star schema, whereas snow flake schemas have one or more parent tables.

- The dimensional table itself consists of hierarchies of dimensions in star schema, where as hierarchies are split into different tables in snow flake schema. The drilling down data from top most hierarchies to the lowermost hierarchies can be done.

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

You can use the System.Net.Mail.MailMessage and the System.Net.Mail.SmtpMail classes to send an email in your Web pages. In order to send an email through your mail server, you need to create an object of the SmtpClient class and set the server name, port, and credentials.