Interview Questions

Plug and Play is a technology wherein hardware components that are installed on PCs using Microsoft operating system are immediately recognized and made usable. This means that the drivers necessary to make it work are already available on the operating system package.

- Physical Data Integration is all about creating new system that replicates data from the source systems.

- This process is done to manage the data independent of the original system.

- Data Warehouse is the example of Physical Data Integration.

- The benefits of PDI include data version management, combination of data from various sources, like mainframes, flat files, databases.

- A separate system is needed for handling vast data volumes.

SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA). Its purpose is to ease the implementation of tasks for the DBA, with its full- function scheduling engine, which allows you to schedule your own jobs and scripts.

After posting the all accounts in the Ledger a statement is prepared to showing debit and credit balances.Debit balances must be tally with the Credit side balance is called trial balance

It is a way to convert the original text of the stored procedure into encrypted form. The stored procedure gets obfuscated and the output of this is not visible to

CREATE PROCEDURE Abc

WITH ENCRYPTION

AS

<< SELECT statement>>

GO

An unspecified passive open has the server waiting for a connection request from a client. A fully specified passive

open has the server waiting for a connection from a specific client.

Purpose -
This question typically is asked by the interviewer to understand if you have the skills and experience for the job.

Approach -
The primary focus of your answer should be to match your qualifications, certifications, experience and skills with their job needs. Mention key strengths and give examples that connect with the company and the job requirements.

Pre-work -
You should do detail research on the company and job posting to effectively answer this question.

This is a very common interview question be prepared to answer it.

A given quantity of finished goods requires a given quantity of raw materials and components to make them. Materials requirement planning systems to make them. Materials requirements planning systems are computerized tools that manage when materials must be ordered to supply production at a later date. MRP is effective when output quantities are known.Small business owners are often their own MRP systems,storing the information needed to supply prodution in their knowledge and experience. Activities such as computer tracking inventory and forecasting demand are MRP activities.