Database Administrator (DBA) Question:
Download Job Interview Questions and Answers 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 Question | Next 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? |