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 4903

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 4694

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 4989

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.

3331

what is null value?

9 10606

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 8483

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

6 14500

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 7141

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

2 8758

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

2 4562

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

2397

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

4174

How to restrict the duplicate records in table valuesets

IBM,

2 7295

What is the disadvantage of User defind function?

CybAge,

2293

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

2 7135

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is oracle join syntax?

1003

How to drop a stored function?

1137

How can we delete duplicate rows in a table?

973

How to get maxsal , minsal, ename department wise in single query

1549

How to use group functions in the select clause using oracle?

1072

What is materialized view in Oracle?

1074

How can I get column names from a table in oracle?

1048

Explain table?

1116

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2270

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1847

What is the difference between postgresql and oracle?

1048

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2354

How to check your oracle database 10g xe installation?

987

What is a data lock in oracle?

1119

Can objects of the same schema reside in different tablespace?

1062

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