"primary key=unique+null" is equal,reson?not,reason?
Answers were Sorted based on User's Feedback
Answer / prashant
Primary Key = unique + Not null
Because primary key is used to uniquely identify each row
of the table.
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / karunakar reddy s
primary key = unique and not null in a table
because primary key act as foreign key in other table, and
we can identify the records using this key. If pk has null
value how can we identify the records in the first table
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / devaraja.m
Primary key should be Unique + not null. hence
Primary key = unique+ Not null.
primary having the best role in al table, without PK we
cont identify the table itself. because it should be only
one & should not be zero.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sajeda
primary key = unique+ null
Because the primary key identyfi uniqe value that does not
contain nll values.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / s.rama devi
if we create pk for any column in table. That column dont
allow the duplicate values and also not null values
Is This Answer Correct ? | 0 Yes | 1 No |
which clause we are not used in where clause?
Explain the use of consistent option in exp command.
Is there an oracle sql query that aggregates multiple rows into one row?
T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
What is the difference between an Oracle Schema and an Oracle Instance?
What is control file used for?
How to define a sub function?
How do you find current date and time in oracle?
How to delete all rows a table in oracle?
What is ceil and floor in oracle?
How to create a new table by selecting rows from another table?