Question

Why do we use multi index files in place of a single index file for a large database?

Answer 1

Yes, you can create any number of indexes on a database table. There is no limitation to it, however keep a watch on the memory that table is taking because of multiple indexes. Yes, you can create index on two columns without any issue.