Interview Questions

Oracle Real Application Clusters (RAC) is a software component we can add to a high-availability solution that enables users on multiple machines to access a single database with increased performance. RAC comprises two or more Oracle database instances running on two or more clustered machines and accessing a shared storage device via cluster technology. To support this architecture, the machines that host the database instances are linked by a high-speed interconnect to form the cluster. Oracle RAC offers features in the following areas:

- Scalability

- Availability

- Load balancing

- Failover

These days channel members are being accepted by companies as their partners. The intermediaries are even being asked to integrate their business with the companies which results in lesser costs, greater efficiency and improved customer service. Corporates like Airtel are adopting PRM (Partner relationship management) software to give that added advantage to their supply chain. They organise rewards and recognition programs for their channel partners and also organise proper channels though which partners can vent any of their grievances relating to payments, violation of codes etc.

DLR is a runtime environment that allows you to integrate dynamic languages with the Common Language Runtime (CLR) by adding a set of services, such as expression trees, call site caching, and dynamic object interoperability to the CLR.

The System.Dynamic and System.Runtime.CompilerServices namespaces are used to hold the classes for DLR. It also provides dynamic features to statically-typed languages, such as C# and Visual Basic to enable their interoperation with dynamic languages.

The primary purpose of life insurance is to provide financial protection to surviving dependents after the death of an insured.

You should have recorded in your cash books all amounts you have actually received and payments you have actually made. However the cash books may be incomplete as your bank may have put extra transactions through your account such as:

► bank fees or interest charges
► direct debits (payments) and direct credits (receipts).

Doing a regular bank reconciliation will allow you to:

► take into account any extra transactions your bank puts through your account and
► check and record any errors or omissions.

By regularly doing a bank reconciliation (say monthly) you can be more confident that your records contain all the information you need to prepare your income tax return and activity statements.

A Thread is a block of code that can be executed in parallel with another block of code.

Generating random passwords in PHP can be done in multiple ways depending on how much security the application demands:-

Md5 function can be passed one parameter as uniqid() function which in turn generates a random number. Passing the parameter as TRUE in uniqid() adds additional uniqueness.

<?php
   $passwd = md5(uniqid(rand(), true));
   Echo $passwd;
?>

- %FOUND

 This is a Boolean variable which evaluates to TRUE if the last row is successfully fetched.

- %NOTFOUND

 This is a Boolean variable which evaluates to TRUE if the last row is not successfully fetched. This means there are no more rows to fetch.

- %ROWCOUNT

 Returns the number of rows fetched by the cursor.

- %ISOPEN

If the cursor is open, it evaluates to TRUE else FALSE.