Oracle Interview questions


Total available count: 35
Subject - Databases
Subsubject - Oracle

What is USING Clause and give example?

The USING clause specifies which columns to test for equality when two tables are joined. It can be used instead of an ON clause in the JOIN operations that have an explicit join clause.

[sql]select * from employee join salary using employee ID[/sql]

Based on Employee ID join the Employee tables and the Salary tables with each other.




Next 5 interview question(s)

1
What is DML?
2
What are Job Queue Processes?
3
Explain sequence generator in oracle?
4
What are materialized views?
5
What is a view?