1. Home
  2. Alibaba
  3. ACA-Developer
  4. Alibaba ACA-Developer Practice Questions ...
PDF File

Latest Alibaba ACA-Developer Practice Questions BY Hurst

H Uploaded by Hurst 21-Oct-2026 Verified by Experts Based on Latest Exam Syllabus
Question 1

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.
Latest Alibaba ACA-Developer Practice Questions BY Hurst
Get Premium Files

Other Popular Alibaba Exams

ACP-Cloud1 ACP Cloud Computing Certification Exam ACA-Cloud1 ACA Cloud Computing Associate ACP-Sec1 ACP Cloud Security Certification Exam ACA-BigData1 ACA Big Data Certification Exam ACA-CloudNative ACA Cloud Native Certification Exam ACA-Sec1 ACA Cloud Security Certification Exam ACA-Database ACA Database Exam ACA-Operator ACA System Operator Certification