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

Which function is used to find the largest integer less than or equal to aspecific value?

564

Explain procedure to change characterset of a database.

633

What is oracle archived redo log?

593

what does the no logging option do? Why would we use it?

551

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

564

List five most important parameter in 9i affecting performance?

566

What is the difference between rman and a traditional hotbackup?

1 1443

How can you tell if an index on particular table is used or not used in 9i?

564

You see a wait on lms process in statspack, what does that mean?

574

What does the no logging option do? Why would we be careful of using it?

601

Tell me about standby database? What are some of the configurations of it?

568

When using oracle export/import what character set concerns might come up? How do you handle them?

595

Which date function is used to find the difference between two dates?

578

How do you install statspack?

685

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

549

Un-Answered Questions { Oracle }

What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?

Can we store pictures in the database and if so, how it can be done?

1044

How do you analyze the tables

What happens if the update subquery returns multiple rows?

1116

Why cursor variables are easier to use than cursors?

1094

How to connect to a remote server?

1125

Explain constraining triggers.

1095

How would you best determine why your MVIEW couldnt FAST REFRESH?

1889

What is an oracle data file?

1103

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

575

Explain oracle’s server parameter file.

992

which one is currently in used software cmpanies.

2153

What is a nvl function?

1032

How much money does a dba make?

580

What are the most common interview questions on ETL Testing for experience?

1143

For More Un-Answered { Oracle } Questions Click Here