youtube.com/jaganinfo

Monday, February 08, 2010

Digital Globals .Net Interview Questions

Digital GlobalsTechnical FAQs ( .NET , Database , General )

.NET Interview Questions
1.Difference between VB dll and assemblies in .NET
2.What is machine.config and web.config
3.Tell about WSDL
4.About web methods and its various attributes
5.What is manifest
6.Types of caching
7.What does connection string consists of
8.Where do you store connection string
9.What is the difference between session state and session variables
10.How do you pass session values from one page to another
11.What are WSDL ports
12.What is dataset and tell about its features. What are equivalent methods of previous, next etc. Of ADO in ADO.NET
13.What is abstract class
14.What is difference between interface inheritance and class inheritance
15.What are the collection classes
16.Which namespace is used for encryption
17.What are the various authentication mechanisms in ASP.NET
18.What is the difference between authentication and autherization
19.What are the types of threading models
20.How do you send an XML document from client to server
21.How do you create dlls in .NET
22.What is inetermediate language in .NET
23.What is CLR and how it generates native code
24.Can we store PROGID informatoin in database and dynamically load the component
25.Is VB.NET object oriented? What are the inheritances does VB.NET support.
26.What is strong name and what is the need of it
27.Any disadvantages in Dataset and in reflection
28.Advantage of vb.net over vb
29.What is runtime host
30.How to send a DataReader as a parameter to a remote client
31.How do you consume a webservice
32.What happens when a reference to webservice is added
33.How do you reference to a private & shared assembly
34.What is the purpose of System.EnterpriseServices namespace
35.About .Net remoting
36.Difference between remoting and webservice
37.Types of statemanagement techniques
38.How to register a shared assembly
39.About stateless and statefull webservice
40.How to invoke .net components from com components,give the sequence
41.How to check null values in dataset
42.About how soap messages are sent and received in webservice
43.Error handling and how this is done
44.Features in .net framework 1.1
45.Any problem found in vs.et
46.Optimization technique description
47.About disco and uddi
48.What providers does ado.net uses internally
49.Oops concepts
50.Disadvantages of vb
51.XML serialization
52.What providers do you use to connect to oracle database?

Database
53. Types of joins

General
54. What are various life cycle model in S/W development

Microsoft .Net Interview Questions

Microsoft Technical FAQs ( .NET , Database , General )

• HR (Screening)
1. Tell about yourself
2. Tell about your work experience
3. Tell about projects
4. Tell about your current project and your role in it
5. What is your current salary p.a.

• Technical

.NET
6. How do you manage session in ASP and ASP.NET
7. How do you handle session management in ASP.NET and how do you implement them. How do you handle in case of SQLServer mode.
8. What are different authentication types. How do you retreive user id in case of windows authentication
9. For a server control, you need to have same properties like color maxlength, size, and allowed character throughout the application. How do you handle this.
10. What is custom control. What is the difference between custom control and user control
11. What is the syntax for datagrid and specifying columns
12. How do you add a javascript function for a link button in a datagrid.
13. Does C# supports multi-dimensional arrays
14. How to transpose rows into columns and columns into rows in a multi-dimensional array
15. What are object oriented concepts
16. How do you create multiple inheritance in C#
17. ADO and ADO.NET differences
18. Features and disadvantages of dataset
19. What is the difference between and ActiveX dll and control
20. How do you perform validations
21. What is reflection and disadvantages of reflection
22. What is boxing and how it is done internally
23. Types of authentications in IIS
24. What are the security issues if we send a query from the application
25. Difference between ByVal and ByRef
26. Disadvantages of COM components
27. How do we invoke queries from the application
28. What is the provider and namespaces being used to access oracle database
29. How do you load XML document and perform validation of the document
30. How do you access elements in XML document
31. What is ODP.NET
32 Types of session management in ASP.NET
33. Difference between datareader and dataset
34. What are the steps in connecting to database
35. How do you register a .NET assembly
36. Usage of web.config
37. About remoting and web services. Difference between them
38. Caching techniques in .NET
39. About CLS and CTS
40. Is overloading possible in web services
41. Difference between .NET and previous version
42. Types of chaching. How to implement caching
43. Features in ASP.NET
44. How do you do validations. Whether client-side or server-side validations are better
45. How do you implement multiple inheritance in .NET
46. Difference between multi-level and multiple inheritance
47. Difference between dataset and datareader
48. What are runtime hosts
49. What is an application domain
50. What is viewstate
51. About CLR, reflection and assemblies
52. Difference between .NET components and COM components
53. What does assemblyinfo.cs consists
54. Types of objects in ASP

Database

55. What are the blocks in stored procedure
56. How do you handle exceptions. Give the syntax for it
57. What is normalization and types of normalization
58. When would you denormalize
59. Difference between a query and strored procedure
60. What is clustered and non-clustered indexes
61. Types of joins
62. How do you get all records from 2 tables. Which join do you use
63. Types of optimization
64. Difference between inline query and stored procedure

Project related
65. Tell about your current project
66. Tell about your role
67. What is the toughest situation you faced in the development
68. How often you communicate with the client
69. For what purposes, you communicate with the client
70. What is the process followed
71. Explain complete process followed for the development
72. What is the life cycle model used for the development
73. How do communicate with team members
74. How do you say you are having excellent team management skills
75. If your client gives a change and asks for early delivery. How will you manage.
76. How will gather requirements and where do you record. Is it in word / Excel or do you have any tool for that
77. What is the stage when code is delivered to the client and he is testing it.
78. What are the different phases of SDLC
79. How do you handle change requests
80. How do you perform impact analysis
81. How do you write unit test cases.
82. About current project architecture

Satyam .Net Interview Questions

Satyam Technical FAQs ( .NET , Database , General )
.NET Interview Questions

1.Types of threading models in VB.net
2. Types of compatability in VB and their usage
3. Difference between CDATA and PCDATA in XML
4. What is Assync in XML api which version of XML parser u worked with
5. Types of ASP objects
6. Difference between application and session
7. What is web application virtual directory
8. Can two web application share a session and application variable
9. If i have a page where i create an instance of a dll and without invoking any method can I send values to next page
10.Diffeernce between Active Exe and /Dll
11.Can the dictionary object be created in client’s ccope?
12.About MTS and it’s purpose
13.About writting a query and SP which is better
14.I have a component with 3 parameter and deployed to client side now i changed my dll method which takes 4 parameter.How can i deploy this without affecting the clent’s code
15.How do you do multithreading application in VB
16.About Global .asax
17.Connection pooling in MTS
18.If cookies is disabled in clinet browser will session work
19.About XLST
20.How do you attach an XSL to an XML in presenting output
21.What is XML
22.How do you make your site SSL enabled
23.Did you work on IIS adminisdtration

• HR questions
24. About educational background
25. About work experience
26. About area of work
27. Current salary, why are looking for a change and about notice period
28. About company strength, verticals, clients, domains etc.
29. Rate yourself in different areas of .NET and SQL

Sunday, February 07, 2010

TCS Technical .Net Interview Questions

TCS Technical FAQs ( .NET , Database , General )

.NET Interview Questions

1. Define .NET architecture

2. Where does ADO.NET and XML web services come in the architecture

3. What is MSIL code

4. Types of JIT and what is econoJIT

5. What is CTS, CLS and CLR

6. Uses of CLR

7. Difference between ASP and ASP.NET

8. What are webservices, its attributes. Where they are available

9. What is UDDI and how to register a web service

10. Without UDDI, is it possible to access a remote web service

11. How a web service is exposed to outside world

12. What is boxing and unboxing

13. What is WSDL and disco file

14. What is web.config and machine.config

15. What is difference between ASP and ASP.NET

16. What is dataset and uses of dataset

17. What does ADO.NET consists of?

18. What are various authentication mechanisms in ASP.NET

19. What do you mean by passport authentication and windows authentication

20. What is an assembly and what does manifest consists

21. What is strong name and what is the purpose of strong name

22. What are various types of assemblies

23. Difference between VB.NET and C#. Which is faster

24. Types of caching

25. How WSDL is stored

26. What is the key feature of ADO.NET compared to ADO

27. How does dataset acts in a disconnected fashion

28. Does the following statement executes successfully:

29.Response.Write(“value of i = ” + i);

30. What is ODP.NET

31. What are the providers available with VS.NET

32. What is a process

33. What is binding in web service

34. How a proxy is generated for a web service

35. About delegates

36. What are static assemblies and dynamic assemlies. Differences between them

Database Interview Questions

37. What are the types of triggers

38. Types of locks in database

39. Types of indexes. What is the default key created when a primary key is created in a table

40. What is clustered, nonclustured and unique index. How many indexes can be created on a table

41. Can we create nonclustured index on a clustered index

42. Types of backups

43. What is INSTEAD OF trigger

44. What is difference between triggers and stored procedures. And advantages of SP over triggers

45. What is DTS and purpose of DTS

46. Write a query to get 2nd maximum salary in an employee table

47. Types of joins.

48. What is currency type in database

49. What are nested triggers

50. What is a heap related to database

General Interview Questions

• HR Interview Questions

About yourdelf

About procsses followed

Notice period

Appraisal process

What is SOAP and why it is required

About effort estimation

Whether salary negotiable

Why are looking for a change

How fo you appraise a person

Do you think CMM process takes time

About peer reviews

How do you communicate with TL / PM / Onsite team

Infosys .Net Interview Questions

Infosys .Net Interview Questions ( .NET , Database , General )
.NET
1. How do you rate yourself in .NET
2. What is caching and types of caching
3. What does VS.NET contains
4. What is JIT, what are types of JITS and their pupose
5. What is SOAP, UDDI and WSDL

Database
6. What is dataset
7. How do you optimize SQL queries

General
8. Tell about yourself and job
9. Tell about current project
10. What are sequence diagrams, collaboration diagrams and difference between them
11. What is your role in the current project and what kinds of responsibilites you are handling
12. What is the team size and how do you ensure quality of code
13. What is the S/W model used in the project. What are the optimization techniques used. Give examples.
14. What are the SDLC phases you have invloved

Keane .Net Interview Questions

Keane .Net Interview Questions ( .NET , Database )
.NET
1. Write steps of retrieving data using ado.net
2. Call a stored procedure from ado.net and pass parameter to it
3. Different type of validation controls in asp.net
4. Difference between server.Execute and response.redirect
5. What is Response.Flush method
6. How Response.flush works in server.Execute
7. What is the need of client side and server side validation
8. Tell About Global.asax
9. What is application variable and when it is initialized
10. Tell About Web.config
11. Can we write one page in c# and other in vb in one application
12. When web.config is called
13. How many web.config a application can have
14. How do you set language in web.cofig

Database interview questions
15. How do you rate yourself in oracle and sql server
16. What is E-R diagram
17. Draw E-R diagram for many to many relationship
18. Design database raw er diagram for a certain scenario(many author many books)
19. Diff between primary key and unique key
20. What is Normalization
21. Difference between sub query and nested query
22. Indexes in oracle
23. Query to retrieve record for a many to many relationship
24. Query to get max and second max in oracle in one query
25. Write a simple Store procedure and pass parameter to it

DELL .Net Interview Questions

DELL .Net Interview Questions ( .NET , Database , General )

.NET

1. Any disadvantages in Dataset and in reflection

2. Difference between Active Exe and Activex dll

3. Can we make activex dll also ti execute in some process as that of client ? How can we do?

4. Types of compatabilities and explain them

5. Types of instancing properties and explain each. Tell the difference between multiuse,singleuse and globalmultiuse and which is default

6. What is assembly?

7. Difference between COM and .NET component

8. What is early binding and Late binding. Difference which is better

9. What happens when we instantiate a COM component

10. What happens when we instantiate a .NET component

11. Are you aware of containment and Aggregation

12. What is UUID and GUID what is the size of this ID?

13. About Iunknown interface Queue ,its methods Querry Interface Addref,Release and Explane each

14. What ‘ll u do in early and late binding

15. In early binding will the method invoked on com component will verify it’s existance in the system or not?

16. Difference between dynamic query and static query

17. About performance issues on retrieving records

18. About ADO and its objects

19. What is unmannaged code and will CLR handle this kind of code or not .

20. Garbage collector’s functionality on unmanaged code

21. If Instancing = Single use for ActiveX Exe, how will this be executed if there are 2 consecutive client requests ?

22. Threading Types.

23. How about the security in Activex DLL and Activex EXE

Database Interview Questions :

24. Types of cursors and explanation each of them

25. Types of cursor locations and explanation on each of them

26. Types of cursor locks and explanation each of them

27. How do you retrieve set of records from database server.{Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

Tell Me about Yourself

“Tell Me about Yourself” Interview Questions and Answers

In brief: “During a job interview, the interviewer can ask many questions. Some of the common questions are the ‘Tell Us about Yourself’ interview questions. Your answers to these questions are important. Make sure that you are prepared for these types of interview questions.”

A job interview is one of the most important personal interactions that an individual does. It is therefore utmost important that a person is well prepared for every aspect of a job interview. In fact, most of the interview time schedule is spent on many aspects of the tough interview questions - “Tell Me about Yourself” and your interview answers.

4 common “Tell Me about Yourself” interview questions and answers

1. A brief summary of your personal details: Your have to give your name, where you are from, your family members and a brief review of your resume. You may also provide any other personal detail that you would feel like providing.

2. Education: You should tell the interviewee about your educational qualifications and any relevant miscellaneous educational qualifications that you might have accumulated.

3. Professional experience: Regular questions during a job interview are “tell me about your professional experience”. Depending on whether you are a fresher or an experienced professional, you should share your previous job experiences. If you are a fresher, then, you could tell anything that you think would be relevant for the job. You may provide a scope of your educational capabilities and strengths or any of your hobbies, etc.

4. Your weaknesses and strengths: One of the tricky interview questions that you might be asked is “tell me about your weaknesses and/or strengths”. Therefore, you should make a preparation to such questions. A common mistake is to take strength and present it as a weakness. You should be honest. You may share one-two of your weaknesses and the way you have correct or handled (successfully) these weaknesses. On the other hand, do not boast your strengths. Tell about some of your strengths as positive impacts to your professional capabilities.

6 Tips for “Tell Me about Yourself” interview answers

Try to be as much clear, precise and frank. When interviewing and answering “tell me about yourself” questions, you should avoid common mistakes and stick to the facts as follows:

1. Keep the information crisp and relevant: One of the first things to remember is to keep the information crisp and relevant. Try to speak in short sentences and further, try to give them as much of information in as less a timeframe. Here is a brief idea of what you would be saying:

2. Do not repeat information from the CV: You should ensure that none of the information that you provide about yourself is repeated or duplicate as compared to your curriculum vitae. Therefore, even your curriculum vitae should have only the necessary and relevant information, while all other miscellaneous information should be disclosed during the ‘tell me about yourself’ answers.

3. Fabricated or fake information: Another important thing that you should remember is that you should not give any fabricated or fake information while answering the Tell Me about Yourself Interview question. Background checks today have become very important and strict. Companies are known to sack people even after years of working, simply on the basis of some false information provided to them during the initial interview.

4. Irrelevant and unnecessary information: It is very important that no irrelevant and unnecessary information is given out during the question. The question seems to be quite simple, but it is actually one of those make or break questions, from which an interviewee can never recover and therefore loses the job opportunity.

5. Facts and figures: While telling about yourself, be prepared to be asked further questions about any facts and figures that you have provided. For example, if you have said that you have a Bachelor’s degree, make sure that you carry a copy of the same. Any information given without the relevant proof for it is deemed as suspicious and ambiguous.

6. Do Not Tell them about: You should not disclose too much information for the interviewer. You might tell that your hobby is fishing, but telling about your last fishing trip in which you missed a big fish would be too much information, unless the interviewer is a big fishing fan and actually goads you into telling the details. Also, you should not give them too much information about your family members. Of course, you would have to inform them about the number of family members that you have, and whether they work or not, and if yes, where, those kinds of details, but telling them anything apart from that is not suggested.

ALL IS WELL ... ALL THE BEST

Wipro Infotech .NET interview Questions

Wipro Infotech .NET interview Questions (05Feb2010)

1. when you will use HttpHandlers

2. what you will impiment in HttpModule

3. In the Page , suppose in preRender value=x and in the pageload value=y after page loads which value will be displayed.

4. how you will improve the webapplication performance.

5. What is Agile methodology ? which methodolgy followed in your project ?

6. How many members can be work by implimenting Scrum/Iteration methods ?

7. What is Ajax ?

8. Difference between Asynchronous and Synchronous ?

9. which is the best gridview or repeater

10. exception handling in stored proc.. how you will catch an error message

11. exception handling in asp.net application..(expecting log files to be create in production live )

12. how many members involve in scrum methodology

13. how u implimented design patterns in ur projects

14. how you will reduce the page size

15. what will happen if we use response.buffer and response.flush

16. how u will refresh the page using .net code

17. what is webservice

18. what is soap

19. how u will consume the webservice in asp.net application

20. how u will set proxy to access webservice

21. what is wsdl

22. Windows and Forms Authentication

24. In Forma Authentication how you will validate the users if it is in database

25. When you will use State Server and SqlServer

26. State Management

27. Valid XML format

28. programming : Write a code in Ajax ,select one dropdownlist based on that it should reflect in another dropdownlist

29. programming : In table , having States as a coulmn. based on coumn it should be displayed a record using DataTable

30. programming : select dropdownlist based on that it should be displayed on Gridview

31. programming : In gridview, first column value should be displayed tooltip

32. programming : need to popup dialog box every 20 min ok and cancel button should be displayed

in the ok button and the cancel button code what code you will write.

Wipro Sharepoint Interview Questions

Wipro Infotech Sharepoint Interview Questions (MOSS)

1) Can you introduce your self ? What is your Responsibilities in This Project..?

2) Have you ever worked on Master page..? What is the use of master page..? Can you tell me , I want to put the

Dropdown control in master page, and this dropdown control should populate the data from database..?

3) How can you create and deploy the workflows by using Visualstudio 2005, tell me the stepwise

4) Can you tell me how to create the HRLeaveapproval workflow by using SPDesinger..?

5) What is the use of infopathforms.?
I have the List called ”Employees”,in that there is a Field called ” Department”,
I want to Fill the Department names in the infopathform control
( eg: Take the Dropdown control , i want to fill this Department names in Dropdowncontrol)

6) 10 users entering the data in infopath forms and submit the data,
now i want to generate the reports for those 10 users, how can you do this ..?

7) What is the use of BDC…?

8) How can you Configure the Enterprise Search ..?

9) What are the Base class methods you used in developing custom webparts..?

10)How many ways you can deploy the custom webparts ? with out install in GAC,
is there any other way to deploy ..?

11) About Execl Services,

12) Feature event receivers Classes…?

13) What is the use of “Run with elevated Previliages”…?

BlueStar Infotech .Net Interview Questions

BlueStar Infotech .Net Interview Questions

1)Interfaces and Abstract classes
( Definitions , Advantages , differences , on which scenarious you will iplimemnt both )

2) OutputCache (How you will impliment Cache in your application )

3) Tell me about OOPS concept

4) What is Polymorphism, explain the scenario

5) What are the Securites in WCF

6) what is CLS (Common Language Specification ) ?

7)Assembly
(Definition , types (private and shared assembly) brief explanation

8) Clustered and Non-clustered index

9) what is WCF, WPF , WWF, WCS

10) Userlevel securites

11) what is Encapuslation

12) what is Endpoint?

13) How u will host in WCF

14 Sessions , Cookies , Caching

Sql Server Interview Ouestion :

15) table structure

16) Sql server 2005 features

17) eXCEPTIONAL HANDLING IN sQLSERVER 2005

18) Did you ever tried with LINQ give me the example

19) StateManagement

20) Differences between functions and StoredProcedures

21) what is Instead of Trigger

22) Stored Procedures

13) What is Lock ?

14) What is Optimistic and Pessimitic in (locking , Cursors)

17) views

22) table structure

23) Sql server 2005 features

24) eXCEPTIONAL HANDLING IN sQLSERVER 2005

KARVY .Net Interview Questions

KARVY .Net Interview Questions
-----

1. What is ViewState (brief description)
2. what will happen if put runat="server"
3. page load events
4. Caching in asp.net
5. IsPostBack
6. difference between HTML controls and web controls
7. Regular Expressions
8. abstract class and interfaces

SQL Server Interview Questions
-----------
9. select * from employee where 10000=20000

10. select * from employee e1 where e1.col1=1

11. select * from employee e1 where ename not in
(select * from employee e2 where e2.creativedat<='01/11/91')

Digital Globals .Net Interview Questions

Microsoft .Net Interview Questions

Satyam .Net Interview Questions

TCS Technical .Net Interview Questions

Infosys .Net Interview Questions

Keane .Net Interview Questions

DELL .Net Interview Questions

Wipro Infotech .NET interview Questions

Wipro Sharepoint Interview Questions

BlueStar Infotech .Net Interview Questions

KARVY .Net Interview Questions

Microsoft SqlServer Interview Questions

NessTechnologies .Net Interview Questions

ValueLabs .Net Ineterview Questions

ValueLabs NET Technical Paper

Microsoft SqlServer Interview Questions

1) what are the new features in SqlServer 2008 ?

2) what is the purpose of MERGE in SqlServer 2008?
why do we need ?

3) How many tables can we create in single database ?
Can we create 1 lakh tables in a single database ?

4) How many columns can we create in a single table ?
Can we insert data which having datatype varchar(8000) for each column ?

5) Where can we get total rowcount ?

6) Insert a query by using single quote .
Suppose Employee is a table, Ename is column.
How you will insert Jagan's Interview in Ename column

7) Brief description of Delete & Truncate

8) What is the use of identity ?
for suppose total 10 rows are in a table
Identity is (1,1) and i deleted all rows by using Delete statement
if i inserted 11th row in a table. What will be the identity value
if i truncated all rows and if i inserted 11th row in a table.
What will be the identity value (give me brief explanation)

9) Can we drop Clustered index without dropping a primary key.
Can we created Clustered index in another column. what Clustered index will do

10) I want to delete a record and i want to insert that record in another table.
Write a query in a single statement.
Ans) need answer

11) what is Unit testing and integrated testing ?
if i'm modifying a column datatype varchar(100) to varchar(50) in database.
Now the application is in production ? Are you will do Unit testing or Integrating testing.
Is it will effect to application ? did we need to check the validation ?

12) Have you worked on DTS package ?

13) Have you worked on SSIS ?

NessTechnologies .Net Interview Questions

1. Differences .NET Framework versions ( 2.0 , 3.0 , 3.5 )

2. LINQ ( samples ) , Advantages / Disadvantages

3. WCF Services

4. Web services - Java cosumptions

5. Web services -exposing

6. ASP.net - any deploying problems

7. Hosting Environment

8. ASP.net page life cycle

9. Authentication and Authorization

10. Assemblies ( GAC , Load , diff versions - > bending redirect )

11. Generics - Advantages

12. static constructors and static methods

13. Callbacks ( Scripts callbacks )

14. Asynchronous callbacks using Delegates

15. DOM parsers

16. Ctype and Ptype

17. Design patterns

18. String and String.Builder

19. state management

20. Array Reverse

21. interface and abstract

22. polymorphism

23. Enterprice library differences (hpw u will replace 4.0 on 3.0)

SQL Server Interview Questions:

24. How u will pass parameters in procedure through programming ( count of paramters )

25. sp_help_text

26. how to find duplicate records and to delete

27. cursors

28. indexing

29. excepting handling in stored proc

ValueLabs .Net Ineterview Questions

1.Give some Scenario for Non Clustered index?

2.Can we write system defined functions in side The Function?

3.What is the Unique Data type?

4.I have a table in which phno is one of the columns.i do have some values in tht phno column.
i need to update phno column values with 0(zero) as prefix.give me a correct solution plz.

5.what is IDE,DMV in sql server?

6.Where is global assembly cache located on the system?

7.What is the difference between functional test type and navigation test type?

8.What is an assembly?

9.Give difference between Intranet application, client server application, and web based application
Are applications developed in Java, html, servletts client server or web based..

10.Is web based application a 2 tier or 3 tier application.

11.what is 2 tier and 3 tier application.

12.How can we Achieve Late binding in C#.Can any give one example.

13.Difference between regression testing and re-testing

14.how u get the build ?what is the size of the build?

15.Can we share session between ASP.Net & ASP

16.Which Security Algorithm used to encrypt the data? a) DES b)RC2 c)Triple DES d)All the above

17.Can we Classic ASP,.Net 1.0, .Net 1.x and .Net 2.0 installed on the same system?

18.what is the difference between HashMap and Hashtable

19.Difference between DataGrid and Girdview?

20.Difference b/w .Net 2.0, 3.0 and 3.5 ?

21.Diff b/w dispose & Finalize Methods?

SQL Server Interview Questions :
1.What is the difference Between Sql-server 2000 & 2005

2.What is the use of placing primary key and foreign key constrains on columns.

3.What is the difference between distinct clause and group by clause?

4.Can I remove the default constraint columns in SQL SERVER?

Saturday, February 06, 2010

ValueLabs NET Technical Paper

Value Labs .NET Technical Paper (60MINUTES)

1. WRITE A PROGRAM THAT ASKS A USER A FOR 5 NUMBERS AND PRINTS THE AVERAGE OF THESE NUMBERS.

2. WRITE A PROGRAM THAT PROCESSES THE FOLLOWING STRING :

STRING SENTENCE =”LEARNING”C# IS EXTREMELY EASY &FUN,ESPECIALLY AT
PROGRAMMERS HEAVEN ! C#HAS A DATA TYPE BYTE WHICH OCCUPIES 8 BITS AND
CAN STORE INTEGERS FROM -128 TO 127 .”;

Iterate through the string and find the number of letters , digits and
punctuation characters in it and print these to the console.

3.Can we override the properties and apply polymorphism on these?

4.When I compile and run the following program what’s the output?

using System;
namespace CSharp
{
Class Test
{
static void Main()
{
Parent theparent=new Child();
Console.Writeline (“i={0}”, theParent.i);
theParent.MyMethod( );
}
}

class Parent
{
public int i = 5;
public virtual void MyMethod( )
{
Console.Writeline(“I am parent’s mymethod( )”);
}
}
}

class Child : Parent
{
public int i =7;
public override void MyMethod( )
{
Console.Writeline(“I am Child’s mymethod( )”;
}
}
}

5. what is the difference between the destructor and the Finalize( ) method?
When does the Finalize( ) method get called?
6. Abstract classes may contain constructors. When we can’t instantiate the
Abstract classes, what is the use of these constructors?

7. We all know that sub-classes can call the methods defined in the base-class .
Write a program where a base-class calls the method defined in the subclass ?

8. What is the basic difference between the String and the StringBuilder class ?
What is the difference between the Intern() and Copy() methods of the string class ?

9. what are delegates ? what are the steps involved in creating an event ? Please explain this by writing a code .

10. How can we know a state of a thread ?

11. what is .NET Remoting ? which class does the remote object has to inherit ?

12. How can we call methods in remoting asynchronously ? What is Asynchronous One-Way Calls ?

13. What is marshalling and what are different kinds of marshalling ?

14. what are custom controls ? Write a code which defines how to create and use a custom control in ASP.NET ?

15. What are different ways by which a control can be binded with client side scripts in ASP.Net ?

16. Write a code to load and use a dll dynamically in ASP.NET .

17. Write a validation expression for a textbox whose valid format should be in form of hh:mm ( where “hh” signifies as hour between 0-23 and “mm” signifies minutes between 0-59).

18. Write a code to build a datagrid in ASP.NET which displays EmployeeId , name and hiredate. Write the query also to get the same.

19. Related to question 18 above write a code to display the employee Address details in a poop up window which will be displayed on clicking on Employee details in a popup window which will be displayed on clicking on Employee ID. Make sure that there is no DB hit for the second time.

20. What are the disadvantages of viewstate in ASP.NET.

Tuesday, August 11, 2009

Microsoft Robocopy GUI Free Download and Robocopy Command Lines

Microsoft Robocopy GUI Free Download

Robocopy is an advanced copy utility with has the feature to automatically resume file transfer on error or network disruption, or recover from terminated file copying, plus selective copying based on new or updated criteria. Beside, Robocopy also can preserve all of the file properties and information, including date and time stamps, security access control lists (ACLs) and more while replicating the file. Robocopy is definitely a more useful utility, especially for advanced users. However, Robocopy came built-in in Windows Vista with command line interface only. To ease the task of using Robocopy, a GUI (graphical user interface) has been made available by Microsoft.
Robocopy GUI lets you specify your source and target paths, as well as any custom options or filters you’d like to apply, whether or not you’d like to create a drive mapping, where you’d like to store the resulting logs, and so on. These are all features you can certainly execute with traditional Robocopy command line functionality, but for many, having the options consolidated in a graphical interface may really simplify the process.

Robocopy GUI also extends the functionality of the existing Robocopy tool in some very interesting ways. For example, this tool is multithreaded, allowing you to create a Robocopy script, execute it, and begin creating another one while your first script is still running. It also allows you to save your scripts (even if you don’t actually execute them) so that you can create a library of common scripts or share them with your colleagues. And most importantly, Robocopy GUI allows you to save your default settings so you don’t have to start from scratch every time.

Free Download :
http://download.microsoft.com/download/f/d/0/fd05def7-68a1-4f71-8546-25c359cc0842/UtilitySpotlight2006_11.exe

Robocopy Syntax, Command Line Switches and Examples

Robocopy (Robust File Copy) is a command-line file copying tool in Windows Vista. Although Robocopy is available for free with the download Windows
Resource Kit since Windows NT 4.0, it has never been an official feature of the operating system until the arrival of Vista. Unlike other built-in file copying commands such as Copy and XCopy, Robocopy is designed for reliable copy or mirroring of entire folders of any size, and in the copying process, ensure that all NTFS ACLS, attributes, owner information, alternate data streams, auditing information, timestamps and properties are copied except security information unless explicitly requested with /COPYALL switch. And best of all, Robocopy works over network connections that are subject to disruption or outages with resume copying feature, and has progress indicator on the command line that is useful when copying large files.

Robocopy Syntax

ROBOCOPY source destination [file [file]…] [options]

where source is Source Directory (drive:\path or \\server\share\path), destination is Destination Directory (drive:\path or \\server\share\path) and file is File(s) to copy where names or wildcards can be specified and default is “*.*” (all files).

Robocopy Options and Switches

Copy options :

/S :: copy Subdirectories, but not empty ones.
/E :: copy subdirectories, including Empty ones.
/LEV:n :: only copy the top n LEVels of the source directory tree.

/Z :: copy files in restartable mode.
/B :: copy files in Backup mode.
/ZB :: use restartable mode; if access denied use Backup mode.
/EFSRAW :: copy all encrypted files in EFS RAW mode.

/COPY:copyflag[s] :: what to COPY for files (default is /COPY:DAT).
(copyflags : D=Data, A=Attributes, T=Timestamps).
(S=Security=NTFS ACLs, O=Owner info, U=aUditing info).

/DCOPY:T :: COPY Directory Timestamps.

/SEC :: copy files with SECurity (equivalent to /COPY:DATS).
/COPYALL :: COPY ALL file info (equivalent to /COPY:DATSOU).
/NOCOPY :: COPY NO file info (useful with /PURGE).

/SECFIX :: FIX file SECurity on all files, even skipped files.
/TIMFIX :: FIX file TIMes on all files, even skipped files.

/PURGE :: delete dest files/dirs that no longer exist in source.
/MIR :: MIRror a directory tree (equivalent to /E plus /PURGE).

/MOV :: MOVe files (delete from source after copying).
/MOVE :: MOVE files AND dirs (delete from source after copying).

/A+:[RASHCNET] :: add the given Attributes to copied files.
/A-:[RASHCNET] :: remove the given Attributes from copied files.

/CREATE :: CREATE directory tree and zero-length files only.
/FAT :: create destination files using 8.3 FAT file names only.
/256 :: turn off very long path (> 256 characters) support.

/MON:n :: MONitor source; run again when more than n changes seen.
/MOT:m :: MOnitor source; run again in m minutes Time, if changed.

/RH:hhmm-hhmm :: Run Hours – times when new copies may be started.
/PF :: check run hours on a Per File (not per pass) basis.

/IPG:n :: Inter-Packet Gap (ms), to free bandwidth on slow lines.

File Selection Options :

/A :: copy only files with the Archive attribute set.
/M :: copy only files with the Archive attribute and reset it.
/IA:[RASHCNETO] :: Include only files with any of the given Attributes set.
/XA:[RASHCNETO] :: eXclude files with any of the given Attributes set.

/XF file [file]… :: eXclude Files matching given names/paths/wildcards.
/XD dirs [dirs]… :: eXclude Directories matching given names/paths.

/XC :: eXclude Changed files.
/XN :: eXclude Newer files.
/XO :: eXclude Older files.
/XX :: eXclude eXtra files and directories.
/XL :: eXclude Lonely files and directories.
/IS :: Include Same files.
/IT :: Include Tweaked files.

/MAX:n :: MAXimum file size – exclude files bigger than n bytes.
/MIN:n :: MINimum file size – exclude files smaller than n bytes.

/MAXAGE:n :: MAXimum file AGE – exclude files older than n days/date.
/MINAGE:n :: MINimum file AGE – exclude files newer than n days/date.
/MAXLAD:n :: MAXimum Last Access Date – exclude files unused since n.
/MINLAD:n :: MINimum Last Access Date – exclude files used since n.
(If n < n =" n" n =" YYYYMMDD">

/XJ :: eXclude Junction points. (normally included by default).

/FFT :: assume FAT File Times (2-second granularity).
/DST :: compensate for one-hour DST time differences.

/XJD :: eXclude Junction points for Directories.
/XJF :: eXclude Junction points for Files.

Retry Options :

/R:n :: number of Retries on failed copies: default 1 million.
/W:n :: Wait time between retries: default is 30 seconds.

/REG :: Save /R:n and /W:n in the Registry as default settings.

/TBD :: wait for sharenames To Be Defined (retry error 67).

Logging Options :

/L :: List only – don’t copy, timestamp or delete any files.
/X :: report all eXtra files, not just those selected.
/V :: produce Verbose output, showing skipped files.
/TS :: include source file Time Stamps in the output.
/FP :: include Full Pathname of files in the output.
/BYTES :: Print sizes as bytes.

/NS :: No Size – don’t log file sizes.
/NC :: No Class – don’t log file classes.
/NFL :: No File List – don’t log file names.
/NDL :: No Directory List – don’t log directory names.

/NP :: No Progress – don’t display % copied.
/ETA :: show Estimated Time of Arrival of copied files.

/LOG:file :: output status to LOG file (overwrite existing log).
/LOG+:file :: output status to LOG file (append to existing log).

/UNILOG:file :: output status to LOG file as UNICODE (overwrite existing log).
/UNILOG+:file :: output status to LOG file as UNICODE (append to existing log).

/TEE :: output to console window, as well as the log file.

/NJH :: No Job Header.
/NJS :: No Job Summary.

/UNICODE :: output status as UNICODE.

Job Options :

/JOB:jobname :: take parameters from the named JOB file.
/SAVE:jobname :: SAVE parameters to the named job file
/QUIT :: QUIT after processing command line (to view parameters).

/NOSD :: NO Source Directory is specified.
/NODD :: NO Destination Directory is specified.
/IF :: Include the following Files.

Robocopy Example:

To use Robocopy is simple, just like how you would use Copy and Xcopy commands.
For example, to copy entire folder of C:\Data to C:\DataBackup, simply type:

Robocopy C:\Data C:\DataBackup

Monday, July 20, 2009

Tips To Increase Immediate Traffic To Your Site

1.Get traffic from uploading videos in the internet ,This is the one of the best ways to get traffic.There is a website
called tubemogul where you can upload videos to all video websites.By the way just uploading is only to get traffic ,you should describe why your site is for ,what information is given in your site. then the visitors drive to you immediately .This is the good way to drive traffic.

2.Get traffic from article writing.How would i get traffic from article writing? articlewriting make your blog at the top by search engine optimisation,How?Why?

In your article your blog is named thats why the google see all pages of article sites .Why Google see all page of article sites? Article websites are having good page rank thats why Google watches the article websites.Like That you will get traffic

3.Getting traffic from Some cool Websites Like Blogcatalog,Bumpzee,My Bloglog. These websites are useful for blog website you can make friends with bloggers and exchange information as they are having good page rank.This will help Bloggers
to connect and share with them.

4.Getting traffic from the website called orkut,face book ,these websites
are friendly websites this will help bloggers to get traffic .The friends of you will see your blog is.Get traffic from these websites

5.Search Engine Optimisation will help you to get traffic to the site.Getting traffic from search engines is good idea.

How to get my site in search engines?

the search engines sees the header tag afterwards it see the title tag and search engine also see how many back links there to your site like this search engines see your website and also search engines checks how many ip adresses are having back link with you .Like this google checks the site

6.Get Traffic from banner exchanges .How would i exchange banners?.See that means getting back links indirectly .This will help you to improve traffic these are the real methods to get traffic.

#1 - Search Engine Listings

Obviously, if you are not listed with the major search engines, people who go to search engines to search for different products and information will not stumble upon your website. Start with the larger more popular search engines and get your URL listed. This does not take a lot of time to get started and is something you should do immediately.

#2 - Search Engine Optimization

Getting listed with the search engines is important, but optimizing your site so that it ranks well is equally important. Find out what keywords people are searching for regarding your content and then include them on your website to get more traffic.

#3 - Quality Content

Quality content is important if you want large search engines to list you, and it is also a great way to include the many keywords you will need to drive up your ranking in the search engines and to get more people to visit your site. Also, if you have quality content once the visitors are at your site, they will be more likely to stay.

#4 - Trade Links

Trading links with other websites can be done as quickly as propositioning another site through an email. The more links you have to your website, the more traffic you will receive. Plus, lots of links help you climb to the top of the search engines as well, which is very important for driving visitors to your website.

#4: Submit your articles

Any articles that you write should be submitted to as many sites that accept articles as possible. This is important because sites that accept and include your articles in their article banks establish links for you and you are not obligated to reciprocate.

#5: create and upload videos increases traffic

Many people dont create a videos of their products and the information that the blog or website provides in the internet,uploading videos in the popular websites like youtube,msn,yahoo,myspace will increases not only traffic it also increases page rankings of the Blog or website.

#6: social bookmarking sites
The sites like digg.com , delicious.com are the bookmarking sites that helps the blogs to get traffic, it also gives backlink to your blogs which helps in increasing page ranking.

Thursday, July 16, 2009

Jokes, Cartoon , Humour , Funny Jokes …sites and links

This summary is not available. Please click here to view the post.