Online Access Free Data-Management-Foundations Exam Questions

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

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

Which type of join is demonstrated by the following query?
sql
SELECT *
FROM Make, Model
WHERE Make.ModelID = Model.ID;

• A.CROSS JOIN
• B.NON-EQUIJOIN
• C.SELF JOIN
• D.EQUIJOIN

Which operation finds an entry containing a search value by repeatedly splitting the index in two?

• A.Table scan
• B.Binary search
• C.Index scan
• D.Fan-out

Which elements are represented by attributes in the database design documents?

• A.Relationships
• B.Names
• C.Synonyms
• D.Repositories

Which function is considered an aggregate function?

• A.MAX
• B.TRIM
• C.DESC
• D.ABS