.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Aptitude >> Post New QuestionBookmark and Share Subscribe to Forum

Interview Questions

Posted By: softraj     Posted Date: June 26, 2010    Points:2   Category :Aptitude
Hi,

I want to list out some questions which I faced during interview. Can u plz write answers for this questions

1. Which of the following is not a full rdbms package?

a. oracle b. sql server c. ms - access d. mysql

2. Which protocol works in the applicaiton layer of osi?

a. tcp b. ip c. http d. i forgot

3. What is the relation b/w "www" and "internet" ?

a. internet is part of www
b. www is part of internet
c. both internet and www are same
d. none of these

4. From which namespace only a static class can be inherited?

5. What is standard for GUID?

6. Whcih tool is used to see the details of assembly?

6. Which tool is used to generate the strong name for assembly?

7. Where the shared assembly must be placed to make it used by serveral applications?

8. what is the meaning of the follwoing statement:

enableviewstatemac=true

9. Which session management process should be used to store the session is IIS itself?

10. What type of command is the sqlcommand object by default?

a. text b. stored procedure c. i forgot

11. What is the value returned by ExecuteNonquery()?

a. Nothing b. 1 for success and 0 for error c. None

12 . Which of the follwoing is not the benefit of stored procedure?

a. pre - compiled code

b. Faster Execution

c. Replication

d. Sql Injection

13. How to insert try () and catch() blocks into stored procedure?

14. How can u alias the namespaces system.runtime.serializaton as srs?








Responses
Author: Syed Shakeer Hussain             
Posted Date: June 26, 2010     Points: 5   

Hi,
5)GUID=Grapical User Interface Design

8)To ensure that the ViewState is not tampered (check this link)http://www.dotnetjohn.com/articles.aspx?articleid=247

11)ExecuteNonQuery() will always return -1

12)C(answer)

13)-- Create procedure to retrieve error information.
CREATE PROCEDURE usp_GetErrorInfo
AS
SELECT
ERROR_NUMBER() AS ErrorNumber
,ERROR_SEVERITY() AS ErrorSeverity
,ERROR_STATE() AS ErrorState
,ERROR_PROCEDURE() AS ErrorProcedure
,ERROR_LINE() AS ErrorLine
,ERROR_MESSAGE() AS ErrorMessage;
GO

BEGIN TRY
-- Generate divide-by-zero error.
SELECT 1/0;
END TRY
BEGIN CATCH
-- Execute error retrieval routine.
EXECUTE usp_GetErrorInfo;
END CATCH;


Author: Sunil Yadav       [Moderator]      
Posted Date: June 26, 2010     Points: 5   

1. C

2. A

3. B

4. I guess you cannot inherit static class(correct me if i am wrong)

5. didn't get this question.

6. ILDASM

6. Sn.exe which comes up with visual studio

7. GAC (Global Assembly Cache)

8.
enableviewstatemac=true By setting this property to true,ASP.Net generates a Machine Authenticated Code (MAC) which is used to check for tampering of viewstate when page is posted back from client.

9. In-Process Mode

10. A

11. B

12. C (SQL injection are possible in Stored procedure when you are executing
a query using sp_Executesql.)


13.
BEGIN TRY
-- SQL Statement
END TRY
BEGIN CATCH

--SQL Statement

END CATCH;


14.
using srs = system.runtime.serializaton;


Author: Sunil Yadav       [Moderator]      
Posted Date: June 26, 2010     Points: 5   

Hi Syed Shakeer Hussain ,

Guid=Globally Unique IDentifier and i dont understand wht does standard mean?
also ExecuteNonQuery() will always return 1 or 0 not -1.
ExecuteNonQuery() always returns integer and is used to perform insert,update,delete operation as it will return rows affected.
It will return -1 when you perform select query on it.




Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend