Sams Teach Yourself SQL in 21 Days, Fourth Edition

Day 15

Quiz

1:	What will happen if a unique index is created on a nonunique field?
A1:	If there are already nonunique values in the column to be indexed, the index will not be created. If there are not nonunique values in the column to be indexed, the index will be created, but will not allow duplicate values in the indexed column.
2:	Are the following statements true or false? Indexes take up space in the database and therefore must be factored in the planning of the database size. If you have the disk space and you really want to get your queries smoking, the more indexes the better. An index is implicitly created when a primary key is specified for a table.
A2:	Indexes take up space in the database and therefore must be factored in the planning ...