What is a primary key, and how is it different from a unique key?
Answer Posted / hr@tgksolutions.com
• Primary Key:
o Ensures each row in a table is unique.
o Cannot contain NULL values.
o A table can have only one primary key.
• Unique Key:
o Ensures all values in a column are unique.
o Can contain a single NULL value.
o A table can have multiple unique keys.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is composite data type in pl sql?
Is id a reserved word in sql?
Does sql*plus have a pl/sql engine?
Do we need to rebuild index after truncate?
What is sqlite used for?
How to combine two stored procedures in sql?
What is embedded sql in db2?
What is pl sql script?
How do I turn a list into a table?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is difference between rank () row_number () and dense_rank () in sql?
what is a database? : Sql dba
Why plvtab is considered as the easiest way to access the pl/sql table?
What is the difference between the conventional and direct path loads? : aql loader
Show how functions and procedures are called in a pl/sql block.