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 4896

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 4691

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 4980

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.

3329

what is null value?

9 10591

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 8472

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

6 14491

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 7134

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

2 8754

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

2 4558

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

2393

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

4166

How to restrict the duplicate records in table valuesets

IBM,

2 7295

What is the disadvantage of User defind function?

CybAge,

2288

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

2 7127

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2267

Explain oracle left join with an example?

1005

What is format trigger?

2067

How to create a new user account in oracle?

1015

How to delete a user account in oracle?

964

What happens to indexes if you drop a table?

1169

What is meant by raw datatype?

1056

Differentiate between pre-select and pre-query?

1104

Explain the use of log option in exp command.

1115

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2258

How can Oracle users be audited?

1106

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

2266

State any two functions of oracle?

1044

What is sharded cluster?

1008

What is BBED in Oracle?

1150

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