Interview Questions

Time periods you define to age your debit items. Aging buckets are used in the Aging reports to see both current and outstanding debit items. For example you can define an aging bucket that includes all debit items that are 1 to 30 days past due.

Normal table used for this Report is < 30 days 30-60 days 60-90 days 90-180 days and >180 days

i.) Const - This variable means that if the memory is initialised once, it should not be altered by a program. 

ii.) Volatile - This variable means that the value in the memory location can be altered even though nothing in the program code modifies the contents. 

iii.) Mutable - This variable means that a particular member of a structure or class can be altered even if a particular structure variable, class, or class member function is constant.

An assembly can be referenced by using the gacutil.exe utility with the /r option. The /r option requires a reference type, a reference ID, and a description.

There are many ways to find second highest salary of Employee in SQL, you can either use SQL Join or Subquery to solve this problem. Here is SQL query using Subquery :

SELECT MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) FROM Employee );

Master database is system database and it contains information about running server's configuration. When SQL Server 2005 is installed it usually creates master, model, msdb, tempdb resource and distribution system database by default. Only Master database is th one which is absolutely must have database. Without Master database SQL Server cannot be started. This is the reason it is extremely important to backup Master database.

To rebuild the Master database, Run Setup.exe, verify, and repair a SQL Server instance, and rebuild the system databases. This procedure is most often used to rebuild the master database for a corrupted installation of SQL Server.

- Friend classes are useful when a class wants to hide features from users which are needed only by another, tightly coupled class. 

- Implementation details can be kept safe by providing friend status to a tightly cohesive class.

A stub network has only one default path to non-local hosts and no outside network knowledge. Non-local stub network traffic uses a single logical path when traveling in and out of the network.

Stub networks are essentially local area networks (LAN) that either do not connect to the outside and relay data packets internally or are dead-end LANs that know of only one network exit. Stub networks may have multiple connections but use one path to single points of destination.

Hence, a stub network is a network that has only one entry and exit point.

A Customer Master Record is a permanent record that contains key information about a business partner or a material. This information must be entered into the system before any transactions can take place involving the business partner [customer] or a material. Entering all the information about a customer or a material into the system before making transactions insures that subsequent transactions or inquiries will have consistent data and reports and analyses can be done in an orderly way. Master Records can be edited or changed when necessary. Changing master records is frequently called "Maintaining" in SAP