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?

 291

Explain procedure to change characterset of a database.

 323

What is oracle archived redo log?

 279

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?

 282

List five most important parameter in 9i affecting performance?

 275

What is the difference between rman and a traditional hotbackup?

 1 773

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

 272

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

 286

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

 274

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

 267

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

 299

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

 270

How do you install statspack?

 395

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

 287

Un-Answered Questions { Oracle }

How to get a list of all background sessions in the database?

531

hiding item in report how like that properly,thats manually but at runtime i want to do

2542

What are dba privileges?

256

What is the difference between media recovery & crash recovery?

1

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1563




How to create a stored procedure in oracle?

573

When do you get a .pll extension in oracle? Explain its importance

568

How to view the data files in the current database?

587

Why do we need integrity constraints in a database?

584

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

269

What is the anchoring in reports?

1

What are the uses of Database Trigger ?

1097

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

1851

What privilege is needed for a user to create indexes in oracle?

572

What should a dba know?

261

For More Un-Answered { Oracle } Questions Click Here