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

Why do you use stored procedures and state some of its disadvantages?

980

How to convert a date to char in oracle? Give one example.

1013

What is the difference between translate and replace in oracle?

1127

What are the different types of synonyms?

1090

How do you store pictures in a database?

963

What is the use of file param in imp command?

1129

What is a system tablespace?

1015

In the oracle version 9.3.0.5.0, what does each number shows?

1242

What are the different types of modules in oracle forms?

963

What are the limitations of check constraint?

974

How to convert a string to a date in oracle database?

1008

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

972

Can you create a synonym without having a table?

993

What are the components of logical database structure in oracle database?

1041

What is the usage of save points in oracle database?

925

Un-Answered Questions { Oracle }

Can we convert a date to char in oracle and if so, what would be the syntax?

971

What parameters control copy latches?

559

What do you understand by anchoring in reports?

State and explain about oracle instance?

944

how may join possible between (requisition with purchase order)

2178

What is Restricted Mode of Instance Startup in Oracle?

1158

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

972

What is a user exit program in oracle reports?

985

Why more redos are generated when the oracle database is in begin backup mode?

1087

What is oracle update statement with inner join ?

1006

What do you mean by merge in oracle and how can you merge two tables?

917

What is hot backup and logical backup?

1010

What are elements of administration?

544

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1889

What are the benefits of ordbms?

1035

For More Un-Answered { Oracle } Questions Click Here