NEW QUESTION 19
An Adobe Commerce developer is trying to create a custom table using declarative schema, but is unable to do so.
What are two errors in the snippet above? (Choose two.)
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
<table name=”vendor_module_table”>
<entity_id>
<type>int</type>
<identity>true</identity>
<unsigned>true</unsigned>
<nullable>false</nullable>
</entity_id>
<roll_no>
<type>int</type>
<identity>false</identity>
<unsigned>true</unsigned>
<nullable>false</nullable>
<primary_key>true</primary_key>
<index>true</index>
</roll_no>
<student_name>
<type>string</type>
<length>255</length>
<nullable>false</nullable>
</student_name>
</table>
Once the errors have been fixed, the table can be created successfully.
