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 import one table back from a dump file?

984

How to start your 10g xe server from command line?

1018

How to invoke the data pump export utility?

1131

How to define an anonymous block?

1092

How to list all tables in your schema?

1002

How to use "in out" parameter properly?

1009

How to use windows user to connect to the server?

949

How to execute a stored program unit?

1020

How to load data from external tables to regular tables?

1009

What happens to the current transaction if a ddl statement is executed?

965

How to drop a tablespace?

1005

How to retrieve the count of updated rows?

1071

What happens to the indexes if a table is recovered?

953

How to get execution path reports on query statements?

944

How to add another datafile to a tablespace?

1004

Un-Answered Questions { Oracle }

if you ctreate table identity

2326

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2426

What is end user in database?

556

What is the difference between 10g OEM and 11g OEM?

931

When you used JKM ?

559

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2200

How to create additional tablespaces for an new database?

985

How do I limit the number of oracle database connections generated by weblogic server?

1019

What is the purpose of scan?

How long does it take to learn database administration?

520

What is oracle update statement with inner join ?

1007

Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?

What is a trace file and how is it created in oracle?

996

What is an oracle transaction?

1072

How can we find out the duplicate values in an oracle table?

1009

For More Un-Answered { Oracle } Questions Click Here