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

Oracle General Interview Questions

Questions Answers Views Company eMail

Find all employees in Dept “Marketing”.

2 5018

How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10

2 4787

1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records

1 5056

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3379

what is null value?

9 10811

1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.

6 8634

what is the difference between rollback & commit? can a foreign key has null value?

6 14692

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

IBM,

2 7242

What is the Extension of Oracle Database? As extension of Access Database is .mdb

2 8855

A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?

2 4659

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2439

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4230

How to restrict the duplicate records in table valuesets

IBM,

2 7365

What is the disadvantage of User defind function?

CybAge,

2340

Please explan Why static query is more faster than dynamic query ?

2 7240

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

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

2144

Explain oracle insert into command?

1155

How to retrieve data from an cursor to a record?

1153

Explain an index?

1182

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2173

How to assign a tablespace to a users in oracle?

1087

What are the set operators union, union all, minus & intersect meant to do?

1026

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4567

Explain the use of online redo log files in oracle.

1077

How to write a query with a right outer join in oracle?

1219

What is the usage of control file in oracle?

1141

What is dynamic proxy?

1049

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

2962

Explain the dml?

1042

What is transport network substrate (tns) in oracle?

1091

For More Un-Answered { Oracle General } Questions Click Here