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

Difference between open_form and call_form in oracle.

1108

Explain an exception and its types?

1033

What are the different types of record groups in oracle? Explain each of them

992

Explain the use of record length option in exp command.

1039

What is control file used for?

1130

Explain the use of inctype option in exp command.

993

what are actual and formal parameters?

1063

Differentiate between translate and replace?

1056

Explain the use of rows option in imp command.

1055

Explain the use of rows option in exp command.

1044

Explain the use of tables option in exp command.

1072

Differentiate between post-database commit and post-form commit?

991

Explain the use of full option in exp command.

1072

Difference between pre-select and pre-query

1057

Explain an exception?

949

Un-Answered Questions { Oracle }

What is the difference between primary key and unique key and foreign key in oracle?

937

how can we store any pdf file in oracle

2118

What is a snapshot log?

967

What are the varoius components of physical database structure of oracle database?

965

How to test null values?

1057

Oracle Data Integrator Interview Questions and answers?

620

What is oracle update statement with inner join ?

1009

What is java oracle used for?

983

where do u put the report file

2051

Explain the difference between sap and oracle?

998

What is a oracle database?

1011

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1964

How can I learn oracle dba?

511

How to add another datafile to a tablespace?

1005

How to delete all rows a table in oracle?

1027

For More Un-Answered { Oracle } Questions Click Here