Procedures in Oracle

ORACLE PROCEDURE

A procedure is a schema object that consists of a set of SQL statements and other PL/SQL constructs, grouped together, stored in the database.it can be executed as a unit to solve a specific problem or perform a set of related tasks. Procedures permit the caller to provide parameters that can be input only, output only, or input and output values.

Procedures and functions in oracle are identical except that functions always return a single value to the caller but procedures can return many values

The syntax for a procedure is:
CREATE [OR REPLACE] PROCEDURE procedure_name
[ (parameter [,parameter]) ]
IS
[declaration_section]
BEGIN
executable_section
[EXCEPTION
exception_section]
END [procedure_name];

Eg :

create or replace procedure acc_bal

(

loancd in varchar2,

accno in number,

bal out number

)

is

ln_bal number;

tr_bal number;

begin

select nvl(sum(decode(type,'C',-1*amount,amount)),0) into ln_bal from loan_tran_dtl where loan_no=loancd and account_no=accno;

select nvl(sum(decode(type,'C',-1*amount,amount)),0) into tr_bal from tran_detail where ref_id=loancd and

account_no=accno;

bal:=ln_bal+tr_bal;

end;

BOOT

Boot

The process by which a computer is started up and its operating system kernel is loaded into RAM is called the boot, or bootstrap, process. The basic steps are the:

1. Execute a hardware self-test.
2. Look in a predefined place for the boot sector and load this code.
3. Execute the boot sector program to load other programs.
4. Execute these programs to load still other programs or to configure the operating environment.
5. Repeat the previous step as often as dictated by the programs being loaded and by their initialization code.

BOOTCONF.SYS

It is configurations file that specifies how a diskless workstation can boot the operating system in order to access the network.

Boot ROM

It is a ROM (read-only memory) chip used in diskless workstations to enable these machines to boot and connect to a network.

BIOS -BASIC INPUT/OUTPUT SYSTEM

BIOS (Basic Input/Output System)

The BIOS (Basic Input/Output System) is a collection of services on a ROM. It enables hardware and software, operating systems and applications, and also applications and users to communicate with each other. The BIOS services are loaded automatically into specific addresses. Also these services should always be accessible. BIOS services are updated and expanded to handle newer devices and greater demands. When you replace the ROM chip in your computer with an upgrade chip you will get a new BIOS. Like the standard BIOS, BIOS extensions are also implemented on a ROM chip located on a Mother Board or an expansion board.

Interview Questions

Common Interview Questions and Answers:

How long would you expect to work for us if hired?

You can answer like: I'd like it to be a long time Or As long as we both feel I'm doing a good job.

2. Explain how you would be an asset to this organization.

This question gives you a chance to highlight your best points as they relate to the position being discussed. Give a little advance thought to this relationship.

3. Why should we hire you?

Point out how your assets meet the goals of the organization. Do not mention any other candidates to make a comparison.

4. What is your greatest strength?

Say positive answers. You can say: your ability to prioritize, your problem solving skills, the ability to work under great pressure, leadership skills, professional skills, positive attitude etc.

5. What is more important to you: the money or the work?

You have to say Money is always important, but the work is the most important. There is no better answer to say.

Antivirus Program

Anti-Virus Program

It is used for detecting or removing a computer virus. This program looks for suspicious activity, such as attempts to intercept a BIOS or other low-level call, unnecessary disk access, and attempts to format or delete files. Sometimes the anti-virus program detects a pattern characteristic of a particular virus. Some anti-virus programs are TSR (terminate-and-stay-resident) programs, which monitor computer activity constantly, looking for indications of a virus. In some cases, these types of programs can be extremely annoying and very processor intensive. So users have been known to remove an anti-virus TSR program from memory out of frustration. Other anti-virus programs are intended to be run periodically. When they are run, the

Programs look for the tell-tale signs (known as signatures) of particular viruses and these programs are minimally disruptive. That is their effectiveness is directly proportional to the frequency with which they are used. Antivirus programs must be updated regularly because the coding for computer viruses is constantly changing. Also it is very important to test every new release of anti-virus programs thoroughly. Some antivirus programs uses a large amount of working memory.

ODBC -OPEN DATABASE CONNECTIVITY

Open Database Connectivity (ODBC)

ODBC provides a common Application Programming Interface (API) to underlying database systems. ODBC communicates with the database through a library driver. Depending on the database being used, a networking driver may be required to connect to a remote database.

ODBC structure.

The unique feature of ODBC is that none of its functions are database-vendor specific. That is, you can use the same code to perform queries against a Microsoft Access table or an Informix database with little or no modification. ODBC has developed into a standard adopted into many products, including Visual Basic, Visual C++, FoxPro. Using ODBC will be more portable but slower than using the Oracle7 or Sybase libraries.

Common Interview Questions

Common Interview Questions and Answers:

1. What have you done to improve your knowledge in the last year?

Try to include improvement activities that relate to the job

2. Are you applying for other jobs?

Be honest. But keep the focus on this job and what you can do for this organization. Anything else is a distraction.

3. Why do you want to work for this organization?

The answer is based on the research you had done about the organization.. Try to relate it to your long-term career goals.

4. Do you know anyone who works for us?

Be aware of the policy on relatives working for the organization before the interview. This can affect your answer even though they asked about friends not relatives. Be careful to mention a friend.

5. What kind of salary do you need?

It is a tough question. If you are confident you can tell what you are expected. Other wise you can ask the range of salary they are giving for this post. Or say that it can depend on the details of the job.

6. Are you a team player?

You are, of course, a team player. Be sure to have examples ready. This should shows your positive attitude.