"primary key=unique+null" is equal,reson?not,reason?

Answers were Sorted based on User's Feedback



"primary key=unique+null" is equal,reson?not,reason?..

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

"primary key=unique+null" is equal,reson?not,reason?..

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

"primary key=unique+null" is equal,reson?not,reason?..

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

"primary key=unique+null" is equal,reson?not,reason?..

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

"primary key=unique+null" is equal,reson?not,reason?..

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

Post New Answer

More Oracle General Interview Questions

Why oracle is used?

0 Answers  


how to find the second highest salary in a given table????

5 Answers  


What is null value in oracle?

0 Answers  


What do you mean by merge in oracle and how can you merge two tables?

0 Answers  


What is an Oracle index?

0 Answers  






What is an Oracle Instance?

0 Answers  


Explain oracle data types with examples?

0 Answers  


What is a synonym? What are its various types?

0 Answers  


What does `(+)` do in a where clause?

1 Answers  


i want department wise maxmum salary and empolyee name

9 Answers  


waht is the difference between primary key and super key?

9 Answers  


If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)