Interview Questions

- A web page with large number of images takes a longer time to load. This is because each image separately sends out a http request.

- The concept of CSS sprite helps in reducing this loading time for a web page by combining various small images into one image. This reduces the numbers of http request and hence the loading time.

Any code written in any .NET complaint languages when compiled, converts into MSIL (Microsoft Intermediate Language) code in form of an assembly through CLS, CTS. IL is the language that CLR can understand. On execution, this IL is converted into binary code by CLR’s just in time compiler (JIT) and these assemblies or DLL are loaded into the memory.

What are your weaknesses?

This is a very common interview question for many jobs across industries. Most people feel Answering strengths is easy but weaknesses is difficult. If approached the right way this question will give you chance to build trust. You have 3 options/approaches to answer this question. 

1. Deny having any weaknesses. This approach is least common and surely not the way to go.

2. Spin a Weakness into a strength. Like, "I'm a perfectionist" or "I care too much"

Note - This is very common approach and some interviewers think you are not being honest. 

3. Give an honest answer (Recommended). Answer the question honestly without shooting yourself in the foot. 

E.g. My weakness is public speaking, I am working on it. Ofcourse make sure this is not the primary requirement of the job. 

Price and quantity supplied move in the same direction. As the price decreases, quantity supplied also decreases and viceversa.

When a class is derived from another class, then the members of the base class become the members of the derived class. The access modifier used while accessing members of the base class specifies the access status of the base class members inside the derived class.

The syntax to inherit a class from another class in C# is as follows:
class MyNewClass : MyBaseclass

- A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.

- A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

A sequence is a database object that is used to generate sequential number.

CREATE SEQUENCE seqname [increment] [minimum value][maximum value][start][cache][cycle]               Nextval and currval lets us get the next value and current value from the sequence.