Oracle Interview Questions
Questions Answers Views Company eMail

Explain the use of show option in imp command.

633

What suggestions do you have to reduce the network traffic?

538

Explain the use of grant option in imp command.

569

Explain the dml?

590

Explain alias?

703

Explain the use of constraints option in exp command.

555

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


Un-Answered Questions { Oracle }

what is dynamic SGA and static SGA

3830


How to download oracle database 10g xe?

589


What are the built-in functions used for sending Parameters to forms ?

2839


When you used JKM ?

310


What do you mean by oracle database?

259






Difference between ETL and E_LT?

305


What is table partitioning and why is it required?

1


How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2387


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2352


What is the difference between sharding and partitioning?

495


What are the key components of oracle’s maximum availability architecture?

1


State all possible different index configurations a table can possibly have?

560


What is the usage of save points in oracle database?

531


How do I call oracle stored procedures that take no parameters?

558


What is rac?

1