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

How many anonymous blocks can be defined?

1184

How to load data through external tables?

1135

How to create a table index?

1151

How to assign data of the deleted row to variables?

1075

How to work with data objects interactively?

982

How to add a new column to an existing table with a default value?

1016

How to get a list of all tables in the database?

1 4278

How to set up autotrace for a user account?

1059

How to run the anonymous block again?

1132

How to see the table columns used in an index?

1024

How to drop an index?

959

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

988

How to define an external table with a text file?

1069

How to get a list of all user accounts in the database?

1087

How to define a sub function?

1129

Un-Answered Questions { Oracle }

What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?

577

What is the data pump import utility?

1035

Is there any link between pr form(purchse requisition)and po form(purchase order)

2725

What are the differences between lov and list item?

1065

How to rename a column in an existing table?

1035

What are operators in oracle?

1055

What is using clause and give example?

1044

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2623

Explain the process of recievables in oracle financials. : oracle accounts receivable

1155

What are the execution control statements in oracle?

1095

What suggestions do you have to reduce the network traffic?

961

What are the data management skills?

552

Can we modify approve purchase order?if yes what is navigation?

2010

How to rename a tablespace in oracle?

1086

Explain oracle instance.

1176

For More Un-Answered { Oracle } Questions Click Here