Adobe Commerce AD0-E716 Question # 29 Topic 3 Discussion

The correct answers are A and C.

The errors in the snippet are:

Column roll_no does not have an index. It is needed since attribute_identity is set to true.

Column student_name does not have an attribute length.

The attribute_identity attribute specifies whether the primary key of the table should be auto-incremented. If attribute_identity is set to true, then the roll_no column must have an index. The student_name column does not have an attribute length, which is required for string columns.

The following code shows how to fix the errors:

XML

<title name="vendor_module_table">

int

true

true

false

int

false

true

false

true

true

string

255

false

</title>

Once the errors have been fixed, the table can be created successfully.