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.

631

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?

594

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 is ELT? Or What is the difference between ODI and other ETL Tools?

687

How to do a full database export?

1107

How to load excel data sheet to oracle database

1024

Is a rollback possible to any savepoint?

1094

How to update values in a table in oracle?

1026

How to determine what records to extract?

What is the difference between internal & external schema?

757

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1932

Does oracle database need java?

1004

How to create a server parameter file?

1135

What is max rowid in oracle?

1025

How will you differentiate between varchar & varchar2?

1041

What is bulk collect in oracle?

996

Mention what is oracle real application clusters?

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1090

For More Un-Answered { Oracle } Questions Click Here