Interview Questions

- Physical Data Integration is all about creating new system that replicates data from the source systems.

- This process is done to manage the data independent of the original system.

- Data Warehouse is the example of Physical Data Integration.

- The benefits of PDI include data version management, combination of data from various sources, like mainframes, flat files, databases.

- A separate system is needed for handling vast data volumes.

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

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.

- Create a template that designs a layout for your application.

- Create the composing pages.

- Create a definition which means that suppose that you configured Tiles, in web.xml, to startup using the TilesServlet, we need to specify which files will contain the Tiles definitions to load.

- Render the definition.

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.

Oracle check constraint is used to ensure that before inserting the data in the database, it is validated and checked for the condition.
Example:
Below, the constraint is that the id has to be between 0 and 1000.
create table employee ( id number check (id between 0 and 1000), Name varchar(200) );

MainMenu component is a component that allows the display of Menus at runtime on a form.

Process of creating Menu using MainMenu Component:

a. Add MainMenu component on Windows Form.

b. Menu designer allows deciding the structure of the main menu by selecting the Type Here area and adding the Menu Items to be displayed on the menu.

c. Add functionality to Menu Items as required