Oracle General Interview Questions
Questions Answers Views Company eMail

What is set operator oracle?

522

What is where clause in oracle?

526

Which is faster join or subquery in oracle?

531

What is a lookup table in oracle?

537


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are transaction isolation levels supported by oracle?

572


What does sharding mean?

537


Calculate difference between 2 date / times in oracle sql?

564


What happens in oracle commit?

561


Hi Can any one tell me what are the API's used in requisition import.

1481






What is concurrency in oracle?

540


Explain the use of show option in imp command.

638


In what script is snap$ created? In what script is the scott/tiger schema created?

2240


What happens to the current transaction if a ddl statement is executed?

572


How index is implemented in oracle database?

590


How to invoke the data pump export utility?

555


Can we commit inside a function in oracle?

554


What is sharded cluster?

516


How to see free space of each tablespace?

588


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1694