Data Management - Foundations (PBLN) Exam actual questions and CORRECT answers

Data Management - Foundations (PBLN)
Exam actual questions and CORRECT
answers
Which requirement within large, complex databases ensures users have limited access to the
database? - CORRECT ANSWER Authorization



What characterizes the rules of relational databases? - CORRECT ANSWER They are
logical constraints that ensure the data is valid.


Which SQL sublanguage is used to roll back database changes? - CORRECT
ANSWER Data Transaction Language (DTL)



Which MySQL operator is the last in the order of operator precedence? - CORRECT
ANSWER OR



Which operator is used to compare against a list of values when determining a match in a
WHERE clause? - CORRECT ANSWER IN



Which function is considered an aggregating function in SQL? - CORRECT
ANSWER MIN



Which type of join returns only the matching values when selecting rows from two or more
tables? - CORRECT ANSWER Inner Join



What describes elements such as column name and data type? - CORRECT
ANSWER Metadata



Which term identifies an ordered collection of elements enclosed in parenthesis in a
tablespace? - CORRECT ANSWER Tuple