Interview Questions

A Records Management System is a computer program or set of programs used to manage and store records.

For example, a hospital record for storing new room, ward , patients, etc...

Depreciation is a process of cost allocation, not valuation. In accounting, the term depreciation refers to the allocation of cost of a tangible asset to expense to the periods in which the asset is expected to be used to obtain the economic benefit.

In brief, Depreciation is fall in the value of assets due to wear and tear over a period of time, it is a loss.

Aggregate functions perform a calculation on a set of values and return a single value. Aggregate functions ignore NULL values except COUNT function. HAVING clause is used, along with GROUP BY, for filtering query using aggregate values.

Following functions are aggregate functions. 

AVG, MIN CHECKSUM_AGG, SUM, COUNT, STDEV, COUNT_BIG, STDEVP, GROUPING, VAR, MAX. VARP

Example:

“I have no problems with change. I am sure in my ability to regulate my actions of behaviors as needed, and take up myself adaptable to all situations – not just change.”

The QA testing process that was followed in my last company where I worked was like this: First of all the Business Requirement Document was prepared as per the client’s requirement (with the muck-up screen shots). Then on the basis of the requirement document, Test Strategy, Test Plans and Test Cases were written in sequential order. Once the Build is made and deployed to the different testing environments where different types of testing were performed to check whether there are any defects.

The standard query operators in LINQ are the extension methods that form the LINQ pattern. These operators form an API that enables querying of any .NET array or collection. It operates on sequences and allows you to perform operations, such as determining if a value exists in the sequence and performing an aggregated function, such as a summation over a sequence.

Dropped tables can be recovered using DROP TABLE flashback. It works the way recycle bin works.
Example:
FLASHBACK TABLE EMPLOYEE TO BEFORE DROP;
The most recently dropped table with that original name is retrieved from the recycle bin, with its original name.

Here by this question the employer need to know do you have any computer skills for managing an admin's job.

Example Answer :

I'm proficient with Microsoft Office suite including Word, Excel, and Power Point. I'm very comfortable using these programs and have a lot of experience doing so in my previous job roles.