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?

1104

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?

1147

How to delete multiple rows from a table in oracle?

1060

How to create a table index in oracle?

1133

What is an oracle function?

1162

How to use subqueries in the from clause in oracle?

1111

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

1026

How to create a new table in oracle?

1153

Un-Answered Questions { Oracle }

What is the data pump import utility?

1035

What are the conditions kept in mind while connecting the oracle rac with the network?

What happens when the default and temp tablespace clauses are left out from create user statements?

573

How to create lov dynamically at runtime & attach to text field?

1194

What is a subquery?

1121

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1145

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1340

Explain what are the type of synonyms?

1111

What are the roles and responsibilities of oracle dba?

638

How would you go about increasing the buffer cache hit ratio?

2597

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

586

What is format trigger?

2070

How would you change old and new values in an insert, delete and update triggers?

1020

how to handle exceptions in post production

1424

What do you understand by database schema and what does it hold?

1230

For More Un-Answered { Oracle } Questions Click Here