Select from following answers:- A table can only contain 1 primary key
- If CLUSTERED or NONCLUSTERED is not specified for a PRIMARY KEY constraint, CLUSTERED is used if there are no clustered indexes specified for UNIQUE constraints
- All columns defined within a PRIMARY KEY constraint must be defined as NULL
- None
- All Above
Example:
create table testPK ( col1 int NULL, col2 int
, constraint PKTest PRIMARY KEY (col1) )
Check the following error:
Msg 8111, Level 16, State 1, Line 1
Cannot define PRIMARY KEY constraint on nullable column in table 'testPK'.
Here col1 is having primary key constraint.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator