InterviewUp – Job Interview Questions and Answers – Which are the different services in SQL Server ?...

November 21, 2008

Home

Sign-In

My Interview Questions

Question & Additional Information

UPs

Which are the different services in SQL Server ? How do you manage them ?

Comments (0) |

Inappropriate

Asked By: deke

Back

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Answer

Edit

Replication Service: SQL Server 2000 replication enables sites to maintain multiple copies of data on different computers, in order to improve overall system performance, while ensuring that all the different copies are kept synchronized. DTS: By using DTS, you can build data warehouses and data marts in SQL Server by importing and transferring data from multiple heterogeneous sources interactively or automatically on a regularly scheduled basis. Analysis Services: Analysis Services provides tools for analyzing the data stored in data warehouses and data marts. Metadata services: SQL Server Meta Data Services provides a way to store and manage metadata about information systems and applications. This technology serves as a hub for data and component definitions, development and deployment models, reusable software components, and data warehousing descriptions. Reporting services: used to generate reports from the data in the database

Tags

Edit

SQL Server, Microsoft

Asked At

Edit

microsoft

Job Titles

Edit

Database Engineer

Comments (0) :

Your Name:

Add your comment text

Tags

interview, human resource, library, time, marketing, management, leadership, problem, manager, human resources

Asked At

None

Job Positions

Secretary, Team Leader, Librarian, Production Operator, Production Assistant

Click here to improve the Interview Question, Answer and other fields.

Comments (1) :

Linda

Thursday, November 20, 2008 6:10 PM

I work on projects. I work with operators on improvments. I assist in areas that are behind.
I clean areas. I assure operators are busy and putting out good product.

See all 1 comments

UPs

why do you want this job?

Add or view comments about this interview question

Comments (1) |

Share this interview question with your friend

Inappropriate

View all interview questions asked by this user

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

There is difference between Job and Career. One starts with job and builds up Career. Money is the remuneration paid for the services provided. Apart from Money a job provides stability and personal satisfaction for the educational background and also gives a place to sit and work and mingle with other professionals and thus helps in professional and personal growth.

Create Date

Wednesday, November 05, 2008

Tags

Asked At

None

Job Positions

ultrasound

Click here to improve the Interview Question, Answer and other fields.

Comments (1) :

bbfromdc

Tuesday, November 18, 2008 8:45 AM

I guess it should be like..This job in addition to good
work culture also gives me great benefits, security in
life and promising future

See all 1 comments

UPs

Describe Referential Integrity ?

Comments (0) |

Inappropriate

Asked By: tom77 |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Referential Integrity defines that the Primary key of one table should be match to the foreign key of other tables .

Create Date

Saturday, May 10, 2008

Tags

ORACLE DATA ACCESS, Sql

Asked At

None

Job Positions

Database Engineer

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

UPs

What would your previous supervisor say your strongest point is?

Comments (1) |

Inappropriate

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

There are numerous good possibilities:
Loyalty, Energy, Positive attitude, Leadership, Team player, Expertise, Initiative, Patience, Hard work, Creativity, Problem solver.

Create Date

Thursday, September 18, 2008

Tags

interview, general, business, network, hr, human resource, SQL, integer, character, management, Flexibility, organization, efficiency, general interview, leadership, manager, human resources, Microsoft, accounting, work attitude, supervision, PUZZLE

Asked At

None

Job Positions

None

Click here to improve the Interview Question, Answer and other fields.

Comments (1) :

bbfromdc

Sunday, October 12, 2008 8:02 AM

I simply love my supervisor Is it okay ?

See all 1 comments

UPs

What is web 2.0?

Comments (0) |

Inappropriate

Asked By: smhsha |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Web 2.0 is a trend in the use of World Wide Web technology and web design that aims to facilitate creativity, information sharing, and, most notably, collaboration among users. These concepts have led to the development and evolution of web-based communities and hosted services, such as social-networking sites, wikis, blogs, and folksonomies (the practice of catgorising content through tags). Although the term suggests a new version of the World Wide Web, it does not refer to an update to any technical specifications, but to changes in the ways software developers and end-users use the internet.

Create Date

Thursday, September 25, 2008

Tags

None

Asked At

None

Job Positions

Partner liason

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

UPs

What is silly window syndrome?

Comments (0) |

Inappropriate

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Silly window syndrome is a problem in computer networking caused by poorly-implemented TCP flow control. If a server with this problem is unable to process all incoming data, it requests that its clients reduce the amount of data they send at a time (the "window" setting on a TCP packet). If the server continues to be unable to process all incoming data, the window becomes smaller and smaller, sometimes to the point that the data transmitted is smaller than the packet header, making data transmission extremely inefficient. The name of this problem is due to the window size shrinking to a "silly" value.

Since there is a certain amount of overheadassociated with processing each packet, the increased number of packets means increased overhead to process a decreasing amount of data. The end result is thrashing.

Create Date

Monday, April 28, 2008

Tags

networking

Asked At

None

Job Positions

Network Administrator

Click here to improve the Interview Question, Answer and other fields.