Ciena India .NET interview Questions

 

Here is few questions from Ciena India interview process for .NET requirement. This interview was conducted for 5+ years of requirement.

Telephonic Interview Questions:

• Tell me something about you education background, work experience and technology used?
• For what projects you used for wcf?
• What features you used in 2.0?
• What features you used in wcf?
• What is your roles and responsibilities?
• You do low level design or high level design, how to do low level design?
• What is difference between product and project life cycle?
• How many project you have done?
• What is your responsibilities as a lead and what role you looking for?
• Are you ready with some kind of support role?

Telephonic Technical Interview Questions:

This round was pure technical round and they asked questions like:

1. What is Web service? How to create it. What are the limitations of web services.

2. How to overload a web service method?

3. Can we have static and simple constructor in same class? Which one is first called?

Face 2 Face Technical Interview Questions:

1. What are advantages of string over string builder?

2. Why we use finalize and dispose?

3. What if we make a same interface as idisposable and use dispose method?

4. how string builder work internally?

5. How many Types of lock in threading?

6. What are mutex objects ?

7. What are multicast delegates?

8. What is difference between value type and ref type

SemanticSpace Telephonic Interview Questions - .NET

 

Telephonic interviews are sometimes hard to face. but most of the telephonic interviews are easy and this is just verification process that the person is right candidate for the job or not.

My friend gone through a telephonic round of SemanticSpace for software engineer position for .NET.

Question. They started with project, Tell me something about your current project?

Answer. describe your project.

Question. what is OOPs?

Answer. Object oriented programming, represent every thing in a object.

Question. What is polymorphism? what are different types of polymorphism is there?

Answer. polymorphism means different forms, there are two kind of polymorphism

1. static polymorphism (overloading)

2. dynamic polymorphism (overriding)

Question. What is difference between overloading and overriding?

Answer. having same name methods with different parameters is called overloading, while having same name and parameter functions in base and drive class called overriding.

Question. what is static class and what is use of this?

Answer. Static class we define when we do not want to create a object of class, all methods of static class should be static. static class methods and data are specific to class only and not associated to objects.

Question. Can we have a variables inside the interface?

Answer. no, we can have only methods, properties, indexers and enums inside the interface.

Question. Have you used AJAX?

Answer. I have used AJAX using microsoft ajax toolkit.

Question. What is your role in PL/SQL?

Answer. I used to design and write functions, triggers, procedures and packages.

Question. Have you used Queue in Oracle?

Answer. No

Question. What design patterns you used?

Answer. Facade, Prototype, Singleton. proxy , bridge

MakeMyTrip.com .NET Interview Questions | Written Test | Analytical Test | F2F Interview

 

This question set contains the written test questions and analytical test and Face to Face interview questions.

This interview was held in may 2010 at MakeMyTrip.com. I don't think they give very good salary but you can negotiate with them.

Written test – Fully objective type .NET

This round was fully objective and contains almost 30 objective type of questions in 20 minutes.

Question 1.  Session objects are accessible in?

1. web forms

2. web Farms

3. both

4. none

Answer.  web forms – check once

Question 2. application objects are accessible in?

1. web forms

2. web Farms

3. both

4. none

Answer.  1. web forms

Question 3.  give me three differences between unique key and primary key?

Answer.  1. Primary key is only one in table while unique key can be multiple

2. unique key can be null

3. cluster index create on primary key while non cluster index can be created on non cluster index.

Question 4. which control have the paging?

1. dataset

2. datareader

3. none

4. all

Answer. find out

Question 5. by default security setting in .net?

Answer. anonymous access

Question 6. which file contains  the configuration settings for URI to access in web services?

Answer. .disco (check it once)

like this there were around 30 questions, most of them asp.net questions were there.

 

Analytics / Aptitude test

this test was totally analytical and contains 40 questions in 30 minutes. you need to have pen and paper with you while attending the test.

you need to give test on http://www.merittrac.com site.

Question 1.  questions like 5 guys are sitting in a round table now A is sitting left to B , C is sitting next to D and then you have to answer some questions.

Question 2.  A English paragraph was given and you need to answer the some questions by reading those questions.

Question 3. 4 figures was given and you need to find the next figure in sequence.

Question 5. The numeric values of a name was given and you need to find the numeric values for the another name.

Question 6. A numeric expression like 3/23*2+44-2 was given and if + is replaced by *, - is replaced by /, /is replaced by + and * is replaced by – what will be the value. around 6-7 questions of this kind.

Question 7. A conclusion was given and statement 1 and statement 2 was given , you need to choose the options on the basis of these

1. Statement 1 is true

2. statement 2 is true

3. statement 1 and statement 2 is true

4. none

Face to Face Technical Round:

this was third round and face to face.

Question 1. Rate yourself in C#, ASP.net, SQL, JavaScript

Answer.

C# - 8

ASP.NET – 8

SQL - 8

Javascript - 8

Question 2. Lets start with ASP.NET, I have a datagrid/Gridview can i have a dropdown inside a  column and binding to different dataset? How

Answer. Yes, keep dropdown in template column

Question 3. How will you fill a dropdown from another dataset and grid from another dataset.

Answer.  First fill the grid with dataset and then datagrid.columns.findcontrol[“dropdown”] find dropdown and add another dataset to it.

Question 4.  How will you add increasing number (index numbers of rows) in datagrid without bringing it from database.

Answer. one method is to add on rowdatabound. find another

Question 5. Suppose there is two button in a datagrid  column. how will you identify which button is clicked?

Answer. by using commadname and commandargument.

Question 6. what is difference between unique key and primary key?

Answer.  primary key can create cluster index on it. while on unique key we can create non cluster index.

unique key can have null value

primary key is only one in table while unique key can be many.

Question 7. how many nulls unique key can have?

Answer. only one

Question 8. can we define unique key on combination of keys?

Answer. yes

Max Bupa .NET - C# - Oracle Interview Questions Round 1

One of my friend gone through the max bupa technical interview for .net requirement for software engineer post.

here is some questions from the same interview.

Question. Tell me something about you ?

Answer.

Question. rate your self in C# and oracle ?

Answer. C# –8 Oracle - 8

Question. Define a constant at package level in oracle

Answer.  temp constant number := 12;

Question. how will you access this?

Answer. by using the variable name.

Question. will this constant have same values for same transaction?

Answer. yes

Question. How will you implement transaction in C# ?

Answer. begin trans, end trans

Question. Suppose you have these lines of code:

begintrans

oracle statement 1

committrans;

oracle statement 2

committrans;

oraclestatement 3

comittrans; // error

end trans

exception

rollback trans

now in rollbacktrans which whole transaction will rollback or just last committed trans. ?

Answer.  the transaction will rollback till oracle statement 2

Question. what is cluster index, what is not cluster index ?

Answer. cluster index created on primary key while non cluster index is created on non primary key and it is logical index.

Question. how will you define the cluster index ?

Answer. create clusterindex on table(column1, column2)

Question. when you create a table with primary key a cluster index already created. so what is use of this command?

Answer. suppose while defining table there is no primary key in that case we can use this command.

Question. how to define function in oracle and call ?

Answer.  check it by your self.

Question. what is difference between function and procedure?

Answer. 

1. function returns one value while procedure can return multiple.

2. function can be used with select statement while procedure can not.

3. there is some operation we can not do with functions

Question. suppose a table student have following details

id marks1 marks2

write a query to display id and grade of student as follows

1. when sum of marks1 and marks2 is greater than 60 display grade A

2. when sum of marks1 and marks2 is less than 60 and greater than 40 display grade B

3. when sum of marks1 and marks2 is less than 40 display grade C

Answer. 

select case when marks1 + marks2 > 60 then

‘A’

when marks1 + marks2 > 40 then

‘B’

else

‘C’

end

from student ;

Question. What are the event datagird supports and how will you access the values of cell.

Answer. Check msdn.

Question. How to change the color of rows in datagrid?

Answer. use initialise row event

Question. how define a connection and open in oracle ?

Answer. check msdn.

Question. how to use pooling

Answer define pooling=true  in connection string

Question. how do you know that connection is already open and it have to pick from pool?

Answer. system detect automatically.

Question. write how to pass the parameters in oracle procedure.

Answer.

oda.SelectCommand = ocmd; 

oda.SelectCommand.Parameters.Add("my_column",   Oracle.DataAccess.Client.OracleDbType.Int32,15).Value=2;

Max Bupa Round 1 Interview Questions

Max Bupa Interview Questions Round 2

C# Written Test Questions 2010

 

One of my friend gone through the written test of a small company in Gurgaon. I decided to post some of questions from the test, so that the fresher's as well as experience holder get benefits. These are common questions and one need to know when going for interview.

This written test was for senior software engineer purely contains .net and C# questions.

Question 1: What is OOPs?
Answer: Object oriented programming like C#.

Question 2: What is XPath?
Answer: XPath is used to navigate through the elements and attributed in XML document.

Question 3: What is Strong type and Week type?
Answer: week type language support the any type variable declaration like java script supports var (no specific data type). Strong type language do not support var like C#.

Question 4: What is polymorphism?
Answer: Polymorphism means different forms, two types of polymorphism

1. runtime polymorphism

2. static polymorphism

Question 5: Difference between interface and abstract class?
Answer: Interface can have only function prototype and all functions should be implemented in inherited class. while abstract class can have function implementation.

Question 6: What is WCF, WPF, WWF? 
Answer: WCF: windows communication foundation

WPF: Windows presentation foundation

WWF: Windows workflow foundation

Question 7: What is Address, Contract and binding?
Answer: Address: An address that indicates where the endpoint can be found.

Contract: A contract that identifies the operations available.

Binding: A binding that specifies how a client can communicate with the endpoint.

Question 8: What is root class of .NET?
Answer: System.Object

Question 9: What is multicast delegate?
Answer: Multicast delegate is a delegate which allow to execute more than one method in single event.

Question 10: Can web services supports method overloading Explain with and example?
Answer: Yes, its same as simple method overloading just add a [web method] before the methods.

Question 11: What is difference between web services and WCF?
Answer: WCF = Web services + .NET Remoting

Question 12: Difference between View State and Session state?
Answer: View State is a client side storage management and store data while page postback. Session state is server side management and keep user specific data for session.

Question 13: What is machine.config?
Answer:  machine.config file apply settings to all applications running on the same machine.

Genpact, Gurgaon Interview Questions – Round 1 – Telephonic Interview

 

My Friend Vimal gone through the interview process of Genpact, Gurgaon for .NET Requirement for the post of Senior software engineer.

Its was very short interview and they were just analysis that person is involved in development or not.

The first round was telephonic and he has asked the following questions.

Question 1: Tell me about your current project?

Question 2: What is your roll and designation in your project?

Question 3: What software development life cycle you follow for your project?

Question 4: What is you project architectures?

Question 5: What design pattern you follow?

Questions 6: What types of design patterns are there, List some of them?

Question 7: Why are you looking for a change?

Question 8: Why you want to join the Genpact?

These are the some questions, my friend answered and he qualified for next face to face round.

I will discuss Genpact F2F round in my next post.

What is Intermediate Language(IL)/MSIL/CIL in .NET

 

IL = Intermediate Language

MSIL = Microsoft intermediate Language

CIL = Common Intermediate Language

IL, MSIL and CIL are the same thing. When we compile .NET project it not directly converted to binary code i converted to Intermediate language. And when we run the project IL is converted into binary code at run time. every language of .NET programming is converted into IL. Only some part of IL which is required at run time is converted into binary code. DLL and EXE of .NET are also in IL form.

C# Interview Questions 2010

 

Ques: Write a Program to find a given number is prime or not? Now optimize this program?

Ans: Start with 2 and divide the given number till n-1 if it is not divisible then it is a prime number.

To optimize this program you can check divisibility from 2 to n/2.

Ques: What are design patterns and what is the use of Design patterns?
Ans: To ease the software development process.

Ques: What is difference between Count(*), Count(1) and count(column_name)?
Ans: no difference between count(*) and count(1). While count(column_name) does not calculate null value fields.

Ques: what is difference between string and string builder?
Ans: string builder provide low overhead manipulation operations with a given string.

Ques: What is Difference between truncate, Delete and drop?
Ans: Drop Delete the table structure while truncate remove all rows from table without rollback facility. Delete remove rows from table with rollback features.

Ques: What are Delegates and events?

Ques: Explain Webpage Life Cycle?
Pre Init, Init, Pre Load, Load, Pre render, render, unload etc.

Ques: With Master page what will be sequence of event execution?
Ans. Master Page events executes first.

Ques: What is use of try.parse(string)?
Ans. Try.parse use to convert given data type to another one without exception.

Ques: Design a architecture for Chess Program?

Ques: What is HTTP GET and POST?
Ans: use get to receive information and post to send info in a webpage.

Ques: What is Difference between hash table and Dictionary?
Ans: Dictionary internally uses hash table.

Ques: What is Callback in c#?
Ans: Events and Delegates.

How to Change ASP.NET Project Version

 

Go to internet information service and change the version of project. the full steps are given below:

 

Step 1: Open start menu –> run

Step 2: Type inetmgr on run window

step 3: Internet information Service window is open now

Step 4: Go to your project under Website –> Default website

step 5: Right click on project –> select properties

Step 6: Go to ASP.NET tab

step 7: In the ASP.NET version dropdown you can select the appropriate version of .net for your project.

What is ASP.NET AJAX Toolkit and How to get it?

 

The ASP.NET AJAX Control Toolkit is an open-source project built on top of the Microsoft ASP.NET AJAX framework. Its is joint venture of  Microsoft and ASP.NET AJAX community to provide powerful platform to  build reusable , customizable, and extensible controls. This provides a platform to create a rich media applications.

The AJAX Control Toolkit contains more than 30 controls that enable you to easily create rich, interactive web pages.

ASP.NET AJAX toolkit is available free to download on ASP.NET site.

http://www.asp.net/ajax/ajaxcontroltoolkit/Samples/Default.aspx

Explain ASP.Net Page Life Cycle - ASP.NET Interview Questions

 

These are the events and sequence in which page loads.

1)Page_PreInit
2)Page_Init
3)Page_InitComplete
4)Page_PreLoad
5)Page_Load
6)Control Events
7)Page_LoadComplete
8)Page_PreRender
9)SaveViewState
10)Page_Render
11)Page_Unload

 

for more details, Please visit:

http://msdn.microsoft.com/en-us/library/ms178472.aspx

What is Windows DNA architecture - ASP.NET Interview Questions

 

The Windows Distributed interNet Applications Architecture is a Microsoft blueprint for robust, scalable, distributed business software. Windows DNA was not preplanned architecture and it was developed in between. It have all combined advantages of Centralized mainframe, application servers, internet technologies and Personal computers. Windows DNA is was started from mainframes in which all logic was centralized.

Windows DNA has been largely superseded by the Microsoft .NET Framework, and Microsoft no longer uses the term.

Define three tier architecture - ASP.NET Interview Questions

 

Three tier architecture modularize application in  3 parts.

1. User Interface (Client) Layer

2. Middle layer

3. Data Access Layer

1. User Interface (Client) Layer: This is the primary layer of application, by which user interacts to application. We also call is UI.

2. Middle layer: This is Middle Layer, Where most of the business logic and rules are executed. It also provide functions such as queuing, application execution, and database staging etc.

3. Data Access Layer: This is also called by the famous acronym "DAL" component. It has mainly the SQL queries which do the database operation part of the job.

Diffrence between MasterPage and WebUserControl – ASP.NET Interview Questions

 

A master page is a template for other pages, which shares design and functionality with other pages. The master page provide a content place holder for other pages.

Web user control is a unit of functionality, which incorporate into parent page. it does not give a template design and functionality as master page gives. .NET provide .ascx extension for user control.