.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 >> Interview Question >> ADO.Net >> Post New Question Subscribe to Interview Questions

Can you give a overview of ADO.NET architecture ?

Posted By :Narayanan     Posted Date :July 26, 2012    Points :40   Category :ADO.Net 
The most important section in ADO.NET architecture is “Data Provider”. Data Provider provides access to data source (SQL SERVER, ACCESS, ORACLE).
Connection.
Command object(This is the responsible object to use stored procedures)
Data Adapter(This object acts as a bridge between datastore and dataset).
Datareader(This object reads data from data store in forward only mode).

You can also find related Interview Question to Can you give a overview of ADO.NET architecture ?  below: 

Explain architecture of Notification Services?

  
Notification Services applications are based on a subscriber/subscription model.
The Key components in a Notification Services application are

Subscriber: A user or application that requests and receives the notification
Subscription: A request for information, delivery mechanism, and destination for requested notifications. For example change of a stock price.
Event: A piece of information, in which the subscriber is interested. For example as soon as a stock price has changed an event can be generated that's processed within SQLNS.
Notification: A message containing the information requested by the subscriber in the subscription.

SQLNS executes the following steps whenever it generates a new notification and sends it to registered subscribers:

.Subscribers create subscriptions with a subscription management application, such as an ASP.NET or Windows Forms front end.
.Subscription management is the only part of an SQLNS application where users or applications are actively involved in the process. You generate subscriptions using a managed assembly shipped with SQLNS.
.The Notification Application collects events, which are processed within the SQLNS application.
.SQLNS uses T-SQL statements to assign events to the subscriptions registered in the first step.
.SQLNS generates new notifications whenever it finds an assignment.
.A Formatter formats the new notification, and SQLNS delivers it through a delivery channel to the registered target device of the subscriber. (More...)

Give Some Examples of Generic Classes?

  
List,Queue,Stack,LinkedList,HashSet (More...)

Can you give me some DBCC commands?

  
DBCC CHECKDB - To ensure tables in the db and the indexes are correctly linked.

DBCC CHECKALLOC - To check that all pages in a db are correctly allocated.

DBCC CHECKFILEGROUP - Checks all tables file group for any damage. (More...)

.Net architecture?

  
The order starting from the bottom
1. CLR (Common Language Runtime)
2. .Net framework base classe
3. ASP.Net Web Form / Windows Form (More...)

Can you give me some DBCC command options?(

  
DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked. and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage. (More...)

Can you give an example of when it would be appropriate to use a web service as opposed to a non-serviced .NET component?

  
Services:
o Communicating through a Firewall When building a distributed application with 100s/1000s of users spread over multiple locations, there is always the problem of communicating between client and server because of firewalls and proxy servers. Exposing your middle tier components as Web Services and invoking the directly from a Windows UI is a very valid option.
o Application Integration When integrating applications written in various languages and running on disparate systems. Or even applications running on the same platform that have been written by separate vendors.
o Business-to-Business Integration This is an enabler for B2B intergtation which allows one to expose vital business processes to authorized supplier and customers. An example would be exposing electronic ordering and invoicing, allowing customers to send you purchase orders and suppliers to send you invoices electronically.
o Software Reuse This takes place at multiple levels. Code Reuse at the Source code level or binary componet-based resuse. The limiting factor here is that you can reuse the code but not the data behind it. Webservice overcome this limitation. A scenario could be when you are building an app that aggregates the functionality of serveral other Applicatons. Each of these functions could be performed by individual apps, but there is value in perhaps combining the the multiple apps to present a unifiend view in a Portal or Intranet.
o When not to use Web Services: Single machine Applicatons When the apps are running on the same machine and need to communicate with each other use a native API. You also have the options of using component technologies such as COM or .NET Componets as there is very little overhead.
o Homogeneous Applications on a LAN If you have Win32 or Winforms apps that want to communicate to their server counterpart. It is much more efficient to use DCOM in the case of Win32 apps and .NET Remoting in the case of .NET Apps. (More...)

Can you give an example of what might be best suited to place in the Application_Start and Session_Start subroutines?

  
The Application_Start event is guaranteed to occur only once throughout the lifetime of the application. It's a good place to initialize global variables. For example, you might want to retrieve a list of products from a database table and place the list in application state or the Cache object. SessionStateModule exposes both Session_Start and Session_End events. (More...)

what is the difference between compiler and interpreter?
give any one example for interpretter?

  
An interpreter reads each line of the source code and
converts it to machine code on the fly. This happens every
time the programme is run. Consequently it is very slow as
it is converting source code to machine code while the
programme is running.


A compiler does it once and thats it.

DOS BASIC is an example for interpretter. (More...)

LAN Architecture?

  
(1). 802.3
(A). Defines a standard for physical layer and data link layer of the Ethernet architecture that uses wired connection.

(B). Ethernet is an architecture that mainly uses bus topology
Defines various cabling used for different types of topologies.


(2). 802.4
(A). Defines a standard for Token Bus architecture.

(B). Token bus is similar to token ring, but it uses coaxial cables.


(3). 802.5
(A). Defines a standard for Token ring architecture.

(B). Uses the 10 Base T cabling standard.

(C). Uses twisted pair cabling to connect devices instead of coaxial cable.

(D). Passes data from one computer to another like in a token bus network. (More...)

Can we generate Trigger for two table and give a example ?

  
yes,we can create trigger on two tables.

CREATE TABLE T4 (a INTEGER, b CHAR(10))

CREATE TABLE T5 (c CHAR(10), d INTEGER)

CREATE TRIGGER trig1
AFTER INSERT ON T4
REFERENCING NEW AS newRow
FOR EACH ROW
WHEN (newRow.a <= 10)
BEGIN
INSERT INTO T5 VALUES(:newRow.b, :newRow.a);
END trig1
(More...)

What is the use of System.Environment class? Give some Examples

  
used to retrieve information about the operating system

1) Environment.OSVersion - Gets the version of the operating system
2) Environment.GetLogicalDrives() - method that returns the drives
3) Environment.Version - returns the .NET version running the application
4) Environment.MachineName - Gets name of the current machine
5) Environment.Newline - Gets the newline symbol for the environment (More...)

Which command using Query Analyzer will give you the version of SQL server and operating system?

  
SELECT SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition'). (More...)

Can you give an example of when it would be appropriate to use a web service as opposed to a non-serviced .NET component?

  
. Communicating through a Firewall When building a distributed application with 100s/1000s of users spread over multiple locations, there is always the problem of communicating between client and server because of firewalls and proxy servers. Exposing your middle tier components as Web Services and invoking the directly from a Windows UI is a very valid option.
. Application Integration When integrating applications written in various languages and running on disparate systems. Or even applications running on the same platform that have been written by separate vendors.
. Business-to-Business Integration This is an enabler for B2B intergtation which allows one to expose vital business processes to authorized supplier and customers. An example would be exposing electronic ordering and invoicing, allowing customers to send you purchase orders and suppliers to send you invoices electronically.
. Software Reuse This takes place at multiple levels. Code Reuse at the Source code level or binary componet-based resuse. The limiting factor here is that you can reuse the code but not the data behind it. Webservice overcome this limitation. A scenario could be when you are building an app that aggregates the functionality of serveral other Applicatons. Each of these functions could be performed by individual apps, but there is value in perhaps combining the the multiple apps to present a unifiend view in a Portal or Intranet.
. When not to use Web Services: Single machine Applicatons When the apps are running on the same machine and need to communicate with each other use a native API. You also have the options of using component technologies such as COM or .NET Componets as there is very little overhead.
. Homogeneous Applications on a LAN If you have Win32 or Winforms apps that want to communicate to their server counterpart. It is much more efficient to use DCOM in the case of Win32 apps and .NET Remoting in the case of .NET Apps
(More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


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