Which three statements are true about indexes and their administration in an Oracle database? (Choose three.)
Which three statements are true about indexes and their administration in an Oracle database? (Choose three.)
The same table column can be part of both a unique and non-unique index. A descending index is a type of function-based index. An index can indeed be created as part of a CREATE TABLE statement, which allows for better performance during the creation and initial loading of data into the table.
Answer is ABE. F is wrong, unused index is not mentained
These are correct
F is wrong. it is not maintained by DML.
ABE are correct
C and F are wrong, oracle documentation says: Unlike unusable indexes, an invisible index is maintained during DML statements. https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-indexes.html#GUID-3A66938F-73C6-4173-844E-3938A0DBBB54
ABE correct
ABE correct
BEF for me
invisible indexes are maintained, unusable indexes are not. C and F are wrong
F is wrong but C is correct: https://docs.oracle.com/cd/E18283_01/server.112/e17120/indexes004.htm so either ACE or BCE
C is false, it is explained on the link you provided on the section: Understand When to Use Unusable or Invisible Indexes