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


Oracle Interview Questions
Questions Answers Views Company eMail

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

 4003

Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)

 6 15451

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

 1737

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

IBM,

1782

how to join query for one source type is oracle another source type is sql server ?

iGate,

2092

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

Cap Gemini,

1737

ABOUT IDENTITY?

HCL,

1653

How to select the name of employee who is getting maximum sal with out using subquery

 15 12967

how can create the lexical parameter after the select class?

Oracle,

1 4548

Explain prerequisites and post activities of oracle database installation

 1709

Why required to run root.sh at the time of installation and what exactly it will do

 1 4446

How to clone the database using RMAN back

 1704

i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

HCL, IBM,

7 11270

1.display list of all users from ur data base.what is the query?

CGI, IBM,

3 6779

What are the mandatory setups in setting up a PO in oracle

Silicon,

1 3371

Un-Answered Questions { Oracle }

List the types of joins used in writing subqueries?

668

I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?

1

What are the oracle differences between nvl and coalesce

629

Have you attended the client meetings?

381

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

1667




what is load plans and types of load plans?

336

How to export data with a field delimiter?

666

How do you find current date and time in oracle?

673

What is the difference between sharding and partitioning?

591

What are the tools provided in oracle enterprise manager?

1

Explain do view contain data?

671

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

365

How will you write a query to get a 5th rank student from a table student_report?

1498

How does one get the view definition of fixed views/tables?

692

Can a Tablespace hold objects from different Schemes in Oracle?

700

For More Un-Answered { Oracle } Questions Click Here