This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
You have authored a user-defined function named addTax. You are writing a SQL query to return a flat array of scalar price values with the calculated tax value. Which valid SQL query should you use 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
You are 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 you use for this task?
User-defined function
Pre-trigger
Post-trigger
Your team has written validation logic in JavaScript to make sure items are in your required format before committing them to a container. Which server-side programming construct should you use for this task?
Your team has created a set of aggregate metadata items that are required to be modified anytime you successfully create or update an item within your container. Which server-side programming construct should you use for this task?
You must answer all questions before checking your work.
Continue
Was this page helpful?