Sign Up Login


  1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

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

 411

Explain procedure to change characterset of a database.

 436

What is oracle archived redo log?

 401

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

 393

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

 391

List five most important parameter in 9i affecting performance?

 399

What is the difference between rman and a traditional hotbackup?

 1 1059

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

 393

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

 391

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

 382

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

 399

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

 407

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

 383

How do you install statspack?

 504

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

 391

Un-Answered Questions { Oracle }

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2146

How to revoke create session privilege from a user in oracle?

754

if some data is not transfered where it will get stored

1678

What is the volume management techniques used in oracle rac?

1

if the source have total 15 records with 2 records are updated and 3 records are newly inserted at the target side we have to load the newly changed and inserted records

388

Give the advantages and disadvantages of clusters.

781

How many control files should you have?

414

Discuss row chaining, how does it happen? How do you correct it?

385

How to load data through external tables?

856

What is the database name in oracle?

767

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1978

What is an anonymous block?

888

What is ole automation?

1

What is flexfileds and use of flexfileds in odi?

422

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1858

For More Un-Answered { Oracle } Questions Click Here