Q42 Which three statements are true regarding indexes?

Q42 Which three statements are true regarding indexes? (Choose three.)

• (A). A UNIQUE index can be altered to be non-unique
• (B). A SELECT statement can access one or more indices without accessing any tables
• (C). A table belonging to one user can have an index that belongs to a different user
• (D). An update to a table can result in updates to any or all of the table’s indexes
• (E). When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
• (F). An update to a table can result in no updates to any of the table’s indexes