Here I will explain about differences between asp.net 2.0/3.0/3.5. Generally we will see the questions like difference between Asp.net 2.0, 3.0 and 3.5 but there is no Asp.net 3.0 version. We have a version of 3.0 .NET Framework.
Showing posts with label Interview Questions. Show all posts
Showing posts with label Interview Questions. Show all posts
Interview Questions Part-7 | What is a deadlock in SQL Server | What are “GRANT” and “REVOKE’ statements in SQL | How do you find the Second highest Salary in SQL Server
Categories:
Interview Questions
What is a deadlock in SQL Server?
Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other’s piece. Each process would wait indefinitely for the other to release the lock, unless one of the user processes is terminated.
Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other’s piece. Each process would wait indefinitely for the other to release the lock, unless one of the user processes is terminated.
Interview Questions Part-6 | What is @@ROWCOUNT in SQL | What is Difference between Commit and Rollback in SQL | What is Candidate key, alternate key and composite key in SQL | What are Isolation Levels in SQL | What is Lock Escalation in SQL Server
Categories:
Interview Questions
What is the Use of @@ROWCOUNT?
UPDATE authors SET au_lname = 'Jones'
Returns the number of rows affected by the Query.
Ex:
UPDATE authors SET au_lname = 'Jones'
WHERE au_id = '999-888-7777'
IF @@ROWCOUNT = 0
print 'Warning: No rows were updated'
Interview Questions Part-5 | What is PRIMARY KEY Constraint in SQL Server | What is UNIQUE KEY Constraint | What is FOREIGN KEY Constraint | What is CHECK Constraint | What is NOT NULL Constraint in SQL Server ?
Categories:
Interview Questions
What is PRIMARY KEY Constraint in SQL Server?
Primary key constraint is used to uniquely identify each record in database table. It won’t allow repetition or duplication of data. Each table is having only one primary key constraint and it contains only unique values. Primary key constraint doesn’t accept null values (Read more Here)
Interview Questions Part-4 | What is the Difference between a HAVING clause and a WHERE clause in SQL Server | What is Connection Pooling and why it is used | What are the Authentication Modes in SQL Server | What is the difference between UNION and UNION ALL | What is Identity in SQL Server
Categories:
Interview Questions
What is the Difference between a HAVING clause and a WHERE clause in SQL Server?
They specify a search condition for a group or an aggregate. But the difference is that HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Having Clause is basically used only with the GROUP BY function in a query, whereas WHERE Clause is applied to each row before they are part of the GROUP BY function in a query
Interview Questions Part-3 | What is an Index in SQL Server | What is the Difference between Clustered and a Non-clustered Index in SQL Server | What is Collation | What are Primary Keys and Foreign Keys in SQL Server | What’s the Difference between a Primary Key and a Unique Key in SQL Server
Categories:
Interview Questions
What is an Index in SQL Server?
An index is a physical structure containing pointers to the data. Indexes are created in an existing table to locate the data more efficiently and quickly (Read more Here)
Interview Questions Part-2 | What are the Different Types of Triggers | What is a View | What is the Difference between a Function and a Stored Procedure | What are the Advantages of Using Stored Procedures in SQL Server
Categories:
Interview Questions
What are the Different Types of Triggers?
After triggers and Instead of triggers
After triggers are the triggers which are raised before the transaction committed or postback.
Instead of triggers are used to update the database tables which are associated with view instead of updating the view directly.
Interview Questions Part-1 | What is Normalization | What is De Normalization | What is a Stored Procedure | What is a Trigger in SQL Server
Categories:
Interview Questions
What is Normalization?
In relational database design, the process of organizing data to minimize redundancy. Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.There are three main normal forms, each with increasing levels of normalization:
what is stored procedure in Sql server | what are the advantages of using stored procedures in sql server
Categories:
Interview Questions
,
SQL Server
Introduction:
Here I will explain about what is stored procedure is and advantages and disadvantages of stored procedures in sql server
Description:
A stored procedure is a group of sql statements that has been created and stored in the database. Stored procedure will accept input parameters so that a single procedure can be used over the network by several clients using different input data. Stored procedure will reduce network traffic and increase the performance. If we modify stored procedure all the clients will get the updated stored procedure
Subscribe to:
Posts
(
Atom
)
- Interview Questions in ASP.NET, C#, VB.NET, SQL, .NET Framework
- Simple login form example in asp.net Check Username and Password availability in database
- Asp.net insert, Edit, update, delete data in gridview
- 3 tier architecture example in asp.net with C#
- Introduction to Object Oriented Programming Concepts (OOPS) in C#.net
- OOPS (Object Oriented Programming) Concepts in C#.NET with Examples
- Best Login Page Design in HTML, CSS with Source Code
- C# - Constructors in C# with Example, Types of Constructor in C# with Example
- how to insert images into database and how to retrieve and bind images to gridview using asp.net (or) save and retrieve images from database using asp.net
- Introduction to WCF - WCF tutorial | WCF Tutorial - Windows Communication Foundation | WCF Example | WCF Sample code in asp.net 3.5 | Basic WCF Tutorial for Beginners