Dot(.) Net Learning

1.Compare SQL & PL/SQL Criteria SQL PL/SQL What it is Single query or command execution Full programming language What it comprises Data source for reports, web pages Application language to build, format and display report, web pages Characteristic Declarative in nature Procedural in nature Used for Manipulating data Creating applications 2.What is BCP? When is it used? It is a tool used to duplicate enormous quantity of information from tables and views. It does not facsimile the structures same as foundation to target. BULK INSERT command helps to bring in a data folder into a record, table or view in a user-specific arrangement. 3.When is the UPDATE_STATISTICS command used? This command is used, ones the processing of large data is done. When we delete a large number of files, alteration or reproduction takes place in the tables, to be concerned of these changes we need to restructure the indexes This is done UPDATE_STATISTICS. 4.Explain the steps n...

Xerox-Dot Net Interview Questions Managerial Round Xerox-Dot Net Managerial Round 1,Tell about your educational as well as on the technological achievements 2,Explain the architecture of your application. 3,How do you rate yourself in c#,Asp.net,Sql server 4,In three tier application what is the need of middle layer 5,Have you used Interface in your application .What do think about placing an interface for decoupling. 6,When should we use abstract  keyword over virtual keyword when designing a class 7,What are the types of access modifiers in c# 8,Whether a method with protected access modifier be available in the nth multilevel inheritance of      the particular class 9,How to make a property read only in C# 10,When a user requests for a page by entering Url in broser, what all actions are performed in    background for returning the page in asp.net 11,What are the various asp.net page life cycle events 12,What is the last asp.ne...

Xerox Dot Net interview questions Xerox - Dot net Interview question   1,When to use an abstract class in application 2,Difference between Abstract class and interface 3,What is static class and when is it used 4,Exception handling in c# 5,When to use finally statement in c# 6,What is the use of Ref and Out keyword and when it is used. 7,What checking are done if an exception is caught in catch block in c# 8,What are the types of authentication in asp.net application and how windows authentication is done. 9,Difference between view state and session 10,How to clear a session in asp .net 11,What is caching.How a page is cached in an asp.net application 12,What is cookies,when it is used ,what is the difference between cookies and view state. 13,How test cases are prepared in your application. 14,Error handling in SQL server 15,Query optimisation techniques in SQL 16,What is cute in SQL 17,what is the difference between table variable ,CTE and tempor...