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?

1187

How to define an anonymous block?

1157

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?

989

How to execute a stored program unit?

1075

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?

1043

How to retrieve the count of updated rows?

1127

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 }

what is port in oracle? how is it related to database application.

1949

What is Undo Management Advisor in Oracle?

1098

Explain oracle data types with examples?

1028

List out the types of joins.

1158

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1899

How can you find all the processes on your system?

570

Discuss row chaining, how does it happen? How can you reduce it?

542

How to create Drill down report?

2127

Can i create more than one Master Repository in ODI?

597

How do I become an administrator?

582

Explain how one can iterate through items and records in a specified block?

1128

How to export data with a field delimiter?

1039

How to commit the current transaction in oracle?

1120

What is translate in oracle?

1098

What is oracle and what are its different editions?

1065

For More Un-Answered { Oracle } Questions Click Here