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 are the differences between number and binary_float in oracle?

1100

How to write date and time interval literals in oracle?

1034

How to drop a stored procedure in oracle?

1051

How to lock and unlock a user account in oracle?

1106

How to convert characters to numbers in oracle?

1065

What are the differences between blob and clob in oracle?

1089

What privilege is needed for a user to create tables in oracle?

953

How to drop an existing view in oracle?

946

What happens if you set the sga too low in oracle?

1149

How to delete multiple rows from a table in oracle?

1060

How to create a table index in oracle?

1134

What is an oracle function?

1165

How to use subqueries in the from clause in oracle?

1111

What privilege is needed for a user to create indexes in oracle?

1028

How to create a new table in oracle?

1155

Un-Answered Questions { Oracle }

How do I learn what codesets are available in oracle?

1038

What is a named program unit?

1082

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

653

Which profile required to access Models in Designer tool?

707

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

2010

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2061

How to retrieve the count of updated rows?

1127

What are the requirements of simple database?

570

What is end user in database?

597

What is an artificial (derived) primary key?

613

Explain the function of optimizer in oracle?

1143

How to store pictures on to the database?

975

what is tripstop report?

1835

What are privileges and grants?

1067

How do I become an administrator?

582

For More Un-Answered { Oracle } Questions Click Here