Oracle Interview questions

Total available count: 35
Subject - Databases
Subsubject - Oracle

What is difference between UNIQUE and PRIMARY KEY constraints?

A database table can have only one PRIMARY KEY whereas there can be many UNIQUE keys. The columns that compose PRIMARY KEY are automatically defined NOT NULL, whereas a column that composes a UNIQUE is not automatically defined to be mandatory must also specify the column is NOT NULL. 

Next 5 interview question(s)

What are different Oracle database objects?
What is the difference between rename and alias?
How do we create privileges in Oracle?
What are temporal data types in Oracle?
What is USING Clause and give example?