wahts is mean by primary key and unique key?
Answer Posted / swapna
Primery Key:- A column or set of columns that uniquely
identify all the rows in a table. Primary keys do not allow
null values. No two rows can have the same primary key
value; therefore, a primary key value always uniquely
identifies a single row.
Unique Key:- Unique Keys are used to uniquely identify each
row in an Oracle table. There can be one and only one row
for each unique key value. no value repeate in the other
rows of the same table.
| Is This Answer Correct ? | 21 Yes | 7 No |
Post New Answer View All Answers
How can I manage special characters when I execute an insert query?
What are the differences between statement and preparedstatement interface?
Why do you use a data source object for a connection?
What are the advantages of using jdbc datasource?
What should be done for auto generating primary key id in a table ?
Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?
What's the benefit for specifying constraints like not null, primary key explicitly instead of specifying it against the column ?
What is jdbc class forname?
Write an sql to find all records having all upper case alphanumeric characters in a field ?
What is drivermanager in jdbc?
What are the main components of JDBC ?
What happens if connection is not closed in jdbc?
What are the standard isolation levels defined by JDBC?
How can we set null value in jdbc preparedstatement?
Write a program JDBCcode forfetching student database with SQL.