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?

568

Explain procedure to change characterset of a database.

643

What is oracle archived redo log?

598

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

558

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

570

List five most important parameter in 9i affecting performance?

572

What is the difference between rman and a traditional hotbackup?

1 1451

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

566

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

576

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

603

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

570

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

601

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

583

How do you install statspack?

694

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

554

Un-Answered Questions { Oracle }

How to convert a string to a date in oracle database?

1058

What are the types of Generic profiles types in ODI?

731

What is a subquery in oracle?

1118

What is Trigger in Oracle?

1183

Why oracle is used?

1065

How to delete a user account in oracle?

983

How to get execution path reports on query statements?

992

What is a sub query? Describe its types?

1025

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

595

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2033

What should a dba know?

533

What is the maximum limit on the number of columns in a table?

1089

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1267

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1668

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2311

For More Un-Answered { Oracle } Questions Click Here