This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
A user-defined function named addTax was created. A SQL query is needed to return a flat array of scalar price values with the calculated tax value. Which valid SQL query should be used for this task?
SELECT VALUE addTax(p.price) FROM products p
SELECT VALUE udf.addTax(p.price) FROM products p
SELECT VALUE p.price.addTax() FROM products p
The application team is tasked with taking the date values that are stored in a container, and converting them to a company-specific date format in SQL query results. Which server-side programming construct should the team use for this task?
User-defined function
pre-trigger
Post-trigger
The application team wrote validation logic in JavaScript to make sure items are in the required format before committing them to a container. Which server-side programming construct should the team use for this task?
The application team created a set of aggregate metadata items that are required to be modified anytime an item is successfully created or updated within a container. Which server-side programming construct should the team use for this task?
You must answer all questions before checking your work.
Was this page helpful?