Interview Questions

Oracle constraints are used to maintain consistent of data and ensure the data is properly maintained. A constraint is more or less a restriction we try to apply on a table.
Types of constraints:
- Check constraints
- NOT NULL constraint
- PRIMARY KEY constraint
- REFERENCES constraint
- UNIQUE constraint

Repo Rate is the rate at which the commercial banks borrows money from the central bank of a country i.e, RBI in India.

Reverse Repo Rate is the rate at which the central bank of a country, in case of India it is RBI borrows money from the commercial banks in the country.

ADO or Active X Data objects, allows developers to create applications that can interoperate well with other data application services.

The .Net runtime knows about all the references between the objects. It can identify all the circular references that are reachable from the root and hence finalize them to free them all at once if and when needed.

An index is a object which is used to improve performance during retrieval of records.

CREATE [UNIQUE] INDEX index_name 

ON employee[emp_id, emp_name,dept_id]

[COMPUTE STATISTICS]

The UNIQUE keyword is used when combined values of the index should be unique.

The COMPUTE STATISTICS during the creation of index optimizes the plan of execution of the SQL statement and improves performance.

SSIS, SSAS and SSRS are the most important reporting systems that BI professionals work with. On a detailed level, I have worked with data mining, master data management, data profiling and data cleansing and analysis.

The journal entry to record a credit sale is Accounts Receivable. Credit sale is nothing butthe customers pay at the time of buying.

Method contains name, parameters, return type and executable body. But block does not contains name, parameters, return type.It contains only executable body.

Methods are executed by method call statements. Blocks are executed automatically with class loading and with object creation.