Posts

Showing posts from December, 2015

Common SQL Interview Questions for Freshers

A primary key is a column in a table whose values uniquely identify the rows in the table. The primary key is chosen from this list of candidates based on its perceived value to the business as an identifier. A primary key value: Must uniquely identiy the row; cannot have NULL values; Should not change over the time; and Should be as short as possible. A candidate key is a key that uniquely identifies rows in a table . Any of the identified candidate keys can be used as the table's primary key . Candidate keys that are not part of the primary key are called alternate keys . One can describe a candidate key as a super key that contains only the minimum number of columns necessary to determine uniqueness. An alternate key is any candidate key that is not the primary key . Alternate keys are sometimes referred to as secondary keys. What is the definitions between stored procedures and functions? Fu...

Common C# Interview Questions for Freshers

1.Does C# support multiple-inheritance? No. But you can use Interfaces. 2.Where is a protected class-level variable available? It is available to any sub-class derived from base class 3.Are private class-level variables inherited? Yes, but they are not accessible. 4.Describe the accessibility modifier “protected internal”. It is available to classes that are within the same assembly and derived from the specified base class. 6.Which class is at the top of .NET class hierarchy? System.Object. 7.What does the term immutable mean? The data value may not be changed. Note: The variable value may be changed, but the original immutable data value was discarded and a new data value was created in memory. 8.What’s the difference between System.String and System.Text.StringBuilder classes? System.String is immutable. System.StringBuilder was designed with the purpose of having a mutable string where a variety of operations can be performed. 9.What’s the advantage of...