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 to apply filtering criteria at group level in oracle?

1005

How to define and use table alias names in oracle?

896

What is the relation of a user account and a schema in oracle?

1026

How to start a new transaction in oracle?

1038

How to connect asp pages to oracle servers?

1024

How to create a new tablespace in oracle?

948

How oracle handles dead locks?

1036

How to convert characters to dates in oracle?

1045

How to create an oracle database manually?

1038

What is a procedure in oracle?

1102

How to create a stored function in oracle?

1058

How to use regular expression in pattern match conditions in oracle?

985

How to rename a tablespace in oracle?

1049

How to create a new oracle data file?

991

What is oracle database 10g express edition?

1085

Un-Answered Questions { Oracle }

What is the advantage of using rman?

673

How do I find the database name in oracle?

1000

Can a parameter be passed to a cursor?

1071

Give the various exception types.

960

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

972

Explain the difference between a procedure and a function?

1106

How to resolve the ORA-39133 error in Oracle?

1060

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1034

What is data file?

1063

What are the types of data contol?

575

What are the oracle built-in data types?

1026

What is oracle rowcount?

1049

Give one method for transferring a table from one schema to another?

551

What is the difference between count (*), count (expression), count (distinct expression)?

973

How to display row numbers with the records?

1041

For More Un-Answered { Oracle } Questions Click Here