Full-stack dev quiz question #49
It is obvious that nobody has to remember all the details that are easy to find in the documentation. But on the other hand, it is good to know the basic stuff to not waste time checking it every time. Check forty ninth question of full-stack dev quiz to verify how much you remember about data modifications using Liquibase.
Which sentence best describes the difference between
valueComputed attributes in
update change used in Liquibase? For example:
<changeSet id="Update A" author="DBA presents">
<column name="col1" value="abc" />
<changeSet id="Update B" author="DBA presents">
<column name="col1" valueComputed="abc" />
Choose the best sentence.
valueComputedis optimized for performance before the changeset is actually applied,
valueis parsed when it is applied
valueworks for all data types but
valueComputedonly for numerics
valueComputedis dedicated to computed columns in the database,
valueis for persisted columns
- Both do exactly the same,
valueComputedis there for backward compatibility
valueis for constant values,
valueComputedcan be used with expressions
For the correct answer scroll down
Would you like to learn Liquibase? Enroll to my course on Udemy.
Promo code: DBMANAGE22
The correct answer is: e. If you would like to read more, check Update data based on another column with Liquibase article.