Latest L&T Aptitude Question SOLUTION: What is the difference between primary key and unique key? A)Primary Key is used to identify a column (record) in a table, whereas Unique-key is to prevent duplicate values in a ro

• Placement Papers
• /
• L&T
• /
• Programming
• /
• Program

L&T Question Papers: L&T Company Profile

(#M40166854) L&T Programming question Keep an EYE

What is the difference between primary key and unique key?
A)Primary Key is used to identify a column (record) in a table, whereas Unique-key is to prevent duplicate values in a row (with the exception of a null entry) B)By default SQL-engine creates Non-Clustered Index on primary-key if not exists and Clustered Index on Unique-key C)Primary key does not include Null values, whereas Unique-key can
D)Table can have multiple primary key but can have single Unique-key E)You can change or delete primary values, but Unique-key values can not be changed

Asked In L&T Devendra Marghade (4 years ago)

Unsolved Read Solution (2)

Is this Puzzle helpful?   (1)   (0) Submit Your Solution Program