Archive | June, 2012

.NET SQL INTERVIEW QUESTIONS

11 Jun

Here are some very commonly asked questions in a .NET/SQL Interview..

Q: What is CLR?
Answer: The Common Language Runtime (CLR) is the virtual machine component of Microsoft’s .NET framework and is responsible for managing the execution of .NET programs. In a process known as just-in-time (JIT)compilation, the CLR compiles the intermediate language code into the machine instructions that in turn are executed by the computer’s CPU.

Q: What are lambda expressions?

Answer: Let us start by an example:

delegate int del(int i);

static void Main(string[] args)

{

del myDelegate = x => x * x;

int j = myDelegate(5); //j = 25

}

The left side of the lambda operator (=>) specifies the input parameters (if any) and the right side holds the expression or statement block. The lambda expression x => x * x is read “x goes to x times x.”

Q:What is the difference between hashtable and Dictionary?

Answer: Dictionary is a generic type, Hashtable is not. So, you get type safety with Dictionary, because you can’t insert any random object into it, and you don’t have to cast the values you   take out. Hashtable is thread safe for use by multiple reader threads and a single writing thread, while in Dictionary public static members are thread safe, but any instance members are not guaranteed to be thread safe.

Q: Describe cycles in a ASP.NET Page life

Answer:  To answer this question Please read the following link:

http://msdn.microsoft.com/en-us/library/ms178472.aspx

Q: Is String a Value Type of Reference Type?

Answer: String is a reference type.

Q: IN SSIS Packages What are variables and what is variable scope?

Answer:  A variable is used to store values. There are basically two types of variables, System Variable (like ErrorCode, ErrorDescription, PackageName etc) whose values you can use but cannot change and User Variable which you create, assign values and read as needed. A variable can hold a value of the data type you have chosen when you defined the variable. Variables can have a different scope depending on where it was defined. For example you can have package level variables which are accessible to all the tasks in the package and there could also be container level variables which are accessible only to those tasks that are within the container.

Q: What is the use of Sequence Containers in SSIS Packages?

Answer: Using Sequence Containers lets you handle the control flow in more detail, without having to manage individual tasks and containers. For example, you can set the Disable property of the Sequence container to True to disable all the tasks and containers in the Sequence container.

If a package has many tasks then it is easier to group the tasks in Sequence Containers and you can collapse and expand Sequence Containers.

Q: What does NullIF expression in SQL do?

Answer: NULLIF returns the first expression if the two expressions are not equal. If the expressions are equal, NULLIF returns a null value of the type of the first expression.

NULLIF ( expression1 , expression2 )

 

Thanks for reading my post. If you would like me to post more questions please comment in the section below.

Advertisements
7 Jun

L&L Photography

Photo of the Day – June 7, 2012

Life is the flower for which love is the honey.
~ Victor Hugo

The One,” Hillsboro, Oregon

View original post

Walking Through Central Park

6 Jun

It’s beautiful 🙂 Walking is my ultimate motivation ..

ZAJAC iMAGES

View original post

Healthy-living reminder (and note to self): walk. Walk. WALK!

6 Jun

Teresa Young

Yep, in concert with the yin and yang of all things, the minute I write about something like I’ve got it handled, the endless balancing act that is modern life tips a bit too far in some direction and suddenly I don’t! So then what does one do? Simple: begin again. And by the way, your form matters!

In addition to the “proper walking techniques” in the accompanying image (thanks to the Mayo Foundation), don’t coast along in your habitual walking style, with your mind driving your body around like a car, mentally just getting through the physical exercise ’til it’s over while thinking of everything you need to do after. Get your consciousness down into your body: engage your thighs and butt muscles and make sure they’re working as the engine that’s propelling you forward. Keep your knees flexed and stay light on your feet. Feel your…

View original post 99 more words

Walking is my ultimate motivation

5 Jun

“All truly great thoughts are conceived while walking.” ― Friedrich Nietzsche

I walk…because I feel this is the best way I could appreciate Mother Nature and her Natural beauty…"Sunflower" I walk….because I want my mind and body to connect and talk to each other in a very special language called “silence.”

"Beautiful flowers"

I walk because…It is safe, simple and doesn’t require practice…it is as natural as breathing. "Mother Nature" I walk…because it takes my mind off everyday stress and uplifts my spirits."Texas bluebonnets" “Walking in the morning takes you to beautiful places where light and shade make love.” ― Prof. Mohamed Shareef "Texas wildflowers"

I walk because there is so much beauty all around me to see and appreciate every bit of it. 

"Rose"

I walk…because flowers are Nature’s masterpiece and I want to capture them through my lens in every way, shape and form. That to me is real joy and cherishing life’s simple pleasures.

"Texas flowers"

We travel the world hunting for special destinations…sometimes it is right there in our own backyard. I walk…because I feel lucky to be able to see and appreciate things that are often unseen!

"Texas sunflower"

YES…walking is my ultimate motivation… 🙂

How to reduce Stress

1 Jun

Stress Management:

With life becoming so fast, competitive people often do not find time for themselves. This results in stress accumulation which can lead to various health issues. For many people, stress is so commonplace that it has become a way of life. Some stress is normal and even useful. Stress can help if you need to work hard or react quickly but when you’re constantly running in emergency mode, your mind and body pay the price. Constant stress can have bad effects. It can be linked to headaches, an upset stomachback pain, hair loss, acid reflux and trouble sleeping.

Causes of stress:

There are two types of Stress – Short term and Long term. We all experience short-term stress in our daily lives however long-term stress can lead to many health problems 😦 The situations and pressures that cause stress are known as stressors. We usually think of stressors as being negative, however, anything that puts high demands on you or forces you to adjust can be stressful.

The most common causes of stress are:

  • Bereavement
  • Family problems
  • Financial matters
  • Illness
  • Moving home
  • Relationships
  • Pollution
  • Over Crowding
  • Too much Traffic
  • Obesity
  • Long work hours

Avoiding Stress:

  • Time Management: Learn better ways to manage your time. You may get more done with less stress if you make a schedule. Think about which things are most important, and do those first. May be…automatic payment of bills will reduce your stress. Do not hesitate in spending some money to lower down stress in your life. After all, nothing is more important than happiness and health in life 🙂 
  • Healthy Diet: Take good care of yourself. Get plenty of rest. Eat well. Don’t smoke. Limit how much alcohol you drink.
  • Exercise: For many people exercise is an extremely effective stress buster. You do not have to spend hours in exercise, even 15 minutes of exercise can reduce or even eliminate stress
  • Breathing – there are some effective breathing techniques which will slow down your system and help you relax.
  • Yoga: Yoga is another great way of reducing stress in life. Early morning is the best time for yoga.
  • Common Sense: My mantra of leading a stress free life is very simple – “live and let live.” We don’t need to criticize, judge, or condemn others. So, use your common sense and take it easy 🙂

Do not let stress come rule your life. It is time for action. If you like my blog please comment in the section below.

Life is too short – Good Luck and keep 🙂


Two most colorful festivals

1 Jun HOLI

Are you ready to celebrate two most colorful festivals in the world:

  1. La Tomatina in Buñol, Spain celebrated during the last Wednesday in August.The world’s largest food fight. Each year some 30,000 people (including locals and many visitors) fill this town’s main square to hurl locally grown tomatoes at each other.  La Tomatina is a week-long festival featuring music, parades, dancing, fireworks, and a paella-cooking contest the night before the big fight.

Rules of the Fight:

A cannon is fired to signal the beginning and end of the tomato-throwing. According to the official La Tomatina website, there are just five rules:

  • You must not bring bottles or other objects that could cause an accident or injury.
  • You must not tear or throw t-shirts.
  • To avoid hurting people, you must squish tomatoes before they are thrown.
  • You must be careful around any trucks or vans.
  • After hearing the second shot, you must stop throwing tomatoes

La Tomatina

La Tomatina

La Tomatina

 2.   Holi:

Holi is a religious spring festival celebrated by Hindus. Holi is also called ‘The Festival of Colours’, and people celebrate the festival by smearing each other with paint, and throwing coloured powder and dye around in an atmosphere of great good humor.

Rules of the Fight:

No Rules, just have fun..

HOLI

HOLI

HOLI

So, if you get a chance do not miss out on these festivals. If you like my post please post comments in the section below.

%d bloggers like this: