If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
Answer Posted / murugananthan
NO, UNIQUE +NOT NULL != PRIMARY KEY
it cant refer someother table column
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Give the advantages and disadvantages of clusters.
How to create a temporary table in oracle?
What is a package ? What are the advantages of package ?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to list all user accounts in oracle?
What are the original export and import utilities?
How do I recompile a procedure in oracle?
How to define a variable of a specific record type?
How to import one table back from a dump file?
Give the various rollback segment states.
How to start your 10g xe server from command line?
What are the various oracle database objects?
How do you tell what your machine name is and what is its IP address?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is null value in oracle?