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

how do u run sql loader

1 6684

i don't want to give the path of .Dat file in .Ctl file dynamically i want to give how

1 3065

What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?

CTS,

2 6057

how we can validate the run-time parameters in reports 6i

Satyam,

1 6716

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 5595

What is lexical parameter ?

Zensar,

2 11263

what is a package n what r the packages availbla in report

Convergys,

2043

how can u store a picture file in oracle database? explain the path/command?

GE, Satyam,

1 5499

What are all the system Parameters available in ORACLE Reports

GE,

1 19140

What is the sequence the Report triggers will fires while running a report ?

FCS, GE,

1 13646

Where we can use the placeholder columns?

GE,

1 4797

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

GE,

2248

How can you create Lexical parameter n Bind parameter in Reports ?

GE, SVSS,

1 6109

What is summary column in Oracle Reports ?

GE,

5 17151

What is the use of Validation triggers in Reports?

GE,

2 11976

Un-Answered Questions { Oracle }

What is oracle sid?

899

Is rowid unique in oracle?

958

What is a table index in oracle?

1081

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

1992

What is the recommended interval at which to run statspack snapshots, and why?

2881

What is a sub query? What are its various types?

1098

What is pga_aggregate_target?

531

How do I find my oracle client driver version?

986

Explain what are the advantages of views?

1021

Name the various constraints used in oracle?

982

How do I become an administrator?

539

What is the main function of database?

560

How do I limit the number of rows returned by an oracle query after ordering?

1113

What do we mean by hot backup & cold backup and how are they different?

How view is different from a table?

980

For More Un-Answered { Oracle } Questions Click Here