Oracle Interview Questions
Questions Answers Views Company eMail

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

295

Explain procedure to change characterset of a database.

329

What is oracle archived redo log?

281

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

269

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

286

List five most important parameter in 9i affecting performance?

277

What is the difference between rman and a traditional hotbackup?

1 775

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

273

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

287

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

276

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

269

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

301

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

270

How do you install statspack?

397

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

289


Un-Answered Questions { Oracle }

types of receipts and detail desription about recipts and tables effected by receipts?

1629


Explain the use of parfile option in exp command.

526


Which flexfields you have customized?

1


What degree do database administrators need?

276


How to loop through a cursor variable?

568






What is temporary Interface( Yellow Interface) ?

287


What happens if you use a wrong connect identifier?

503


What is oracle used for?

534


how to reverse engineer views(how to load the data from views)?

280


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1784


How to view the data files in the current database?

592


How do I find the database name in oracle?

599


what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2046


What happens if recursive calls get out of control?

548


What are the provisions and resources provided in the oracle’s cloud server?

1