Database Administrator (DBA) Question:

What is difference between UNIQUE constraint and PRIMARY KEY constraint?

Tweet Share WhatsApp

Answer:

A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can’t contain Nulls. 47.What is Index Cluster? - A Cluster with an index on the Cluster Key 48.When does a Transaction end? - When it is committed or Rollbacked.

Download Database Administrator (DBA) PDF Read All 253 Database Administrator (DBA) Questions
Previous QuestionNext Question
What does a Control file Contain?What is the effect of setting the value “ALL_ROWS” for OPTIMIZER_GOAL parameter of the ALTER SESSION command?