Wednesday, March 2, 2011

Intergraph Qns

1) What is the advantage of Object oriented programming?

2) What is the difference between Object oriented and Procedural oriented programming?

3) What is the defference between delegate and event?

4) Suppose I have give you a game 'Carams' and ask you to write classes for that game ? What are the classes would you write?

5) Can you explain/write what exactly happen when you have given credential to a login page?

6) We all know that class has fields and properties. what is the need of writing properties? Why can't we use fields instead of properties?

It may seems similar when a public filed is declared inside a class and a public property is written inside class. But both are different.

1) When we use public field, you cannot restrict the value assigned to it. You cannot apply any condition before value is assigned to the public field. Anything can be assigned.
Where as in Public properties, you can assign the value based on the conditions.


public class SomeClass
{
    public int SomeValue;
}


public class SomeClass
{
    private int _someValue;
    public int SomeValue
    {
        get { return _someValue; }
        set
        {
            if (value == 42)
            {
                throw new ArgumentException("value must be 42");
            }
            _someValue = value;
        }
    }
}

2) Do you use data binding?. If you do, you may want to make sure that your types are data bindable. Currently, data binding works with properties, but not fields. If you choose to expose the field directly, you also choose not to support data binding.

3) Another nice feature that you get when exposing state through properties is that you can have different access levels on get and set operations:

public class SomeClass
{
    private int _someValue;
    public int SomeValue
    {
        get { return _someValue; }
        protected set
        {
            if (value == 42)
            {
                throw new ArgumentException("value must be 42");
            }
            _someValue = value;
        }
    }
}
Now SomeValue is designed so that any code can get the value, but only code in the SomeType class or any descendant class can set it. This kind of granularity of access control is not available with fields.

Read this Good Article:

7) Do you know how many types of design patterns are there and their names?

8) What is the tough situation you have faced while developing in recent times?

9) Suppose you and your team member working on a module which has to be delivered soon. Your team member got a call from his parents to come back to home. In such situation how would you handle the situation?

10) When do you used interface and when do you use abstract class?

11) We have joins to retrieve data from multiple table. Is there any other way to retrieve data from multiple tables?

12) What is difference between where clause and group by clause?

13) what is strong authentication?

14) Explain what would happen once you submitted your credentials in Login page?

15) How do you encrypt password before storing it into database?

16) When do you write more than 2000 lines of code? Have you ever written such no of lines of code?
I told him "for every screen developed from scratch, which has a moderate functionality, requires more than 2000 lines of code".

17) Suppose your photo is printed on main page of news paper. you must write something on that paper...For instance, some balloons are arranged around your photo and you have to fill those balloons. Each balloon must tell something about you. What will you write?

18) Can you tell me new features in .net 4.0?

19) He asked something related to electrical engineering as they have products on specific engineering domains.

20) Why did you leave your teaching profession?
I said that the picture in my mind before entering into that was completely different from the picture I have seen there.

21) You have any complaints with management?
I said that I cannot blame any person or the management. Its the proplem in the system in that profession.

22) What are your strengths?

23) Do you think that the package you are getting now is less for a 4 yrs experienced Candidate?
I said yes..again he asked me

24) So you are expecting more.
I said that I am looking for both my professional and financial growth.

25) Tell me something about your family?

26) Tell me a table name and columns in it which you have accessed recently?

27) Have you ever participated in design?
He said that everything in intergraph must handled by the developer. There will not be designers.

28) What is normalization? Explain each one of them?

It is set of rules that have been established to aid in the design of tables that are meant to
be connected through relationships. This set of rules is known as Normalization.
Benefits of normalizing your database will include:

√ Avoiding repetitive entries
√ Reducing required storage space
√ Preventing the need to restructure existing tables to accommodate new data.
√ Increased speed and flexibility of queries, sorts, and summaries.

Note :- During interview people are expect to answer maximum of three normal forms and
that’s what is expected practically. Actually you can normalize database to fifth normal
form.

Following are the three normal forms :-

First Normal Form
For a table to be in first normal form, data must be broken up into the smallest units
possible.In addition to breaking data up into the smallest meaningful values, tables in
first normal form should not contain repetitions groups of fields.




Figure :- 10.1 Repeating groups example

For in the above example city1 and city2 are repeating.In order that this table to be in
First normal form you have to modify the table structure as follows.Also not that the
Customer Name is now broken down to first name and last name (First normal form data
should be broken down to smallest unit).


Figure :- 10.2 Customer table normalized to first normal form

Second Normal form
The second normal form states that each field in a multiple field primary keytable must
be directly related to the entire primary key. Or in other words, each non-key field should
be a fact about all the fields in the primary key.
In the above table of customer, city is not linked to any primary field.


Figure :- 10.3 Normalized customer table.

Figure :- 10.4 City is now shifted to a different master table.

That takes our database to a second normal form.

Third normal form
A non-key field should not depend on other Non-key field. The field "Total" is dependent
on "Unit price" and "qty".

Figure :- 10.5 Fill third normal form

So now the "Total" field is removed and is multiplication of Unit price * Qty.

29) When do you do Denormalization?

30) Can we do multiple inherittance?
No..you can do multiple interface...

31) Which control you like most and why?
I said that DataList control is my favourite control as it allows us to show data in what ever way we like...

32) What is authentication and what is authorization?

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.