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?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?