Dotnet Interview Questions Part VI

 

Keane India

 

  1. Biztalk

What are functoids ? String functoids, Value functoids

 

  1. Runtime Polymorphism

(or Overloading or Late Binding)

 

       Eg: int function1(int a, int b)

              int function1(float a,float b)

              int function1(int a, int b,int c)

              float function1(int a , int b)

 

  1. What is function overriding?

 

  1. Difference between interface and abstract?

 

  1. Give example for Self Join?

 

 

6.

Employee

EmpId DeptId EmpName
1 1 Emp1
2 1 Emp2
3 2 Emp3
4 2 Emp4
5 2 Emp5
6 2 Emp6

 

 

Department

DeptId DeptName
1 CSE
2 MECH

 

Required Result should appear like the below:

 

DeptId DeptName NumberOfEmployees
1 CSE 2
2 MECH 4

 

Ans:

Select Emp.DeptId, Dept.DeptName, Count(*) As NumberOfEmployees from

Employee Emp inner join Department Dept

On Emp.DeptId = Dept.DeptId

Group by Emp.DeptId, Dept.DeptName

 

 

7.

Department (Master table)

DeptId DeptName
1 CSE
2 MECH

 

Employee (Child Table)

EmpId EmployeeName DeptId
1 Emp1 Null
2 Emp2 Null

 

Can we insert null value in deptid column in Employee table (child table)?

 

Ans : Yes (doubt)

 

8.

 

Employee table : Here EmployeeName has unique constraint

EmpId EmployeeName
1 Emp1
2 Emp2

 

Can we insert a null value for EmployeeName 2 times simultaneously like:

 

Insert into Employee values(3,null)

   … Success

Insert into Employee values(4,null)

   … Failure

Insert into Employee values(5,’’)

  ..Success

Insert into Employee values(6,’’)

   ..Failure

 

 

 

RealSoft Inc. Bangalore

 

  1. Asp.net Caching

 

         Types:

            a. Output (Page)

  1.  
    1.  Fragment
    2. Data

 

 

  1. How values can be maintained in cross paging

Ans: Get,Post,cache, Application variable, Sessionss

 

  1. What are delegates ? Different types? How to create and when to use them?

 

  1. What are custom controls and user controls in Asp.Net

 

Custom Controls have these methods: CreateChildNode(), Render()

UserControls have RaiseEvent() method

 

UserControl Custom Control

 

Will be included in Toolbox framework

 

Can be used in any project

 

5.What are the methods of webparts?

   CreateChildControls, render

 

   What are the controls that are present in Toolbox for Webpart?

   WebPartManager, WebPart Zone etc..

 

   How to debug and deploy a webpart

 

  1. Different UML diagrams

     Ans:Class Diagrams, Sequence Diagrams

 

  1. Xml

 

  1. WebServices

 

  1. Difference b/w Sqlserver 2000 and 2005

 

  1. What are the methods in Ado.net DataView?

Ans: sorting, finding records by using RowFilter

 

10.If we made any modifications in  a dataset then what is the method ?

Ans : Update

How many operations are performed ?

Ans: Only the updated records

If  new records are inserted then how it effects?

 

  1. Different types of css styles

Ans:

  1. page level

<script>

 Function cssfunction()

{

Font: bold;

Sixe: 10;

}

<form>

 

<input type = text class= cssfunction()></input>

</form>

 

2nd Type:

 

In Form2.css we have defined all functions of css

And in Form3.aspx we are using these functions by using link tag

 

Form3

……….

<link href=form2.css >

<script>

 

 

</script>

<form>

 

</form>

 

3rd  Type : Control Level

 

<input type = “text” class = font:bold/>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: