Database Administration Questions

Separation of an employee exists when the service of an employee comes to an end because of one reason or other. "Separation of employment" refers broadly to the process of managing the termination of employment. It is a sensitive issue for any organization. 

Types of separation:

1) Volunntary:

a) Resignation
b) Job abandonment
c) Retirement

2) Involuntary:

a) Layoff
b) Dismissal
c) Plant closure
d) Death or Disability.

Foreign keys are the columns of a table that points to the primary key of another table. They act as a cross-reference between tables.

In detail : A Foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table. In simpler words, the foreign key is defined in a second table, but it refers to the primary key or a unique key in the first table.

The first Asian games was held in New Delhi. The Asian Games, were regulated by the Asian Games Federation (AGF) from the first Games in New Delhi, India, until the 1978 Games.

I am History.

Yes, history refers to all the past, but we can create history in the presentand it cannot be polluted in the future.

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

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.

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. 

OTT stands for 'Over-The-Top' is a term in media industry for the delivery of film and TV content via internet. It doen't require any users to subscribe to a traditional cable or satellite pay TV service.

Examples for OTT players include Netflix and Amazon Prime.