Oracle Interview Questions
Questions Answers Views Company eMail

Explain can a view based on another view?

1 807

Explain what are the advantages of views?

601

Explain what are clusters?

604

Explain a data segment?

637

Explain what are the uses of rollback segment?

574

What is sequence?

618

Explain what are the characteristics of data files?

618

Explain how are indexes update?

613

Explain table?

638

Explain what are the type of synonyms?

573

Explain what are synonyms used for?

594

Explain a segment?

606

Explain database link?

651

Explain an integrity constrains?

690

Explain the use of control file?

645


Un-Answered Questions { Oracle }

How to loop through data rows in the implicit cursor?

535


What is meant by recursive hints in oracle?

609


What is a dead lock in oracle?

583


What is an oracle user role?

557


what is insert all statement in sql

5481






What do you mean by oracle database?

258


Explain the use of dde package in d2k.

1


How to create a table in a specific tablespace?

532


What are the ansi data types supported in oracle?

512


What is a cognitive schema?

519


Is oracle a programming language?

553


Why do we use bulk collect in oracle?

554


How to see the table columns used in an index?

583


Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1250


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

263