Interview Questions

Dual boot system allows you to install and maintain two operating systems on a single PC. The purpose for this is to maintain compatibility between older and newer software. For example, there maybe programs that only work under Windows 98, therefore having a dual boot system between Windows 98 and another version like Windows XP is a good choice.

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

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.

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.

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.

- A process is an execution of a program, while a Thread is a single execution sequence within a process.

- A process can contain multiple threads. A Thread is sometimes called a lightweight process.

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