WGU D427 DATA MANAGEMENT APPLICATIONS EXAM PREP SOLVED QUESTIONS ACCURATE ANSWERS PREMIUM REVIEW

WGU D427 DATA MANAGEMENT
APPLICATIONS EXAM PREP SOLVED
QUESTIONS ACCURATE ANSWERS
PREMIUM REVIEW

◉ LIKE
Answer: Used within a WHERE clause to match text against a pattern
using wildcards % and _, default is case insensitive, but if used with
BINARY, it matches on case-sensitive data


◉ Escape Character
Answer: \ used to escape wildcard characters


◉ DISTINCT
Answer: Used in the SELECT statement to return only unique or
distinct values


◉ ORDER BY
Answer: Clause that orders the selected rows, default is ascending
but DESC can be specified


◉ Function

, Answer: Operates on an expression enclosed in parentheses


◉ ABS(n)
Answer: Returns the absolute value of n


◉ LOG(n)
Answer: Returns the natural logarithm of n


◉ POW(x,y)
Answer: Returns x to the power of y


◉ RAND()
Answer: Returns a random number between 0 (inclusive) and 1
(exclusive)


◉ ROUND(n, d)
Answer: Returns n rounded to d decimal places


◉ SQRT(n)
Answer: Returns the square root of n, only for positive numbers


◉ CONCAT(s1, s2, ...)