Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Get Unlimited Access

Adobe Discussions

Exam AD0-E716 topic 1 question 28 discussion

Actual exam question from Adobe's AD0-E716

Question #: 28
Topic #: 1

[All AD0-E716 Questions]

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.)

A. Column (roll_no) does not have index. It is needed since attribute identity is set to true.
B. Column (entity_id) does not have index. It is needed since attribute identity is set to false.
C. Column (student_name) does not have attribute length.
D. NULL is not a valid value for column (roll_no).

Show Suggested Answer

Suggested Answer: CD 🗳️

by some_gyy at Jan. 14, 2024, 12:44 p.m.

Comments

Submit Cancel

arierave

3 months, 2 weeks ago

Selected Answer: AC

According to claude.ai epos: A. When a column is marked as an identity column (identity="true"), it means it is an auto-incrementing column. In such cases, an index is automatically created for the column by the database engine. However, in the given snippet, the roll_no column is set as an identity column, but it does not have an explicit index defined. Although it is not a strict requirement to define the index manually, it is considered a best practice to do so for clarity and consistency. C. The student_name column is defined with the type "text", but it does not have the length attribute specified. In declarative schema, when using the "text" type, it is required to provide the length attribute to specify the maximum length of the text field. Without the length attribute, the schema definition is incomplete and will result in an error.

upvoted 1 times

...