sitemap

By
Loading, please wait for a moment...

Popular posts from this blog

.Net Database Interview Questions&Answers Part 2

By
Image
What is the purpose of using COLLATE in a query? Answer1. Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width. Answer2. COLLATE is a clause that can be applied to a database definition or a column definition to define the collation, or to a character string expression to apply a collation cast. What is one of the first things you would do to increase performance of a query? For example, a boss tells you that “a query that ran yesterday took 30 seconds, but today it takes 6 minutes”? Answer1. Use Storedprocedure for any optimized result, because it is an compiled code. Answer2. One of the best ways to increase query performance is to use indexes. What is an execution plan? When would you use it? How would you view the execution plan? The Query Analyzer has a fe...
Read more

Important HR Interview Questions Part 2

By
Image
How do you feel about reporting to a younger person (minority, woman, etc)? You greatly admire a company that hires and promotes on merit alone and you couldn’t agree more with that philosophy. The age (gender, race, etc.) of the person you report to would certainly make no difference to you. Whoever has that position has obviously earned it and knows their job well. Both the person and the position are fully deserving of respect. You believe that all people in a company, from the receptionist to the Chairman, work best when their abilities, efforts and feelings are respected and rewarded fairly, and that includes you. That’s the best type of work environment you can hope to find. On confidential matters… Your interviewer may press you for this information for two reasons. First, many companies use interviews to research the competition. It’s a perfect set-up. Here in their own lair, is an insider from the enemy camp who can reveal prized information on the competition’s plans, re...
Read more

JAVA Interview Questions&Answers Part 1

By
Image
Can a private method of a superclass be declared within a subclass? Sure. A private field or method or inner class belongs to its declared class and hides from its subclasses. There is no way for private stuff to have a runtime overloading or overriding (polymorphism) features. Why Java does not support multiple inheritence ? Java DOES support multiple inheritance via interface implementation. What is the difference between final, finally and finalize? o final - declare constant o finally - handles exception o finalize - helps in garbage collection Where and how can you use a private constructor. Private constructor can be used if you do not want any other class to instanstiate the object , the instantiation is done from a static public method, this method is used when dealing with the factory method pattern when the designer wants only one controller (fatory method ) to create the object. In System.out.println(),what is System,out and println,pls explain? System is a predefined f...
Read more