If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
Answer Posted / ananta pilaka
Primary key is only one and it is clustered index.
Unique key cannot be referred as foreign key contraint of
another table.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to define a data field as not null?
Is primary key indexed by default in oracle?
What is memory advisor in Oracle?
What is hash cluster in oracle?
What is ordinary table in oracle?
What are the varoius components of physical database structure of oracle database?
What are the roles of dba?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Explain the use of grant option in exp command.
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is blob data type in oracle?
What is the usage of synonyms?
What is set operator oracle?
How to update a table row with a record?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?