Best 1. 00+ Frequently Asked Interview Questions in . Net SQLIn this tutorial, I’m going to post common and frequently asked technical interview questions in . I also wrote many other tutorials on Interview Questions, Asp. SQL Server, OOP Concepts as well as Top 1. OOPS Concepts in details. I recommend you to read those tutorials, I’m sure, you’ll enjoy it! It’s very difficult to predict what interviewer will ask during interview, right? I think so, but I can assure that following are the best list of possible technical interview questions that I’d faced during my job interviews and also I asked as an interviewer in my professional carrier. Tip: If you are appearing as an experienced developer in the interview, then Why do you want to change the job? In which event Asp. Ans: Mainly all controls are accessible in Page. How can we identify that the Page is Post Back? Ans: The Is. Post. Back property of “Page” object is used to identify that the Page is Post Back. Here is the example: protectedvoid Page. What is the difference between ASP and ASP. NET? Ans: ASP stands for Active Server Pages, also known as Classic ASP which is Microsoft’s server- side technology and used to create dynamic and user- friendly web pages. Asp. net was developed by Microsoft to allow programmers to build dynamic web sites, web applications or web services. It is an open source server- side web application framework designed for Web development to produce dynamic web pages. The main difference between ASP and ASP. NET is that ASP is Interpreted Language because ASP uses VBScript; whereas ASP. NET is Compiled Language because ASP. NET uses . NET Languages like C#, Vb. MSIL (Microsoft Intermediate Language). What is the lifespan for items stored in View. State? Ans: The lifespan of items stored in View. State lives until the current page expiration including current page post backs. When user requests another page, the previous page data are no longer available. In short, we can say that the lifespan for items stored in View. State exists till your current page exists. Is . NET is Platform Independent? Yes or No? Ans: It depends on different point of views. There are many of saying that . NET is Platform Independent, Partially Dependent or Platform Dependent. But in my opinion, . NET is Platform Dependent because it needs . NET Framework and Windows OS to run your application. Which is the parent class used for the web server control? Ans: The System. Web. UI. Control class is used for all the web server control. What is View. State in Asp. Where is the View. State information stored? Ans: The View. State is a feature that is used by ASP. NET page framework to persist the page and server control values between round trips or post backs. The View. State information is stored in the HTML hidden fields. It is automatically used by the ASP. JAVA OOPS Interview Questions and answers for freshers. Interview Questions >. Top 100 C# Interview Questions and Answers. Learn OOP's Concepts in.NET - C# Tutorial. Object Oriented Programming-Interview Questions What is OOP? The object oriented programming is commonly known as OOP. Most of the languages. Interview questions for.NET,OOPS,object,oriented,VB.NET,SQL Server,C#. 6 Essential C# Interview Questions* 0 shares. Top 50 C# Interview Questions and Answers for freshers and experienced. NET page framework to persist information that must be preserved between post backs. You can also use View. State to store application data that is specific to a page, like this: //Store the values to View. State. View. State. What is the use of App. We can use it to store the files that we want to use in our website, like common classes, text files, pdf files, email templates, reports etc. What is the difference between Data. Apache/2.2.31 (Unix) mod Answers to object oriented programming interview questions. Object Oriented Programming Interview Questions. Oops interview questions. Oops Concepts In Net Interview Questions And Answers Pdf. Programming Concepts (OOPS) in C#.net. Oops Concepts In Net Interview Questions And. Set and Data. Reader? Ans: The Data. Set has read/write access, we can update records; whereas Data. Reader has read- only access, we can’t update records. C# oops interview questions.The Data. Set supports both forward and backward scanning of data; whereas Data. Reader supports forward- only scanning of data. What is the difference between Data. Set and Data. Table? Ans: A Data. Set contains a collection of one or more database tables which resides in- memory; whereas A Data. Table contains a single database table which resides in- memory. A Data. Set has a collection of data tables; whereas A Data. Table has a collection of rows and columns. Read More. Tip: I can understand how difficult to be appear in an interview for fresher’s or a little experienced developers? So, my suggestion is to keep calm and do your best with whatever you know. Don’t try to be over smart just answer questions which interviewer asked. It would be good if you can explain their questions with example (whenever required). It’ll leave positive impact on interviewer and feels that he/she can perform best during his/her training period or employment. What is Auto. Post. Back Property? Ans: If you want to automatically post back page when any event raised, you need to set the Auto. Post. Back property of the asp. True as follows.< asp: Drop. Down. List. ID=. How can you pass the value from one page to another? Ans: Following are the two common ways to pass the values from one page to another page. What is SQL Injection? How we can prevent it? Ans: The SQL Injection Attack is a technique of “insertion” or “injection” of a SQL queries via webpage or web form input controls. SQL injection attacks are a type of injection attack, in which SQL commands are injected into data- plane input in order to effect the execution of predefined SQL commands. It means altering SQL commands into SQL statements, and modifies database tables or data with using SQL Statements like Insert, Update or Delete. We can prevent SQL Injection Attack by using Parameterized SQL Statements. You can get more details with step- by- step guide and example by go through the Read More link. What is the difference between String and String. Builder? Ans: A String is “immutable”, meaning that once you created string object then you can’t modify it; whereas A String. Builder is “mutable”, meaning that once you created string builder object then you can modify or append without creating a new instance for every time. In String, Any operation that appears to change the string, it creates a new instance of string type in memory; whereas In String. Builder, Any operation that appears to modify or append new string, it doesn’t create a new instance of string type in memory. What is the difference between string and String? Ans: Technically there is no difference between both of them. In general, string is an alias for System. String. It’s same like int and System. Int. 32. You can get more details by go through the below link in detail with example code. What is the use of Data. Adapter? Ans: The Data. Adapter is a part of ADO. NET Data Provider. It provides the communication between the Data. Set and Data. Source. We can use Data. Adapter in combination with the Data. Set objects for data access and manipulation capabilities. The Data. Adapter uses the SELECT statement to FILL a Data. Set or Data. Table and other DML statements like INSERT, UPDATE, and DELETE to make modification to Data. Source. 1. 7. Which method of Data. Adapter is use to load data to Data. Set or Data. Table? Ans: The Fill() method of Data. Adapter is use to fill or load the data to Data. Set or Data. Table, like da. Fill(dt). If you want to check complete example of insert, update, delete including this method, please check here. What is the use of IIS? Ans: The IIS stands for Internet Information Services which is created by Microsoft to provide Internet based services to your ASP. NET web applications. It is use to host your web applications on the server. It makes your local computer to work as a web server which provides functionality to deploy one or more web applications on the server. What is the difference between Execute. Reader, Execute. Non. Query and Execute. Scalar? Ans: The Execute. Reader is generally used to get or read data from result set so it’s appropriate with SELECT Command. The Execute. Non. Query is generally used when we want to perform any operation on result set so it’s appropriate with INSERT, UPDATE, and DELETE Command. The Execute. Scalar is generally used when we need only first value of result set or aggregate functions like SUM, COUNT, and AVG etc in SELECT Command. Execute. Scalar returns what? Ans: The Execute. Scalar returns the first column of the first row from the result set returned by the query, additional rows and columns will be ignore from the result set. It will return null reference if result set is empty. Execute. Non. Query returns what? Ans: The Execute. Non. Query returns int value as no of row(s) affected. For example, When you are inserting records, you can see “1 row(s) affected”, “5 row(s) affected” etc. What is the differece between User- Defined Function and Stored Procedure? Ans: The User- Defined Function can be used in SQL statements anywhere in the WHERE, HAVING, or SELECT section; whereas the Stored Procedure cannot be used like this, we can use EXEC statement to execute stored procedure. Following are some other differences between them: Stored Procedure: – It can be used to Read and Modify data– It cannot be used to create constraints while creating a table– It can return 0 or n number of values; and which is OPTIONAL– It can have “Input” as well as “Output” parameters– It supports Transaction Management– It cannot be called from Function– It can allow SELECT as well as DML statements such as INSERT, UPDATE, or DELETE– We can use try- catch block to handle exception. User- Defined Function: – It can only Read data– It can be used to create constraints while creating a table– It can only return 1 value; and which is MENDATORY– It can only have “Input” parameters– It does not support Transaction Management– It can be called from Stored Procedures– It can only allows SELECT statement under function– We cannot use try- catch block in a function to handle exception. How can you call the connection string from Web. Ans: You can get and use connection string this way but what if you had specified your connection string in Web. Web. config file? You can do this by using following single line of code, like this.//For C#: Include Namespace – using System. Configuration; string con = Configuration. Manager. Connection. Strings. Define PRIMARY KEY, UNIQUE KEY and FOREIGN KEY? Ans: A PRIMARY KEY constraint is a unique identifier for a row within a database table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2017
Categories |