Oracle Interview Questions
Questions Answers Views Company eMail

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

547

Explain the importance of .pll extension in oracle?

555

Explain the use of indexes option in exp command.

593

When do you get a .pll extension in oracle?

679

Can we protect our pl/sql source code?

579

What is analyze command used for?

580

What is merge statement used for?

570

Explain the use of consistent option in exp command.

552

Explain the use of indexes option in imp command.

566

what is the use of system.effective.date variable in oracle?

673

Explain the types of exception?

654

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

574

What are the various types of snapshots ?

562

Explain the use of ignore option in imp command.

576

What is the purpose of save points in oracle database?

545


Un-Answered Questions { Oracle }

How many anonymous blocks can be defined?

586


What is responsibility and how u attach How to create user and how u attach with responsibility.

1623


what are the tools used for oracle 10g in real time.

1934


Briefly explain what is literal? Give an example where it can be used?

544


Explain the purpose of oracle real application clusters (rac)?

1






How data locks are respected in oracle?

574


Explain a data segment?

650


What are the five main functions of a database administrator?

302


What is the difference between postgresql and oracle?

505


How can you tell if a tablespace has excessive fragmentation?

315


What are the five functions of a database?

311


How does the on-delete-cascade statement work?

608


where the dff data will be stored

1803


In topology manager where the data are stored?

339


Explain a synonym?

606