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?

 357

Explain procedure to change characterset of a database.

 384

What is oracle archived redo log?

 348

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

 341

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

 346

List five most important parameter in 9i affecting performance?

 345

What is the difference between rman and a traditional hotbackup?

 1 913

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

 335

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

 339

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

 329

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

 336

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

 356

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

 319

How do you install statspack?

 458

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

 338

Un-Answered Questions { Oracle }

What is the best way to do multi-row insert in oracle?

654

How many types of tables supported by oracle?

677

What is the load plans? And how to create for the load plans?

372

what is port in oracle? how is it related to database application.

1521

How to create a new table in your schema?

699




What is the purpose of the grep command?

345

What is a view and how is it different from a table?

643

Can i create more than one Master Repository in ODI?

365

How to check your oracle database 10g xe installation?

667

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

369

What is the function of Redo Log in Oracle?

736

What are the data types in oracle?

660

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

639

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1874

Explain the wait events in statspack report 'db scattered read'?

330

For More Un-Answered { Oracle } Questions Click Here