1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC

Icon,

4 8395

as a technical developer in oracle applications which type errors feced in your experience sofar

HCL,

1896

can we use lexical perameter in oracle plsql if yes how

 1820

as a technical developer in oracle applications which type errors feced in your experience sofar

HCL,

1764

How you find out version of installed workflow?

 1 4141

how many triggers we can create on a table

G2 Technology, TCS,

11 48576

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

 1540

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

iFlex,

1732

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

Allfon,

2 4837

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

iFlex,

1550

What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?

HDFC,

1 4891

a query to select maxmun 3 salaries of employee table

IBM, Polaris,

12 16688

Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table

 5 9073

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

Infosys,

1981

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

EDC,

1622

Un-Answered Questions { Oracle }

What happens if the constraint name is left out of a constraint clause?

272

What is an oracle database table?

581

What is odi studio?

286

Describe an oracle table?

565

How to load data through external tables?

575




For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1550

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2458

How to export your own schema?

558

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1605

How to delete an existing row from a table in oracle?

636

What is oracle datasource?

540

How to specify default values in insert statement using oracle?

548

How many types of database software are there?

285

How to connect asp pages to oracle servers?

565

How can we create the complete backup of data in the oracle.

1678

For More Un-Answered { Oracle } Questions Click Here