Which of the following is correct ?

PYQ RPSC Programmer 2013

1. A.

   An SQL query automatically eliminates duplicates.

2. B.

   An SQL query will not work if there are no indexes on the relations.

3. C.

   SQL queries can be nested.

4. D.

   SQL permits attribute names to be repeated in the same relation.