Online Access Free Data-Management-Foundations Practice Test

Which type of join selects all the rows from both the left and right table, regardless of match?

• A.Inner Join
• B.Full Join
• C.Cross Join
• D.Outer Join

Which product has an open-source license in addition to having a non-relational system?

• A.MongoDB
• B.MySQL
• C.Oracle Database
• D.SQL Server

Which primary key values consist of a single field only?

• A.Stable
• B.Partition
• C.Simple
• D.Meaningless

Which function measures a numeric value's distance from 0?

• A.ABS
• B.LOWER
• C.FROM
• D.CONCAT

Which keyword combines INSERTS, UPDATES, and DELETES operations into a single statement?

• A.INTO
• B.MERGE
• C.JOIN
• D.DROP