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

Oracle General Interview Questions

Questions Answers Views Company eMail

what are actual and formal parameters?

1051

Differentiate between translate and replace?

1040

Explain the use of rows option in imp command.

1042

Explain the use of rows option in exp command.

1024

Explain the use of tables option in exp command.

1054

Differentiate between post-database commit and post-form commit?

982

Explain the use of full option in exp command.

1057

Difference between pre-select and pre-query

1031

Explain an exception?

923

What are the varoius components of physical database structure of oracle database?

946

Explain the use of online redo log files in oracle.

993

Explain the use of grant option in exp command.

1006

What is a sub query? What are its various types?

1082

Explain enable novalidate constraint.

1035

What is a synonym? What are its various types?

1044

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How is it different from a normal table?

968

What happens to the current transaction if the session is ended?

1037

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

978

What is proxy method?

931

How to assign a tablespace to a users in oracle?

992

Can you create a synonym without having a table?

980

How data locks are respected in oracle?

1013

How to resolve the ORA-39133 error in Oracle?

1033

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

How to create a stored program unit?

1121

Can objects of the same schema reside in different tablespace?

1002

What are the differences between primary key and unique key?

949

What is a sub query and what are the different types of subqueries?

1075

How to import one table back from a dump file?

972

What are the differences between blob and clob in oracle?

1032

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