Select from following answers:- PRIMARY KEY :1, FOREIGN KEY :249
- PRIMARY KEY :249, FOREIGN KEY :UNLIMITED (Recommended is 253)
- PRIMARY KEY :1, FOREIGN KEY :UNLIMITED (Recommended is 253)

- PRIMARY KEY :UNLIMITED, FOREIGN KEY :249
- All Above
A table can contain an unlimited number of FOREIGN KEY constraints, the RECOMMENDED maximum is 253. Depending on the hardware configuration hosting SQL Server, specifying additional FOREIGN KEY constraints may be expensive for the query optimizer to process
Show Correct Answer
Asked In: In General |
Alert Moderator