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.

632

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?

565

What is the difference between rman and a traditional hotbackup?

1 1442

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 }

How to drop an oracle database?

570

What is sharded cluster?

1015

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

576

How do you install statspack?

685

Explain table?

1115

What are the various oracle database objects?

1144

Why is oracle so popular?

997

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2275

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3051

Is oracle the best database?

963

What does sharding mean?

1000

List the different types of columns in oracle reports.

1003

Can you assign multiple query result rows to a variable?

987

What are types of data model?

551

What are the file systems and volume management techniques used in oracle rac?

For More Un-Answered { Oracle } Questions Click Here