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?

1025

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

1073

How to invoke the data pump export utility?

1188

How to define an anonymous block?

1158

How to list all tables in your schema?

1053

How to use "in out" parameter properly?

1048

How to use windows user to connect to the server?

990

How to execute a stored program unit?

1077

How to load data from external tables to regular tables?

1062

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

1013

How to drop a tablespace?

1044

How to retrieve the count of updated rows?

1128

What happens to the indexes if a table is recovered?

993

How to get execution path reports on query statements?

987

How to add another datafile to a tablespace?

1040

Un-Answered Questions { Oracle }

Mention what are the tools provided in oracle enterprise manager?

What are the different types of trigger and explain its various uses and functions?

1095

What are the different types of backups that are available in oracle?

Â How to use an oracle sequence generator in a mapping?

1076

from where do u receive the information to develop report

2012

What is the dynamic sql in oracle?

1073

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3582

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1347

How remove data files before opening a database?

1074

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2051

3. Steps in UAT?

2433

How index is implemented in oracle database?

1006

How many types of knowledge Modules? Where are used in km?

621

HOW TO SPOT AHIERARCHY?

2296

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

605

For More Un-Answered { Oracle } Questions Click Here