InterviewCity.com

 

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

 

Here is the Max bupa round 2 interview questions. 

Question. Rate yourself in oracle and C# ?

Answer. C# –7

Oracle -6

Question.  how will you rectify the problem if grid is taking more time when data increases ?

Answer.

1. use paging because binding takes more time

2. optimize database procedure bu indexing and removing loops

3. use custome paging

4. use xml or session to store temporary date for page.

Question. A class is inherited from two interfaces and a abstract class, how will you define a abc function which is common in class and interfaces?

calss xyz: I1, I2, absclass
{

abc()
{
}

I1.abc()
{
}

I2.abc()
{
}

}

how will you access these methods from a object

Answer.

by using objectname.I1.abc()

Question. there is a table called t1, which contains

doc_name doc_stage       date
doc1      initialize     12-may-2010
doc2      initialize     13-may-2010
doc1      finalize       14-may-2010

write a query to get last stage of all the documents ?

Answer.  use group by function and sort by date in reverse order.

Question. how will you return a array as output from a procedure and receive in C#

Answer. find out.

Max Bupa Selection Process for Software Engineers

Max Bupa Round 1 Interview Questions

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

 

Last week one of my friend gone through interview process of orange business Gurgaon. I am posting some interview questions to help you guys.

Oracle business is a multinational company dealing with telecom and communication sectors. They just open a new center in Gurgaon.

There were two rounds one technical round and another is HR.

Basically this interview was for crystal report developer with .net and oracle.

In case of any questions, Please commend here.

 

Crystal report questions:

Q. What is crystal reports?
A. It is a third party tool used with .net to create a complex reports.

Q. What version of crystal report are you using?
A. Crystal report 11

Q. What is subreports?
A. We can add reports inside main report that is sub report.

Q. How to pass parameters in subreport?
A. Find out

Q. How to do calculations in Crystal reports.
A. using formula fields

Q. Can we calculate total and subtotals in crystal reports, how?
A. Yes, by using formula fields for total and subtotals.

 

Oracle Interview Questions:

Q. What are joins?
A. To get corresponding data from two table we use join.

Q. can we run windows application from oracle, how?
A. Yes, Find out.

Q. How to improve performance of oracle procedure?
A. Reducing loops, global tables , minimize the inserts and updates.

Q. Difference between function and procedures?
A. function can return one value only and procure can return multiples using cursors.

 

C# Interview Questions:

Q. How to avoid deadlock in multithreaded environment?
A. using lock and monitor

Q. How to improve performance of grid?
A. using paging and JavaScript operations, bind only once because bind takes much time.

Q. suppose accessing a procedure though a error, at what what layer you will handle this exception.
A. Data access layer

 

To know more about Orange business, Please visit the site:

Oracle Business Official Site