Interview Questions

At the time of updating the data warehouse, a lookup table is used. When placed on the fact table or warehouse based upon the primary key of the target, the update is takes place only by allowing new records or updated records depending upon the condition of lookup.

The materialized views are aggregate tables. It contains summarized data. For example, to generate sales reports on weekly or monthly or yearly basis instead of daily basis of an application, the date values are aggregated into week values, week values are aggregated into month values and month values into year values. To perform this process aggregate function is used.

To open a page in a new window, you have to use client script using onclick="window.open()" attribute of HTML control.

Aynchronous and Event Driven - All APIs of Node.js library area unit aynchronous that's non-blocking. It basically means that a Node.js based mostly server not waits for a API to return information. Server moves to next API when calling it and a notification mechanism of Events of Node.js helps server to induce response from the previous API decision.

Very Fast - Node.js library is very fast in execution of code.

Single Threaded but highly Scalable - Node.js uses a single threaded model with event looping. Node.js uses a single threaded program and same program can services much larger number of requests than traditional server like open source.

No Buffering - Node.js applications never buffer any data. These applications simply output the data in faster.

When a company or corporation earns a profit or surplus, that money can be put to two uses it can either be re-invested in the business called retained earnings or it can be paid to the shareholders as a dividends.

- 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.

Apply the RM process to situations where serious injury might occur is not a RM (Risk Management) principle.

Risk Management :: A decision-making process for managing day-to-day schedules when there are conflicts.

Capital expenditures are capitalized because of the timing of their estimated benefits – the lemonade stand will benefit the firm for many years. The employees’ work, on the other hand, benefits the period in which the wages are generated only and should be expensed then. This is what differentiates an asset from an expense.