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?

521

Explain procedure to change characterset of a database.

562

What is oracle archived redo log?

539

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

516

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

514

List five most important parameter in 9i affecting performance?

506

What is the difference between rman and a traditional hotbackup?

1 1367

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

526

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

515

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

551

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

523

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

535

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

521

How do you install statspack?

637

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

510

Un-Answered Questions { Oracle }

How many types of segments in Oracle?

1014

What does sharding mean?

947

What are the types of Knowledge Modules?

534

Have you created sequence? When will you use?

510

What is the data pump export utility?

1023

3. Steps in UAT?

2368

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2075

How does the on-delete-cascade statement work?

1061

What is the maximum number of triggers that can be applied to a single table?

956

What view would you use to determine free space in a tablespace?

2168

What is the history of ODI?

611

What is the difference between post-database commit and post-form commit?

1108

Give two methods you could use to determine what DDL changes have been made.

6688

How can you find dead processes?

500

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1870

For More Un-Answered { Oracle } Questions Click Here