Sql server 2000 Maximum Capacity Specifications

hi! i guess we sometimes during interviews interviewer ask questions regarding how many tables a sql server database can have???No. of indexes a table can have????? just to make sure whether u have your basics right?????? Im only listening the specifications which are more important rest u can find here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp

1. Bytes per row - 8,060
2. Clustered indexes per table - 1
3. Columns in GROUP BY, ORDER BY -Limited only by number of bytes per GROUP BY, ORDER BY
4. Columns per index - 16
5. Columns per foreign key - 16
6. Columns per primary key - 16
7. Columns per base table - 1024
8. Columns per SELECT statement - 4096
9. Columns per INSERT statement - 1024
10. Database size - 1,048,516 TB
11. Databases per instance of SQL Server - 32,767
12. File size (data) (.mdf file) - 32 TB
13. File size (log) (.ldf file) - 4 TB
14. Foreign key table references per table - 253
15. Nested stored procedure levels - 32
16. Nested subqueries - 32
17. Nested trigger levels - 32
18. Nonclustered indexes per table - 249
19. Rows per table - Limited by available storage
20. Tables per database - Limited by number of objects in a database
21. Tables per SELECT statement - 256
22. Triggers per table - Limited by number of objects in a database
23. UNIQUE indexes or constraints per table - 249 nonclustered and 1 clustered
24. Always remember that Database objects include all tables, views, stored procedures, extended stored procedures, triggers, rules, defaults, and constraints. The sum of the number of all these objects in a database cannot exceed 2,147,483,647
25. Parameters per stored procedure - 2100

Face your interview confidentely....