Oracle General Interview Questions
Questions Answers Views Company eMail

Explain index?

735

How to create lov dynamically at runtime & attach to text field?

655

Difference between hot backup vs. Cold backup?

602

How can we force the database to use the user specified rollback segment?

554

What is a trace file and how is it created in oracle?

546

What do you mean by redo log file mirroring?

549

Explain the use of compress option in exp command.

544

Explain the use of parfile option in exp command.

513

Explain the use of log option in exp command.

529

Use of an integrity constraint is better to validate data. Explain

541

Explain the importance of .pll extension in oracle?

546

Explain the use of indexes option in exp command.

589

When do you get a .pll extension in oracle?

671

Can we protect our pl/sql source code?

570

What is analyze command used for?

572


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to upsert (update or insert into a table)?

531


What are the execution control statements?

608


What is an oracle recycle bin?

544


what is the scripts in data base?

1598


How to turn on or off recycle bin for the instance?

601






What is a cursor and what are the steps need to be taken?

594


How to get a list of all user accounts in the database?

604


What is difference between truncate and delete?

551


What is program global area (pga) in oracle?

601


How to export your connection information to a file?

590


What are the uses of linked server and explain it in detail?

580


Can we save images in a database and if yes, how?

584


What are triggers in oracle?

553


How to commit the current transaction in oracle?

570


What is the difference between Delete, Truncate and Drop in Oracle?

601