Database Administrator (DBA) Question:
Download Questions PDF

What is difference between UNIQUE constraint and PRIMARY KEY constraint?

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) Interview Questions And Answers PDF

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?