Social Icons

Thursday, March 29, 2012

Why We Shout In Anger

A Hindu saint who was visiting river Ganges to take bath found a group of family members on the banks, shouting in anger at each other. He turned to his disciples smiled and asked.


'Why do people shout in anger shout at each other?'
Disciples thought for a while, one of them said, 'Because we lose our calm, we shout.'


'But, why should you shout when the other person is just next to you? You can as well tell him what you have to say in a soft manner.' asked the saint
Disciples gave some other answers but none satisfied the other disciples.
Finally the saint explained, .


'When two people are angry at each other, their hearts distance a lot. To cover that distance they must shout to be able to hear each other. The angrier they are, the stronger they will have to shout to hear each other to cover that great distance.

What happens when two people fall in love? They don't shout at each other but talk softly, Because their hearts are very close. The distance between them is either nonexistent or very small...'
The saint continued, 'When they love each other even more, what happens? They do not speak, only whisper and they get even closer to each other in their love. Finally they even need not whisper, they only look at each other and that's all. That is how close two people are when they love each other.'


He looked at his disciples and said.
'So when you argue do not let your hearts get distant, Do not say words that distance each other more, Or else there will come a day when the distance is so great that you will not find the path to return.'
Hope you found this answer both enlightening as well as useful in your life :)

Source:facebook

WHY VISIT TEMPLES ? (Scientific Reason)

There are thousands of temples all over India in different size, shape and locations but not all of them are considered to be built the Vedic way. Generally, a temple should be located at a place where earth's magnetic wave path passes through densely. It can be in the outskirts of a town/village or city, or in middle of the dwelling place, or on a hilltop. The essence of visiting a temple is discussed here.

Now, these temples are located strategically at a place where the positive energy is abundantly available from the magnetic and electric wave distributions of north/south pole thrust. The main idol is placed in the core center of the temple, known as "*Garbhagriha*" or *Moolasthanam*. In fact, the temple structure is built after the idol has been placed. This *Moolasthanam* is where earth’s magnetic waves are found to be maximum. We know that there are some copper plates, inscribed with Vedic scripts, buried beneath the Main Idol. What are they really? No, they are not God’s / priests’ flash cards when they forget the *shlokas*. The copper plate absorbs earth’s magnetic waves and radiates it to the surroundings. Thus a person regularly visiting a temple and walking clockwise around the Main Idol receives the beamed magnetic waves and his body absorbs it. This is a very slow process and a regular visit will let him absorb more of this positive energy. Scientifically, it is the positive energy that we all require to have a healthy life.

Further, the Sanctum is closed on three sides. This increases the effect of all energies. The lamp that is lit radiates heat energy and also provides light inside the sanctum to the priests or *poojaris* performing the pooja. The ringing of the bells and the chanting of prayers takes a worshipper into trance, thus not letting his mind waver. When done in groups, this helps people forget personal problems for a while and relieve their stress. The fragrance from the flowers, the burning of camphor give out the chemical energy further aiding in a different good aura. The effect of all these energies is supplemented by the positive energy from the idol, the copper plates and utensils in the *Moolasthan*am / *Garbagraham*. *Theertham*, the “holy” water used during the pooja to wash the idol is not plain water cleaning the dust off an idol. It is a concoction of Cardamom,*Karpura* (Benzoin), zaffron / saffron, *Tulsi* (Holy Basil), Clove, etc...Washing the idol is to charge the water with the magnetic radiations thus increasing its medicinal values.

Three spoons of this holy water is distributed to devotees. Again, this water is mainly a source of magneto-therapy. Besides, the clove essence protects one from tooth decay, the saffron & *Tulsi* leafs protects one from common cold and cough, cardamom and *Pachha Karpuram* (benzoin), act as mouth fresheners. It is proved that *Theertham* is a very good blood purifier, as it is highly energized. Hence it is given as *prasadam* to the devotees. This way, one can claim to remain healthy by regularly visiting the Temples. This is why our elders used to suggest us to offer prayers at the temple so that you will be cured of many ailments. They were not always superstitious. Yes, in a few cases they did go overboard when due to ignorance they hoped many serious diseases could be cured at temples by deities. When people go to a temple for the *Deepaaraadhana*, and when the doors open up, the positive energy gushes out onto the persons who are there.

The water that is sprinkled onto the assemblages passes on the energy to all. This also explains why men are not allowed to wear shirts at a few temples and women are requested to wear more ornaments during temple visits. It is through these jewels (metal) that positive energy is absorbed by the women. Also, it is a practice to leave newly purchased jewels at an idol’s feet and then wear them with the idol’s blessings. This act is now justified after reading this article. This act of “seeking divine blessings” before using any new article, like books or pens or automobiles may have stemmed from this through mere observation.

Energy lost in a day’s work is regained through a temple visit and one is refreshed slightly. The positive energy that is spread out in the entire temple and especially around where the main idol is placed, are simply absorbed by one's body and mind. Did you know, every Vaishnava(Vishnu devotees), “must” visit a Vishnu temple twice every day in their location. Our practices are NOT some hard and fast rules framed by 1 man and his followers or God’s words in somebody’s dreams. All the rituals, all the practices are, in reality, well researched, studied and scientifically backed thesis which form the ways of nature to lead a good healthy life.

The scientific and research part of the practices are well camouflaged as “elder’s instructions” or “granny’s teaching’s” which should be obeyed as a mark of respect so as to once again, avoid stress to the mediocre brains.

Source:facebook

Thursday, March 22, 2012

Interview Questions :- . SQL

Q1 - Write a query to find the total number of rows in a table

A1 - Select count(*) from t_employee;

Q2 - Write a query to eliminate duplicate records in the results of a table

A2 - Select distinct * from t_employee;

Q3 - Write a query to insert a record into a table

A3 - Insert into t_employee values ('empid35','Barack','Obama');

Q4 - Write a query to delete a record from a table

A4 - delete from t_employee where id='empid35';

Q5 - Write a query to display a row using index

A5 - For this, the indexed column of the table needs to be set as a parameter in the where clause

select * from t_employee where id='43';

Q6 - Write a query to fetch the highest record in a table, based on a record, say salary field in the t_salary table

A6 - Select max(salary) from t_salary;

Q7 - Write a query to fetch the first 3 characters of the field designation from the table t_employee

A7 - Select substr(designation,1,3) from t_employee; -- Note here that the substr function has been used.

Q8 - Write a query to concatenate two fields, say Designation and Department belonging to a table t_employee

Select Designation + ‘ ‘ + Department from t_employee;

Q9 -What is the difference between UNION and UNION ALL in SQL?

A9 - UNION is an SQL keyword used to merge the results of two or more tables using a Select statement, containing the same fields, with removed duplicate values. UNION ALL does the same, however it persists duplicate values.

Q10 - If there are 4 SQL Select statements joined using Union and Union All, how many times should a Union be used to remove duplicate rows?

A10 - One time.

Q11 - What is the difference between IN and BETWEEN, that are used inside a WHERE clause?

A11 - The BETWEEN clause is used to fetch a range of values, whereas the IN clause fetches data from a list of specified values.

Q12 - Explain the use of the ‘LIKE’ keyword used in the WHERE clause? Explain wildcard characters in SQL.

A12 - LIKE is used for partial string matches. The symbol ‘%’ ( for a string of any character ) and ‘_’ (for any single character ) are the two wild card characters used in SQL.

Q13 - What is the need to use a LIKE statement?

A13 - When a partial search is required in a scencario, where for instance, you need to find all employees with the last name having the sequence of characters "gat", then you may use the following query, to match a search criteria:

Select empid, firstname, lastname from t_employee where lastname like ‘%gats%’

This might search all employees with last name containing the character sequence 'gats' like Gates, Gatsby, Gatsburg, Sogatsky, etc.

% is used to represent remaining all characters in the name. This query fetches all records contains gats in the e middle of the string.

Q14 - Explain the use of the by GROUP BY and the HAVING clause.

A14 - The GROUP BY partitions the selected rows on the distinct values of the column on which the group by has been done. In tandem, the HAVING selects groups which match the criteria specified.

Q15 - In a table t_employee, the department column is nullable. Write a query to fetch employees which are not assigned a department yet.

A11.  Select empid, firstname, lastname from t_employee where department is null;

Q16 -What are the large objects supported by oracle and db2? What are the large objects supported in MS SQL?

A16 - In Oracle and DB2 BLOB , CLOB ( Binary Large Objects, Character Large Objects) are used.

In MS SQL - the data types are image and varbinary.

Q17 - Whats the capacity of the image data type in MS SQL?

A17 - Variable-length binary data with a maximum length of 2^31 - 1 (2,147,483,647) bytes.

Q18 - Whats the capacity of varbinary data type in MS SQL?

A18 - Variable-length binary data with a maximum length of 8,000 bytes.

Q19 - What’s the difference between a primary key and a unique key?

A19 - Both Primary key and Unique key enforce the uniqueness of a column on which they are defined. However, a Primary key does not allow nulls, whereas unique key allow nulls.

Q20 - What are the different types of joins in SQL?

INNER JOIN
OUTER JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN
FULL OUTER JOIN
INNER JOIN

Q21 - What is a Self join?

A21 - A join created by joining two or more instances of a same table.
Query:  Select A.firstname , B.firstname
from t_employee A, t_employee B
where A.supervisor_id = B.employee_id;

Q22 - What is a transaction and ACID?

A22 - Transaction - A transaction is a logical unit of work. All steps must be committed or rolled back.
ACID - Atomicity, Consistency, Isolation and Durability, these are the unique entities of a transaction.

Source:internet

Wednesday, March 21, 2012

Interview Questions :- .NET Windows Forms

  1. Write a simple Windows Forms MessageBox statement.
  2.   System.Windows.Forms.MessageBox.Show
    ("Hello, Windows Forms");

  3. Can you write a class without specifying namespace? Which namespace does it belong to by default??
    Yes, you can, then the class belongs to global namespace which has no name. For commercial products, naturally, you wouldn’t want global namespace.
  4. You are designing a GUI application with a window and several widgets on it. The user then resizes the app window and sees a lot of grey space, while the widgets stay in place. What’s the problem? One should use anchoring for correct resizing. Otherwise the default property of a widget on a form is top-left, so it stays at the same location when resized.
  5. How can you save the desired properties of Windows Forms application? .config files in .NET are supported through the API to allow storing and retrieving information. They are nothing more than simple XML files, sort of like what .ini files were before for Win32 apps.
  6. So how do you retrieve the customized properties of a .NET application from XML .config file? Initialize an instance of AppSettingsReader class. Call the GetValue method of AppSettingsReader class, passing in the name of the property and the type expected. Assign the result to the appropriate variable.
  7. Can you automate this process? In Visual Studio yes, use Dynamic Properties for automatic .config creation, storage and retrieval.
  8. My progress bar freezes up and dialog window shows blank, when an intensive background process takes over. Yes, you should’ve multi-threaded your GUI, with taskbar and main form being one thread, and the background process being the other.
  9. What’s the safest way to deploy a Windows Forms app? Web deployment: the user always downloads the latest version of the code; the program runs within security sandbox, properly written app will not require additional security privileges.
  10. Why is it not a good idea to insert code into InitializeComponent method when working with Visual Studio? The designer will likely throw it away; most of the code inside InitializeComponent is auto-generated.
  11. What’s the difference between WindowsDefaultLocation and WindowsDefaultBounds? WindowsDefaultLocation tells the form to start up at a location selected by OS, but with internally specified size. WindowsDefaultBounds delegates both size and starting position choices to the OS.
  12. What’s the difference between Move and LocationChanged? Resize and SizeChanged? Both methods do the same, Move and Resize are the names adopted from VB to ease migration to C#.
  13. How would you create a non-rectangular window, let’s say an ellipse? Create a rectangular form, set the TransparencyKey property to the same value as BackColor, which will effectively make the background of the form transparent. Then set the FormBorderStyle to FormBorderStyle.None, which will remove the contour and contents of the form.
  14. How do you create a separator in the Menu Designer? A hyphen ‘-’ would do it. Also, an ampersand ‘&\’ would underline the next letter.
  15. How’s anchoring different from docking? Anchoring treats the component as having the absolute size and adjusts its location relative to the parent form. Docking treats the component location as absolute and disregards the component size. So if a status bar must always be at the bottom no matter what, use docking. If a button should be on the top right, but change its position with the form being resized, use anchoring.

Source:Internet

Monday, March 19, 2012

Very Official Love Letter

To
Juliet
Grade 7.0 S.M

Sub: Offer of love!

Dearest Ms Juliet,

I am very happy to inform you that I have fallen in Love with you since the 14th of October (Saturday).

With reference to the meeting held between us on the 13th of Oct. At 1500 hrs, I would like to present myself as a prospective lover.

Our love affair would be on probation for a period of three months and depending on compatibility, would be made permanent.

Of course, upon completion of probation, there will be continuous on the job training and performance appraisal schemes leading up to promotion from lover to spouse. 

The expenses incurred for coffee and entertainment would initially be shared equally between us. Later, based on your performance, I might take up a larger share of the expenses.


However I am broadminded enough to be taken care of, on your expense account.

I request you to kindly respond within 30 days of receiving this letter, failing which, this offer would be cancelled without further notice and I shall be considering someone else.

I would be happy, if you could forward this letter to your sister, if you do not wish to take up this offer.

Wish you all the best!

Thanking you in anticipation,

Yours sincerely,
Romeo (HR Manager)

 

Source:Mail

Wednesday, March 14, 2012

Difference B/W North Indian and South Indian GIRL as WIFE

*** WHAT IT MEANS TO HAVE A North Indian GIRL as WIFE ***
1. At the time of marriage, a north Indian girl has more boyfriends  than her age.
2. Before marriage, she looks almost like a bollywood heroine and after marriage you have to go around her twice to completely hug her.
3. By the time she professes her undevoted love to you, you are bankrupt because of the number of times you had to take her out to movies, theatres and restaurants. And you wait longingly for her dowry.
4. The only dishes she can think of to cook is paneer butter masala, aloo sabji, aloo gobi sabji, aloo matar, aloo paneer, that after eating all those paneer and aloos you are either in the bed with chronic cholestrol or chronic gas disorder.
5. The only growth that you see later in your career is the rise in your monthly phone bill.
6. You are blinded by her love that you think that she is a blonde. Only later do you come to know that it is because of the mehandhi that she applies to cover her grey hair.
7. When you come home from office she is very busy watching "Kyonki saas bhi kabi bahu thi" that you either end up eating outside or cooking yourself.
8. You are a very "ESpecial" person to her.
9. She always thought that Madras is a state and covers the whole of south india until she met you.
10. When she says she is going to "work out" she means she is going to " walk out"
11. She has greater number of relatives than the number of people you have in your home town.
12. The only two sentences in English that she knows are "Thank you" and "How are you"


*** WHAT IT MEANS TO HAVE A South Indian GIRL as WIFE ***
1.Her mother looks down at you because you didn't study in IIT or  Madras / Anna University .
2. Her father starts or ends every conversation with " ... I say..."
3. She shudders if you use four letter words.
4. She has long hair, neatly oiled and braided (The Dubai based Oil Well Company will negotiate with her on a 25 year contract to extract coconut oil from her hair.)
5. She uses the word 'Super' as her only superlative.
6. Her name is another name for a Goddess or a flower.
7. Her first name is longer than your first name, middle name  and  surname combined (unless you are from Andhra)
8. When she mixes milk/curd and rice you are never sure whether it is for the dog or for herself.
9. For weddings, she sports a mini jasmine garden on her head and wears silk saris in the Madras heat without looking too uncomfortable while you are melting in your singlet.
10. Her favourite cricketer is Krishnamachari Srikkanth.
11. Her favourite food is dosa though she has tried North Indian snacks like Chats (pronounced like the slang for 'conversation' )
12. She bores you by telling you which raaga each song you hear is based on.
13. You have to give her jewellery, though she has already got plenty of it ..
14. Her Mangal Sutra weighs more than the championship belts worn by WWF wrestlers.
15. Her father thinks she is much smarter than you..... :D ;D

Source: Facebook

Monday, March 12, 2012

10 fast facts about Rahul Dravid (The Wall)


1) Rahul Dravid became the first batsman to score a century in every Test playing nation.


2) His record of 93 consecutive Tests for India is the fifth highest overall and the second highest for an Indian behind Sunil Gavaskar.


3) Dravid has featured in 100-run partnerships over 80 times with 18 different teammates, a record highest.


4) With 461 runs, he finished as the top-scorer in the 1999 Cricket World Cup.


5) “Jammy” became the first Indian to score back-to-back centuries in a World Cup.


6) He also became the sixth batsman and the third Indian to cross the 10,000 – run mark in ODIs

.
7) Dravid is also the sixth batsman and the third Indian to score 11, 000 Test runs.


8) He holds the record for the most number of catches by any Test player.


9) Dravid was one of the Five Wisden Cricketers of the Year in 2000, along with being the ICC Test Player and Player of the Year in 2004.


10) He became the first player to reach the 10000-run mark at the No.3 position.

Source:Facebook

Friday, March 09, 2012

C# - Interview Questions

 

  1. What’s the implicit name of the parameter that gets passed into the class’ set method? Value, and its datatype depends on whatever variable we’re changing.
  2. How do you inherit from a class in C#? Place a colon and then the name of the base class. Notice that it’s double colon in C++.
  3. Does C# support multiple inheritance? No, use interfaces instead.
  4. When you inherit a protected class-level variable, who is it available to? Classes in the same namespace.
  5. Are private class-level variables inherited? Yes, but they are not accessible, so looking at it you can honestly say that they are not inherited. But they are.
  6. Describe the accessibility modifier protected internal. It’s available to derived classes and classes within the same Assembly (and naturally from the base class it’s declared in).
  7. C# provides a default constructor for me. I write a constructor that takes a string as a parameter, but want to keep the no parameter one. How many constructors should I write? Two. Once you write at least one constructor, C# cancels the freebie constructor, and now you have to write one yourself, even if there’s no implementation in it.
  8. What’s the top .NET class that everything is derived from? System.Object.
  9. How’s method overriding different from overloading? When overriding, you change the method behavior for a derived class. Overloading simply involves having a method with the same name within the class.
  10. What does the keyword virtual mean in the method definition? The method can be over-ridden.
  11. Can you declare the override method static while the original method is non-static? No, you can’t, the signature of the virtual method must remain the same, only the keyword virtual is changed to keyword override.
  12. Can you override private virtual methods? No, moreover, you cannot access private methods in inherited classes, have to be protected in the base class to allow any sort of access.
  13. Can you prevent your class from being inherited and becoming a base class for some other classes? Yes, that’s what keyword sealed in the class definition is for. The developer trying to derive from your class will get a message: cannot inherit from Sealed class WhateverBaseClassName. It’s the same concept as final class in Java.
  14. Can you allow class to be inherited, but prevent the method from being over-ridden? Yes, just leave the class public and make the method sealed.
  15. What’s an abstract class? A class that cannot be instantiated. A concept in C++ known as pure virtual method. A class that must be inherited and have the methods over-ridden. Essentially, it’s a blueprint for a class without any implementation.
  16. When do you absolutely have to declare a class as abstract (as opposed to free-willed educated choice or decision based on UML diagram)? When at least one of the methods in the class is abstract. When the class itself is inherited from an abstract class, but not all base abstract methods have been over-ridden.
  17. What’s an interface class? It’s an abstract class with public abstract methods all of which must be implemented in the inherited classes.
  18. Why can’t you specify the accessibility modifier for methods inside the interface? They all must be public. Therefore, to prevent you from getting the false impression that you have any freedom of choice, you are not allowed to specify any accessibility, it’s public by default.
  19. Can you inherit multiple interfaces? Yes, why not.
  20. And if they have conflicting method names? It’s up to you to implement the method inside your own class, so implementation is left entirely up to you. This might cause a problem on a higher-level scale if similarly named methods from different interfaces expect different data, but as far as compiler cares you’re okay.
  21. What’s the difference between an interface and abstract class? In the interface all methods must be abstract; in the abstract class some methods can be concrete. In the interface no accessibility modifiers are allowed, which is ok in abstract classes.
  22. How can you overload a method? Different parameter data types, different number of parameters, different order of parameters.
  23. If a base class has a bunch of overloaded constructors, and an inherited class has another bunch of overloaded constructors, can you enforce a call from an inherited constructor to an arbitrary base constructor? Yes, just place a colon, and then keyword base (parameter list to invoke the appropriate constructor) in the overloaded constructor definition inside the inherited class.
  24. What’s the difference between System.String and System.StringBuilder classes? System.String is immutable; System.StringBuilder was designed with the purpose of having a mutable string where a variety of operations can be performed.
  25. What’s the advantage of using System.Text.StringBuilder over System.String? StringBuilder is more efficient in the cases, where a lot of manipulation is done to the text. Strings are immutable, so each time it’s being operated on, a new instance is created.
  26. Can you store multiple data types in System.Array? No.
  27. What’s the difference between the System.Array.CopyTo() and System.Array.Clone()? The first one performs a deep copy of the array, the second one is shallow.
  28. How can you sort the elements of the array in descending order? By calling Sort() and then Reverse() methods.
  29. What’s the .NET datatype that allows the retrieval of data by a unique key? HashTable.
  30. What’s class SortedList underneath? A sorted HashTable.
  31. Will finally block get executed if the exception had not occurred? Yes.
  32. What’s the C# equivalent of C++ catch (…), which was a catch-all statement for any possible exception? A catch block that catches the exception of type System.Exception. You can also omit the parameter data type in this case and just write catch {}.
  33. Can multiple catch blocks be executed? No, once the proper catch code fires off, the control is transferred to the finally block (if there are any), and then whatever follows the finally block.
  34. Why is it a bad idea to throw your own exceptions? Well, if at that point you know that an error has occurred, then why not write the proper code to handle that error instead of passing a new Exception object to the catch block? Throwing your own exceptions signifies some design flaws in the project.
  35. What’s a delegate? A delegate object encapsulates a reference to a method. In C++ they were referred to as function pointers.
  36. What’s a multicast delegate? It’s a delegate that points to and eventually fires off several methods.
  37. How’s the DLL Hell problem solved in .NET? Assembly versioning allows the application to specify not only the library it needs to run (which was available under Win32), but also the version of the assembly.
  38. What are the ways to deploy an assembly? An MSI installer, a CAB archive, and XCOPY command.
  39. What’s a satellite assembly? When you write a multilingual or multi-cultural application in .NET, and want to distribute the core application separately from the localized modules, the localized assemblies that modify the core application are called satellite assemblies.
  40. What namespaces are necessary to create a localized application? System.Globalization, System.Resources.
  41. What’s the difference between // comments, /* */ comments and /// comments? Single-line, multi-line and XML documentation comments.
  42. How do you generate documentation from the C# file commented properly with a command-line compiler? Compile it with a /doc switch.
  43. What’s the difference between <c> and <code> XML documentation tag? Single line code example and multiple-line code example.
  44. Is XML case-sensitive? Yes, so <Student> and <student> are different elements.
  45. What debugging tools come with the .NET SDK? CorDBG – command-line debugger, and DbgCLR – graphic debugger. Visual Studio .NET uses the DbgCLR. To use CorDbg, you must compile the original C# file using the /debug switch.
  46. What does the This window show in the debugger? It points to the object that’s pointed to by this reference. Object’s instance data is shown.
  47. What does assert() do? In debug compilation, assert takes in a Boolean condition as a parameter, and shows the error dialog if the condition is false. The program proceeds without any interruption if the condition is true.
  48. What’s the difference between the Debug class and Trace class? Documentation looks the same. Use Debug class for debug builds, use Trace class for both debug and release builds.
  49. Why are there five tracing levels in System.Diagnostics.TraceSwitcher? The tracing dumps can be quite verbose and for some applications that are constantly running you run the risk of overloading the machine and the hard drive there. Five levels range from None to Verbose, allowing to fine-tune the tracing activities.
  50. Where is the output of TextWriterTraceListener redirected? To the Console or a text file depending on the parameter passed to the constructor.
  51. How do you debug an ASP.NET Web application? Attach the aspnet_wp.exe process to the DbgClr debugger.
  52. What are three test cases you should go through in unit testing? Positive test cases (correct data, correct output), negative test cases (broken or missing data, proper handling), exception test cases (exceptions are thrown and caught properly).
  53. Can you change the value of a variable while debugging a C# application? Yes, if you are debugging via Visual Studio.NET, just go to Immediate window.
  54. Explain the three services model (three-tier application). Presentation (UI), business (logic and underlying code) and data (from storage or other sources).
  55. What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET? SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix, but it’s a .NET layer on top of OLE layer, so not the fastest thing in the world. ODBC.NET is a deprecated layer provided for backward compatibility to ODBC engines.
  56. What’s the role of the DataReader class in ADO.NET connections? It returns a read-only dataset from the data source when the command is executed.
  57. What is the wildcard character in SQL? Let’s say you want to query database with LIKE for all employees whose name starts with La. The wildcard character is %, the proper query with LIKE would involve ‘La%’.
  58. Explain ACID rule of thumb for transactions. Transaction must be Atomic (it is one unit of work and does not dependent on previous and following transactions), Consistent (data is either committed or roll back, no “in-between” case where something has been updated and something hasn’t), Isolated (no transaction sees the intermediate results of the current transaction), Durable (the values persist if the data had been committed even if the system crashes right after).
  59. What connections does Microsoft SQL Server support? Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server username and passwords).
  60. Which one is trusted and which one is untrusted? Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction.
  61. Why would you use untrusted verificaion? Web Services might use it, as well as non-Windows applications.
  62. What does the parameter Initial Catalog define inside Connection String? The database name to connect to.
  63. What’s the data provider name to connect to Access database? Microsoft.Access.
  64. What does Dispose method do with the connection object? Deletes it from the memory.
  65. What is a pre-requisite for connection pooling? Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings.

Source:Internet

Wednesday, March 07, 2012

A true story of poor boy loved a rich girl

A poor boy loved a rich girl.
One day the boy proposed her. Then the girl said, "listen! your monthly salary is my daily hand expenses. Should I be involved with you? How could you thought that? I will never love you. So, forget me 'n get engaged with someone else of your level."


But somehow the boy could not forget her so easily.
10 years later.
One day they became face to face in a shopping center. The lady said, "Hey! you! How are you? Now I'm married. Do you know how much is my husband's salary? Rs. 2 lac per month! Can you imagine? 'n he is also very smart."


The guy's eyes got wet with tear by hearing those words.
After few minutes her husband came before the lady could say something to the guy, her husband started to say by seeing the guy.


"Sir! You here? Meet my wife." Then he said to her wife, "I'm going to assist a project of sir, which is of Rs. 200 crore. 'n do u know a fact? Sir loved a girl but he didn't get her. That's why still he is unmarried. How much lucky the girl was. Isn't it? Now a days who can love like that way?"


Moral: Life is not so short. So, don't be so proud of yourself and damn others. Situations change with time. Every one should respect other's love. ! !!!

source:Facebook

Monday, March 05, 2012

Love Marriage Vs Arranged Marriage in Computer sense

The Best Comparison I ever read …

Love Marriage

Arranged Marriage

Resembles procedural programming language. We have some set of functions like flirting, going to movies together, making long conversations on phone and then try to fit all functions to the candidate we like.

Similar to object oriented programming approach. We first fix the candidate and then try to implement functions on her. The functions are added to supplement the main program. The functions can be added or deleted.

Family system hangs because hardware (calledParents ) is not responding.

Compatible with hardware (Parents).

You are the project leader so u are responsible for implementation and execution of PROJECT- married life.

You are a team member under project leader (parents) so they are responsible for successful execution of project Married life.

Client expectations include exciting feature as spouse cooking food, washing clothes etc.

All these features are covered in the SRS (System Req. Specification) as required features.

Love Marriage is like Windows , beautiful n seductive... . Yet one never knows when it willcrash.... if crashes that's the end

Arranged Marriage is like Unix.... Boring n colorless... but still extremely reliable n robust. May crash but easy to recover

 

Source:Mail

Thursday, March 01, 2012

Best Interview - Office Humor

One of the best interviews!! !

Interviewer: Tell me about yourself.

Candidate: I am SAMEER GUPTA. I did my Tele Communication engineering from BabanRao Dhole-Patil Institute of Technology.

Interviewer: BabanRao Dhole-Patil Institute of Technology? I had never heard of this college before!

Candidate: Great! Even I had not heard of it before getting an admission into it . What happened is - due to cricket world cup I scored badly! in 12th.I was getting a paid seat in a good college. But my father said (I prefer to call him 'baap') - "I can not invest so much of money".(The baap actually said
- "I will never waste so much of money on you"). So I had to join this college. Frankly speaking this name - BabanRao Dhole-Patil, can at the most be related to a Shetakari Mahavidyalaya.

Interviewer: ok, ok. It seems you have taken 6 years to complete your engineering.

Candidate: Actually I tried my best to finish it in 4 years. But you know, these cricket matches and football world cup, and tennis tournaments. It is difficult to concentrate. So I flunked in 2nd and
3rd year. So in all I took 4 + 2 = 7 years.

Interviewer: But 4+2 is 6.

Candidate: Oh, is it? You know I always had KT in maths. But I will try to keep this in mind. 4+2 is 6, good, thanks. These cricket matches really affect exams a lot. I think they should ban it.

Interviewer: Good to know that you want cricket matches to be banned.

Candidate: No, no... I am talking about Exams!!

Interviewer: Ok, What is your biggest achievement in life?

Candidate: Obviously, completing my Engineering. My mom never thought I would complete it. In fact, when i flunked in 3rd year, she was looking for a job for me in BEST (Bus corporation in Maharashtra) through some relative.

Interviewer: Do you have any plans of higher study?

Candidate: he he he.. Are you kidding? Completing 'lower' education itelf was so much of pain!!

Interviewer: Let's talk about technical stuff. On which platforms have you worked?

Candidate: Well, I work at SEEPZ, so you can say Andheri is my current platform. Earlier I was at Vashi center. So Vashi was my platform then. As you can see I have experience of different platforms! (Vashi and Andheri are the places in Mumbai)

Interviewer: And which languages have you used?

Candidate: Marathi, Hindi, English. By the way, I can keep quiet in German, French, Russian and many other languages.

Interviewer: Why VC is better than VB?

Candidate: It is a common sense - C comes after B. So VC is a higher version than VB. I heard very soon they are coming up with a new language VD!

Interviewer: Do you know anything about Assembly Language?

Candidate: Well, I have not heard of it. But I guess, this is the language our ministers and MPs use in assembly.

Interviewer: What is your general project experience?

Candidate: My general experience about projects is - most of the times they are in pipeline!

Interviewer: Can you tell me about your current job?

Candidate: Sure, Currently I am working for Bata InfoTech ltd. Since joining BIL, I am on Bench. Before joining BIL, I used to think that Bench was another software like Windows.

Interviewer: Do you have any project management experience?

Candidate: No, but I guess it shouldn't be difficult. I know Word and Excel. I can talk a lot. I know how to dial for International phone call and use speaker facility. And very important - I know few words like - 'Showstoppers ' , 'hotfixes', 'SEI-CMM','quality','versioncontrol','deadlines' , 'Customer
Satisfaction' etc. Also I can blame others for my mistakes!

Interviewer: What are your expectations from our company?

Candidate: Not much.

1. I should at least get 40,000 in hand.

2. I would like to work on a live EJB project. But it should not have deadlines. I personally feel that pressure affects natural talent.

3. I believe in flexi-timings.

4. Dress code is against basic freedom, so I would like to wear t-shirt and jeans.

5. We must have sat-sun off. I will suggest Wednesday off also, so as to avoid breakdown due to overwork.

6. I would like to go abroad 3 times a year on short term preferably 2-4 months) assignments. Personally I prefer US, Australia and Europe. But considering the fact that there is a world cup in West Indies in 2007, I don't mind going there in that period. As you can see I am modest and
don't have many expectations. So can I assume my selection?

Interviewer: he he he ha ha ha. Thanks for your interest in our organization. In fact I was never entertained so much before. Welcome to INFOSYS .. :-))

No intention to offend anybody..
Related Posts Plugin for WordPress, Blogger...