A-Z about Dotnet: 2008

Check out this questions and analyse yourself.. New questions will be posted shortly..

TCS Interview Questions...
1) What is abstract class?
2) What is assembly.
3) How you install assembly?
4) What is shared assembly?
5) Tell about web.config?
6) How many catches will be there in a try block?
7) Write a query that matches all the results in two tables?
8) What is ASP.NET Page Life Cycle?
9) How do you validate checkboxes in datagrid?
10)Differences between response.redirect, server.transfer, server.execute.
11)What is the difference between function and stored procedure
12)Write a query which gives the highest salary without using max andwhere keywords.
13) How do you upload asp.net project onto web server?
14) What is event bubbling?
15) What are the technologies used in Ajax?
Note: U'll get all answers of the above questions in Dotnet Faq's Book.

Wipro Sql Interview Questions & Answers..

1.What is normalization? Explain different levels of normalization?

It is set of rules that has been established to aid in the design of tables that are mean to be connected through relationships. This set of rules is known as Normalization.
Benefits:
Avoiding repetitive entries.
Reducing required storage space
Increased speed and flexibility of queries, sorts and summaries.

2.What is denormalization and when would you go for it?

Denormalization is the process of putting one fact in numerous places (its vice-versa of normalization).Only one valid reason exists for denormalizing a relational design - to enhance performance.The sacrifice to performance is that you increase redundancy in database.

3.How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?

One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships. One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships. Many-to-Many relationships are implemented using a junction table with the keys from both the tables forming the composite primary key of the junction table. It will be a good idea to read up a database designing fundamentals text book.

4.What’s the difference between a primary key and a unique key?

Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column, where are unique creates a nonclustered index by default. Another major difference is that, primary key doesn’t allow NULLs, but unique key allows one NULL only.

5.What are user defined datatypes and when you should go for them?

User defined datatypes let you extend the base SQL Server datatypes by providing a descriptive name, and format to the database. Take for example, in your database, there is a column called Flight_Num which appears in many tables. In all these tables it should be varchar(8). In this case you could create a user defined datatype called Flight_num_type of varchar(8) and use it across all your tables. See sp_addtype, sp_droptype in books online

6.What is bit datatype and what’s the information that can be stored inside a bit column?

Bit datatype is used to store boolean information like 1 or 0 (true or false). Untill SQL Server 6.5 bit datatype could hold either a 1 or 0 and there was no support for NULL. But from SQL Server 7.0 onwards, bit datatype can represent a third state, which is NULL.

7.Define candidate key, alternate key, composite key.

A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary key of the table. If the table has more than one candidate key, one of them will become the primary key, and the rest are called alternate keys. A key formed by combining at least two or more columns is called composite key

8.What are defaults? Is there a column to which a default can’t be bound?

A default is a value that will be used by a column, if no value is supplied to that column while inserting data. IDENTITY columns and timestamp columns can’t have defaults bound to them. See CREATE DEFAULT in books online.

9.What is a transaction and what are ACID properties?

A transaction is a logical unit of work in which, all the steps must be performed or none. ACID stands for Atomicity, Consistency, Isolation, Durability. These are the properties of a transaction. For more information and explanation of these properties, see SQL Server books online or any RDBMS fundamentals text book. Explain different isolation levels An isolation level determines the degree of isolation of data between concurrent transactions. The default SQL Server isolation level is Read Committed. Here are the other isolation levels (in the ascending order of isolation): Read Uncommitted, Read Committed, Repeatable Read, Serializable. See SQL Server books online for an explanation of the isolation levels. Be sure to read about SET TRANSACTION ISOLATION LEVEL, which lets you customize the isolation level at the connection level. Read Committed - A transaction operating at the Read Committed level cannot see changes made by other transactions until those transactions are committed. At this level of isolation, dirty reads are not possible but nonrepeatable reads and phantoms are possible. Read Uncommitted - A transaction operating at the Read Uncommitted level can see uncommitted changes made by other transactions. At this level of isolation, dirty reads, nonrepeatable reads, and phantoms are all possible. Repeatable Read - A transaction operating at the Repeatable Read level is guaranteed not to see any changes made by other transactions in values it has already read. At this level of isolation, dirty reads and nonrepeatable reads are not possible but phantoms are possible. Serializable - A transaction operating at the Serializable level guarantees that all concurrent transactions interact only in ways that produce the same effect as if each transaction were entirely executed one after the other. At this isolation level, dirty reads, nonrepeatable reads, and phantoms are not possible.

10.What’s the maximum size of a row?

8060 bytes. Don’t be surprised with questions like ‘what is the maximum number of columns per table’. 1024 columns per table. Check out SQL Server books online for the page titled: "Maximum Capacity Specifications". Explain Active/Active and Active/Passive cluster configurations Hopefully you have experience setting up cluster servers. But if you don’t, at least be familiar with the way clustering works and the two clusterning configurations Active/Active and Active/Passive. SQL Server books online has enough information on this topic and there is a good white paper available on Microsoft site. Explain the architecture of SQL Server This is a very important question and you better be able to answer it if consider yourself a DBA. SQL Server books online is the best place to read about SQL Server architecture. Read up the chapter dedicated to SQL Server Architecture.

Value Labs Dotnet Questions..

1.Differences between stored procedure and functions?

2) What are design patterns?

3) Write stored procedure with input and output parameters?

4) How Themes have advantage over CSS in ASP.NET?

5) What are abstract class?

6) Expand SRS?

7) What are different types of joins?

8) What is the difference between sub queries and Joins?

9) What is the difference between abstract class and interfaces?

10) What is web.config?11) What is isolation in asp.net page?

12) How do you handle errors in page level?

13) Tell some controls related to Ajax?

14) Javascript: How do you display an alert with the text containingin a textbox?

15) Write the syntax for Fileupload control?

16) For HTML controls we can add runat="server" why to use servercontrol always what is the advantage of using server controls overHTML controls?

17) Briefly explain 3-Tier architecture in ASP.NET?

18) Have you done manual paging and sorting in gridview?

19) What are the events related to paging in gridview?

20) To disable validations controls on client side what we must do?

21) What is use of Dataview?

22) What s the validation for checkbox in gridview?

23) How do you display the contents in a dropdownlist according to therowindex of a GRIDVIEW?

24) What is multiview?

25) Write the code for disconneceted data architecture?

26) Can you use dataview with datareader?

27) How do you find a control in gridview?

28) Can user1 can see session of another user?

29) When session and applicaton state will be used?

30) What is the page Life cycle in asp.net?

31) Can we put a session variable in Page_pre-init?

32) Can we put a session variable in Page_Unload?

33) What is Ajax?

34) What is the difference between method overloading and methodoverriding?

35) If a constructor has same name as base class. If an object iscreated .It will refer to constructor or class?

36) Have you created functions?

37) What are webservices?

38) Why we use @@ in sql?

39) Is better to use double or decimal in .net?

40) What is the difference between as and is operator?
41)What is web.config

42) Difference between for and foreach loop?

43.)Difference between String and String builder class?

44) Difference between Reference types and Value types

45)Difference between Stored Procedure and Views?

46)How do u extract first 3 rows of a table?

47) How do distribute the layers in 3-tier architecure?

48) Difference between Execute Scalar, Execute Reader n Execute nonscalar

49) what is datatable

50) How do u deploy a web application?

52) what is web service

53)Hhow do u call Garbage Collector?

54) Garbage collector collects unused objects from stack or heap?

55) Difference between decimal & double?

56)Which one of double n decimal is recommended to use?

Note: U'll get all answers of the above questions in Dotnet Faq's Book.

Tuesday, July 22, 2008

Download .Net Books

Download .Net Faq's

Read .Net Interview Questions & Answers

Download .Net MCTS Dumps

Google Search Engine

Blog Archive

.Net Tutorials

Your Ad Here

.Net Faq's Tutorial

My Profile