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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What is the difference between formal parameters and actual parameters?

1006

How to view the dropped tables in your recycle bin?

1 1397

How to define an anonymous procedure without variables?

1025

How many data types are supported?

1028

How to connect to the server with user account: sys?

971

How to define default values for formal parameters?

985

What are the restrictions on external table columns?

995

What privilege is needed for a user to insert rows to tables in another schema?

957

How to loop through data rows in the implicit cursor?

1016

How to create additional tablespaces for an new database?

970

How many categories of data types?

940

Can you assign multiple query result rows to a variable?

933

How to use fetch statement in a loop?

974

What is the use of the drop option in the alter table command?

549

How do you use automatic pga memory management with oracle 9i and above?

528

Un-Answered Questions { Oracle }

How to define a cusotmer as a supplier in ORACLE R12

2170

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2022

What is partitioned table in Oracle?

1108

If you see statistics that deal with "undo" what are they really talking about?

604

What is autocashrule set? : oracle accounts receivable

1297

What is a nvl function? How can it be used?

960

hiding item in report how like that properly,thats manually but at runtime i want to do

3152

Which data loaded are in target db?

525

Can we create trigger on materialized view in oracle?

941

Why oracle is used?

998

How to get execution statistics reports on query statements?

1009

What are the different responsibilities of a dba?

640

What is the disk migration? what is the steps involved in oracle disk migration?

1177

How can I introduce multiple conditions in like operator?

926

How do you generate file output from sql?

565

For More Un-Answered { Oracle } Questions Click Here