96.Name 3 ways to get an accurate count of the number of records in a table?
SELECT * FROM table1
SELECT COUNT(*) FROM table1
SELECT rows FROM sysindexes WHERE id = OBJECT_ID(table1) AND indid < 2
97.What are the different index configurations a table can have?
A table can have one of the following index configurations:
A clustered index
A clustered index and many nonclustered indexes
A nonclustered index
Many nonclustered indexes
98.What are the various kinds of interactions catered by DBMS?
The various kind of interactions catered by DBMS are:
99.Segregate database technology’s development.
The development of database technology is divided into:
Structure or data model
SQL/ relational model
100.Who proposed the relational model?
Edgar F. Codd proposed the relational model in 1970.