Database Administration Questions

Footsteps. 

Yes, as you walk forward, you will leave the footstep behind you.

One of the most common errors that you might face in join statements is 

Server: Msg 4104, Level 16, State 1, Line 1
The multi-part identifier could not be bound.

A multipart identifier is any description of a field or table that contains multiple parts - for instance MyTable.SomeRow - if it can't be bound that means there's something wrong with it - either you've got a simple typo, or a confusion between table and column. It can also be caused by using reserved words in your table or field names and not surrounding them with [].

The main reason for this error is that the source table cannot be found, for example if you have statement such as Table1.OrderDate, and then if you get error above, this means that Table1 cannot be found in the query. Sometimes you can see that source table exists in the query, but T-SQL cannot understand it, especially when you write join statements.

Golden Revolution refers to Horticulture. Horticulture has been defined as the culture of plants for food, comfort and beauty.

A Windmill.

The project management life cycle describes high-level processes for delivering a successful project.

The project management life cycle is usually broken down into four phases:

1. Initiation and Planning,

2. Execution,

3. Project Monitoring and Control, and

4. Project Closing.

Why they ask this and what they are looking for:

This question "What areas would you like to further develop professionally?" will uncover whether you are interested and knowledgeable about your own development and as such will can be a cloaked attempt to discover your weaknesses.

A common target of the question is to discover how motivated you are to extend yourself. If you are motivated to learn, then you are probably more motivated to do the job well.

How to answer this:

First show that you are concerned and active about your own development. You can indicate how development has worked for your in the past.

You're right, continued learning and development is important and I continue to work to improve key skills.

Do answer the question, of course, but do not show gaping holes in your skill set and especially those in key areas required in the job. A good trick is to talk about developing your skills in new areas that will be of future benefit to the company.

For example : I am in programming now and love the work, but one day I would like to develop into a management role.

Hope this helps you..!

Venus planet is known as the Morning Star or the Evening Star.

Biotin is a water-soluble B vitamin, also called vitamin B7 and formerly known as vitamin H or coenzyme R.