You must Sign In to post a response.
  • Category: Career Guidance

    Preparation for the Interview

    Hi..

    I am Rohini.I have 2+ years of experience on .net .Now i am in search of a job change.I have experience Asp.Net,C#.Net and Sql Server 2008.And i have knowledge on MVC and WCF. As i have knowledge on mvc and wcf but not any experience on them, what type of questions can i expect from the interviewer on mvc and wcf.

    Last weak when i have attend the interview, i have faced following questions from the interviewer.Kindly explain me the following questions,as i was unable to answer them in my interview.

    1)Difference between view and cursour
    2)How do you execute multiple update statements using single query
    3)Types of authentication and authorization in IIS
    4)How do you set "https" for web applications in .net
    5)Difference between table variable and temp variable
    6)Difference between WCF and WebService
    7)What is sql expection
    8)What are indexes.How many types?

    And also guide me what type of questions can i face on MVC and WCf.

    Thanks,
  • #760768
    Hi
    Rohini


    1)Difference between view and cursor
    --- cursor
    -- Answer. we can use looping purpuse for ex Transaction data we
    -- can use cursor

    --View
    -- But selected purpuse only. we cant insert records.Precomiled this
    --Create view Viewsp
    --Select * from tblemp

    2)How do you execute multiple update statements using single query
    --Ans
    -- Update tablename set filed1='value' where id in(1,2)

    3)Types of authentication and authorization in IIS
    ---You can go through Below link
    --http://www.codeproject.com/Articles/55502/Beginner-s-Guide-to-Authentication-and-Authorizati
    --https://msdn.microsoft.com/en-us/library/aa292114(v=vs.71).aspx
    ---http://net-informations.com/faq/asp/authentication.htm
    --http://www.iis.net/configreference/system.webserver/security/authorization
    --http://www.aspfree.com/c/a/iis/authentication-and-authorization/

    Hope it will be helpful to you.

    Name : Dotnet Developer-2015
    Email Id : kumaraspcode2009@gmail.com

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • #760769
    Hi

    4)How do you set "https" for web applications in .net
    --HTTPS (HTTP over SSL or HTTP Secure) is the use of Secure Socket Layer (SSL) or Transport Layer Security (TLS)
    --as a sublayer under regular HTTP application layering. HTTPS encrypts and decrypts user page requests as well as the pages that are returned by the Web server...

    5)Difference between table variable and temp variable
    --- Table variable act like table struture we can use temporary table -> Run time only.
    --- temp variable use one value -> Run time only

    6)Difference between WCF and WebService
    ---WCF
    ---Supports various protocols like HTTP, HTTPS, TCP, Named Pipes and MSMQ.
    --Webservices
    --Supports only HTTP, HTTPS protocols.

    7)What is sql expection
    -- When the error came from sql thats called sql exception
    --try
    --{

    --}
    --catch (SqlException ex)
    --{
    -- string error = ex.Message;
    --}

    8)What are indexes.How many types?
    --Clustered,Nonclustered
    --When we use Index is very easily fetch the data using sorting concept

    Hope it will be helpful to you

    Name : Dotnet Developer-2015
    Email Id : kumaraspcode2009@gmail.com

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • #760772

    Hi,

    The questions were more related to Sql Server. So, you need to brush up Sql server fundamemtal concepts. You can refer to my article on this site for few of the fundamentals.

    http://www.dotnetspider.com/resources/45826-SQL-Server-Interview-Questions.aspx.

    As per your questions,

    1)Difference between view and cursor?
    The most important difference is View is a virtual Table i.e. it is a database object to store data whereas Cursor is a object used to execute the data row by row inside a Stored procedure. It cannot be used outside a Stored procedure.

    2)How do you execute multiple update statements using single query.
    We can use multiple update statements in a single query using case statements.
    Example:
    UPDATE dbo.Employee
    SET LASTNAME =
    ( CASE
    WHEN (LASTNAME = 'AAA') THEN 'BBB'
    WHEN (LASTNAME = 'CCC') THEN 'DDD'
    WHEN (LASTNAME = 'EEE') THEN 'FFF'
    ELSE (LASTNAME)
    END )

    Hope this informations will be helpful to you.
    Do mark the answer most useful to you as the Best answer.

  • #760776
    Hi

    Authentication and Authorization:
    We have 3 types of authentication in asp.net
    1.Windows authentication
    2.Forms Authentication
    3.Pass port authentication

    Authentication in IIS is of 3 types
    1.Basic
    2.Digest
    3.Windows

    For complete understanding of authentication and authorization refer below article link.

    www.codeproject.com/Articles/98950/ASP-NET-authentication-and-authorization

    www.c-sharpcorner.com/uploadfile/lmoningi/authenticationandauthorizatio11252005233533pm/authenticationandauthorizatio.aspx

    Regards

    Sridhar Thota.
    "Poverty means.. Poverty of knowledge.."

    Sridhar Thota.
    Editor: DNS Forum.

  • #760783
    Hi

    Difference between wcf and webservice:
    1.Wcf uses system.runtime.serialization
    webservice uses system.xml.serialization.

    2.Wcf service is hosted in IIS,WAS,selfhosting,Windows service.
    webservice can be hosted in IIS only.

    3.Wcf supports http,tcp,msmq, named pipes protocols.
    webservice supports http only.

    4.In wcf ServiceContract is attributed at class level and OperationContract is attributed at method level.
    webservice is attributed at class level and webmethod is attributed at method level.

    5.Multi threading is possible in wcf.
    webservice doesn't support multi threading.

    Regards

    Sridhar Thota.
    "Poverty means.. Poverty of knowledge.."

    Sridhar Thota.
    Editor: DNS Forum.


  • Sign In to post your comments