Technical Interview questions in Netripples(MNC) at Hyderabad


In this article, I am sharing my experience on Technical Interview questions which I had faced in NET RIPPLES(MNC) at HYDERABAD.

There are following list of question which are asked by HR in my Interview
1)What is CHECK Constraint?
The CHECK constraint is used to limit the value range that can be placed in a column.If you define a CHECK constraint on a single column it allows only certain values for this column.If you define a CHECK constraint on stable it can limit the values in certain columns based on values in other columns in the row.

2)Is Web.Config File is an optional file in asp.net?
Ans)YES

3)Can we create a WEB.CONFIG file more than one in an our application
Ans)YES,we can create one or more than one.

4)What is the use WEB.CONFIG file?
Ans)1)To store Sql Connection Strings
2)To handle Custom Error Page
3)Authorization

5)Can you write a code for storing sql connection string in web.config file(Recruiter told me to write on a Paper)?
Ans)


< configuration>
< connectionStrings>
< add name="sqlconnectionstring" connectionString="Data Source=source name;Initial Catalog=DB;User ID=sa;Password=sa" />
</connectionStrings>
</configuration>

6)How you will display a Confirm MessageBox in Asp.Net(Recruiter told to write on a paper?
Ans)
< script type="text/Javascript" language ="javascript">
function confirm_meth()
{
if( confirm("Do you want to continue!Click 'YES'")==true)

{
document.writeln ("you click on 'YES' Button");
}
else
{
document.writeln ("you click on 'NO' Button");
}
}
</script>

7)What is the Difference between Eval() and Bind()?
Ans)Eval() method provides only for displaying data from a datasource in a control.
Bind() methods provides for two-way binding which means that it cannot be used to display as well update data from a datasource

8)Which Protocols that are commonly used for sending and retrieving Email Message?
Ans)1)SMTP
2) POP

9)Is Try and Catch Block help to the programmer?
Ans)I answered Yes,(again Recruiter ask me where you had used in your project>br> and use of it.I said to handle Custom page Error.If any unhanded exception
occur in a page catch block will redirect to custom error Page)

10)Can you write a code for handling Custom Error Page using try and catch Block?
Ans)
try
{
}
Catch(Exceprtion ex)
{
Exception["error"]=ex;
Response.Redirect("ErrorPage.aspx");
}


11)How many ways you can display a Custom Error Page?
Ans)1)Using try and catch block
2)Page Error Event Handler in Page source code
3)Application Error Event Handler
4)using Page Error Element in web.Config

12)Can you write a stored Procedure using DataSet?(Recruiter told to write a code on paper)
Ans)

SqlConnection conn = new SqlConnection("Data Source=name;Initial Catalog=db;
User ID=sa;Password=sa");
conn.Open();
SqlCommand cmd = new SqlCommand("storedprocedure_name",conn );
SqlDataAdapter adapter = new SqlDataAdapter(cmd );

DataSet ds = new DataSet();

adapter.Fill(ds);
GridView1.DataSource = ds.Tables[0];

GridView1.DataBind();


13)Difference between Drop and Truncate?
Ans)When you Truncate a Table
1) Removes all Rows from a Table
2) Releases the storage space used by that table
3) You cannot roll back row removal when using TRUNCATE.
4) If the table is Parent of a refrential integrity constraint,you cannot truncate the TABLE.Disable the constraint before issuing the TRUNCATE statement.

Syntax: TRUNCATE TABLE tablename

Drop:-
When you drop the Table:
1)All data and structure in the table is deleted
2)Any Pending transaction are commited
3)All Indexes are dropped
4)You cannot RollBack the DROP Table statement.
5)DROP TABLE is commited automatically
6)Indexes, tables, and databases can easily be deleted/removed with the DROP statement

Syntax:DROP INDEX table_name.index_name

14)In which Event all the Controls will be loaded(in asp.net)?
Ans)In PageLoad Event

15)Difference between varchar and char?
Ans)varchar are variable length strings with a maximum length specified.
If a string is less than the maximum length, then it is stored verbatim
without any extra characters.

char are fixed length strings with a set length specified.
If a string is less than the set length, then it is padded with extra characters
so that it's length is the set length.

16)Difference between custom control and user control?
Ans)
User control:-
1)Reusability web page
2)We can’t add to toolbox
3)Just drag and drop from solution explorer to page (aspx)
4)U can register user control to. Aspx page by Register tag
5)A separate copy of the control is required in each application
6)Good for static layout
7)Easier to create
8)Not complied into DLL
9)Here page (user page) can be converted as control then
We can use as control in aspx

Custom controls:-
1)Reusability of control (or extend functionalities of existing control)
2)We can add toolbox
3)Just drag and drop from toolbox
4)U can register user control to. Aspx page by Register tag
5)A single copy of the control is required in each application
6)Good for dynamics layout
7)Hard to create
8)Compiled in to dll

17)can you write a code for Inserting a rows using storedprocedure?
(Recruiter told to write on a Paper)

Ans)

CREATE PROCEDURE [dbo].[InsertUser] (
@Username varchar(50),
@Password varchar(50)
) AS
INSERT INTO Users VALUES(@Username, @Password)


string username = textusername.Text;
string password =txtpassword.Text;
SqlConnection conn = new SqlConnection("Data Source=localhost;Database=MyDB;Integrated Security=SSPI");

SqlCommand command = new SqlCommand("InsertUser", conn);

command.CommandType = CommandType.StoredProcedure;

command.Parameters.Add("@Username", SqlDbType.VarChar).Value = username;

command.Parameters.Add("@Password", SqlDbType.VarChar).Value = password;

conn.Open();

int rows = command.ExecuteNonQuery();

conn.Close();


Note:- Above are the Interview questions based for 1+ year Expereince>


More articles: .net Interview Questions

Comments

Author: ABitSmart30 Dec 2009 Member Level: Gold   Points : 0

Please format your resource tags.

Author: Christopher F05 Jan 2010 Member Level: Gold   Points : 1

For 11th Question:

We can use Web.config file too

here we have tag and We specify Page if Error Occur,it will Redirect to Specified Error Page

Author: mausumi05 Feb 2010 Member Level: Gold   Points : 1

hi

thanks for sharing ur interview experiences with us.
congradulation for ur success .




4m
mausumi

Author: krishnavenikaladi06 Feb 2010 Member Level: Gold   Points : 0

Thanks for sharing

congrats for u'r success

Author: Abhay Kumar Raut06 Feb 2010 Member Level: Gold   Points : 1

Hi Sayed

Thanks for sharing ur interview experiences with us.
Keep it up.

Thanks and regards
Abhay

Author: Syed Shakeer Hussain06 Feb 2010 Member Level: Gold   Points : 0

Hi Krishna and MyDns,
Thank you
Syed shakeer Hussain

Guest Author: anjali lakshmi26 May 2013

Thanks lot its very useful for us.how can i prepare for an interview which source want to use for preparation please give some more tips to me



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: