Database Administration Questions

The three major amendments that were passed shortly after the Civil War are the reconstruction amendments that were the 13th, 14th, and 15th amendments.

The 13th Amendment abolished slavery,

The 14th granted African American citizenship and equal protection before the law, (and)

The 15th Amendment attempted to secure the right to vote for newly freed slaves. 

China shares land borders with 14 different countries, the longest being with Mongolia followed by Russia and then India.

Indian state that has the maximum number of Lok Sabha constituencies is Uttar Pradesh with 80 Lok sabha seats.

The Bulk Copy Program (BCP) is a command-line utility that ships with Microsoft SQL Server. It is a tool used to duplicate enormous quantity of information from tables and views. It does not facsimile the structures same as foundation to target.
BULK INSERT command helps to bring in a data folder into a record, table or view in a user-specific arrangement. With BCP, you can import and export large amounts of data in and out of SQL Server databases quickly and easily. Any DBA who has utilized this functionality will agree that BCP is an essential tool.

A seemingly simple question that is often difficult to answer, it can result in a great interview going disastrously wrong.

Here "What interests you about the position offered?" is a problematic question for anyone, even the most prepared interview candidate. It is one of those questions that might decide between selected individuals who have the same qualifications and experience.

When asked "what about this job interests you", the interviewer wants to know why you decided to apply specifically for this job and why do you consider this position fitting you and your career plans.

The best bet is to take the most important element of the said job and talk about it.

For example if the job requires effective team work capabilities, you may construct your answer in this way:

Question: What is the 'thing' that interests you about this job?

Answer: One of the things that are of my best interests in this job is the opportunity to work in a team environment. I always wanted to work with hard-working, professional, experienced people. I love contributing the team effort, bringing out the best in myself and in my teammates for fulfilling our work goals and reaching top results.

I trust that I can perform great by applying sound principles of teamwork as I did in my previous jobs. I seek timely and consistent feedback designed to improve not only my performance as well but the team’s performance as well. I consult with people, try my best and treat everyone positively/equally.

Tips to follow while answering this question ::

1. Be Specific

2. Be Truthful

3. Be Real

Cell references in a formula are called Assumptions rather than constant values.

All cell references are relative references by default. When copied across multiple cells, they change based on the relative position of rows and columns.