Interview Questions

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

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.

Purpose -
This question typically is asked by the interviewer to understand if you have the skills and experience for the job.

Approach -
The primary focus of your answer should be to match your qualifications, certifications, experience and skills with their job needs. Mention key strengths and give examples that connect with the company and the job requirements.

Pre-work -
You should do detail research on the company and job posting to effectively answer this question.

This is a very common interview question be prepared to answer it.

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.

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) );

Use the SORTWK01, SORTWK02,..... dd names in the step. Number of sort datasets depends on the volume of data being sorted, but a minimum of 3 is required.

-  The process of having a copy of redo log files is called mirroring.
-  It is done by creating group of log files together. This ensures that LGWR automatically writes them to all the members of the current on-line redo log group.
-  In case a group fails, the database automatically switches over to the next group. It diminishes the performance.