Interview Questions

A journal is also called as a book of prime entry.Transactions occurred are first entered in this book to show which accounts should be debited and which should be credited.

on the basis of entries made in the journal, accounts are prepared, the book which contains the accounts is called a ledger. Transactions entered in the journal are classified according to their nature and posted in their respective accounts in ledger. it is also called as book of final entry.

IDMS uses record locks to prevent another run-unit from updating the same record.

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.

The Debit balance recovery is usually made by raising a credit memo for the regular vendors. However if there are no future transactions from the supplier, we ask the vendor to send the check / make an EFT for the amount due from him.

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.

Copy constructor is a constructor function with the same name as the class and used to make deep copy of objects.

Oracle SQL developer is an Oracle Database IDE.