Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

List the Optional Flexible Architecture (OFA) of Oracle database ?

1 4742

What is meant by redo log buffer ?

3 7121

What is the role of PCTFREE parameter is Storage clause ?

2 6010

What is use of Rollback Segments In Database ?

4 6750

What is a Rollback segment entry ?

TCS,

3 8058

How will you monitor the space allocation ?

3 8511

What is meant by recursive hints ?

1 4573

What is the OPTIMAL parameter ?

TCS,

1 6187

What is Database Buffers ?

4 11636

How free extents are managed in Ver 6.0 and Ver 7.0 ?

IBM,

1 5061

Can a formula column be obtained through a select statement?

TCS,

1 8290

What is the use of place holder column?

1 7247

How can a break order be created on a column in an existing group?

1 4718

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

1 5016

What is the use of break group?

1 4338

Un-Answered Questions { Oracle }

How to load data through external tables?

1135

How can you find all the processes on your system?

570

What are bind variables and why are they important?

543

Explain how one can iterate through items and records in a specified block?

1125

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1915

How to call a sub procedure?

1093

What is meant by joins?

1059

What is the difference between restoring a database and recovering a database?

What is a junior dba?

614

In what situation u create the BPA.

2210

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2030

What is system tablespace?

1095

What are the predefined tablespaces in a database?

1081

what is IDE,DMV in sql server?

2818

For More Un-Answered { Oracle } Questions Click Here