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 4759

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 4581

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 4878

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.

3275

what is null value?

9 10259

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 8240

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

6 14255

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 7041

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

2 8636

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

2 4450

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

2332

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

4114

How to restrict the duplicate records in table valuesets

IBM,

2 7187

What is the disadvantage of User defind function?

CybAge,

2239

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

2 6997

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to change system global area (sga) in oracle?

960

How to shutdown your 10g xe server?

1084

How to write text literals in oracle?

1021

What is coalesce function?

1009

How to retrieve data from an explicit cursor?

1009

what is the dual table in oracle?

934

How do you store pictures in a database?

952

How can we delete duplicate rows in a table?

929

how do u setup a replication site?

1926

Explain oracle 12c new features for developers?

995

What is format trigger?

2016

How to assign data of the deleted row to variables?

1015

How many file formats are supported to export data?

1139

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3155

How to grant create session privilege to a user in oracle?

948

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