Oracle Interview Questions
Questions Answers Views Company eMail

Explain the use of show option in imp command.

627

What suggestions do you have to reduce the network traffic?

535

Explain the use of grant option in imp command.

564

Explain the dml?

587

Explain alias?

697

Explain the use of constraints option in exp command.

550

Explain index?

731

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

651

Difference between hot backup vs. Cold backup?

602

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

550

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

541

What do you mean by redo log file mirroring?

549

Explain the use of compress option in exp command.

540

Explain the use of parfile option in exp command.

511

Explain the use of log option in exp command.

527


Un-Answered Questions { Oracle }

What is pga_aggregate_target?

291


What do you mean by merge in oracle and how can you merge two tables?

512


What is the parameter mode that can be passed to a procedure?

561


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1826


How to convert characters to dates in oracle?

555






In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1432


What is db_recovery_file_dest in oracle? When do you need to set this value?

642


Why oracle is used?

571


Give one method for transferring a table from one schema to another?

290


What is Segment Advisor in Oracle?

657


what is reindexing?

1161


Explain table?

638


interview questions with answer for cts

2074


What is the use of the drop option in the alter table command?

301


I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

832