Asp.Net Corner

  • Home
  • Contact Us
  • JQuery
    • Dvd
    • Games
    • Software
      • Office

Saturday, 15 August 2015

Advanced C# Interview Questions And Answers Part 3

 August 15, 2015     No comments   

1.) Where is the output of TextWriterTraceListener redirected ?
The output of TextWriteTraceListener Redirected to the console or a text file depending on the parameter passed to the constructor.

2.) Can you change the value of a variable while debugging a c# application ?
Yes, if you are debugging via visual studio.NET.

3.) What is the service layer in 3 Tier .NET application ?
Presentation Layer Business Access Layer(BAL) Data Access Layer (DAL) More Details...

4.) What is the role of the DataReader class in ADO.NET Connections ?
The DataReader class returns a read-only dataset from the datasource when the command is executed.

5.) What is wild character in SQL SERVER ?
The wild character is % in SQL . You can use this symbol with like keyword.  More Details...

6.) What is the thumb rules of transactions ?
There are four main property of transactions which is knows as ACID Property. Atomic :- It is an unit of work and does not dependent on previous and following transactions.It must be atomic. Consistency :- Data should be in consistence form. Means data is either committed or roll back ,not "in-between" case where something has been updated and something has not. Isolation :- It means, no transaction sees the intermediate results of current transaction. Durability :-It means,the values persist if the data had been committed even if the system crashes right after.

7.) What type of connection is supported by Microsoft SQL Server ?
Window Authentication SQL Server Authentication

8.) What authentication is trusted and which is untrusted ?
Windows Authentication is trusted because the username and password are checked with the Active Directory. The SQL server Authentication is untrusted because SQL Server is the only verified participating in transactions.

9.) What does dispose method do with the connection object ?
It helps to delete it from the memory.

10.) What is a pre-requiste for connection polling ?
In connection polling ,multiple process must agree that they will share the same connection where every parameter is the same.

11.) What is delegate ?
A delegate encapsulates a references to a method. More Details...

12.) What is trigger ?
A trigger is an event that is automatic executed when condition is satisfied.

  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to XShare to Facebook
Newer Post Older Post Home

0 comments:

Post a Comment

Popular Posts

  • General .NET Questions And Answers Part 1
    1.) What is .NET ? ....
  • Jquery Interview Question and ans
    Q6. Is jQuery a W3C standard? Ans: No. jQuery is not a W3C standard.   Q7. What is the basic need to start with jQuery? Ans: To start ...
  • (no title)
    1. What is the use of jQuery filter? The jQuery filter is used to filter the certain values from the object list based on the criteria. ...

Recent Posts

Categories

  • Interview
  • Question

Pages

  • Home

Text Widget

Blog Archive

  • ►  2017 (7)
    • ►  August (2)
    • ►  July (5)
  • ▼  2015 (8)
    • ▼  August (5)
      • Advanced C# Interview Questions And Answers Part 4
      • Advanced C# Interview Questions And Answers Part 3
      • Advanced C# Interview Questions And Answers Part 2
      • Advanced C# Interview Questions And Answers Part 1
      • 1.) What is .NET Assembly ? ...
    • ►  July (3)

Categories

  • Interview
  • Question

For More Updates Follow Us

Unknown
View my complete profile

Featured post

Jquery Interview Question and ans

Q6. Is jQuery a W3C standard? Ans: No. jQuery is not a W3C standard.   Q7. What is the basic need to start with jQuery? Ans: To start ...

Contact Form

Name

Email *

Message *

Copyright © Asp.Net Corner | Powered by Blogger
Design by Hemil Bhavsar | Blogger Theme by aspdotnetcorner.blogspot.in