Alibaba Cloud ACA Developer Certification ACA-Developer Question # 56 Topic 3 Discussion

Alibaba Cloud ACA Developer Certification ACA-Developer Question # 56 Topic 3 Discussion

ACA-Developer Exam Topic 3 Question 56 Discussion:
Question #: 56
Topic #: 3

When you use SQL statements to access tables in a database without an index configured, a full table scan will be performed. If a table contains a large amount of data, this kind of scan will access a large amount of data and consume a lot of the database's resources. Which of the following options are best practices when creating database indexes? (Number of correct answers: 3)


A.

Add an index to a field that is frequently queried but does not frequently perform add, delete, or modify operations.


B.

Applies indices to fields that contain many records.


C.

table should not contain more than 6 indexed fields.


D.

Apply indexing to fields of fixed length (preferably not long fields).


E.

Adhere to the rightmost prefix principle when using composite indexes.


Get Premium ACA-Developer Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.