Online Access Free Data-Management-Foundations Exam Questions

Which capability should databases maintain to simplify the use of SQL with a general-purpose language?

• A.The ability to reverse results if needed
• B.The query processor to deliver results
• C.The storage manager to interpret low-level file-system commands
• D.The use of an application programming interface

Which property of an entity can become a column in a table?

• A.Modality
• B.Attribute
• C.Uniqueness
• D.Non-null values

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

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

Which keyword can be used as a clause in an ALTER TABLE statement?

• A.CHANGE
• B.STOP
• C.DELETE
• D.AGGREGATE

Which keyword can be used to combine two results into one table?

• A.UNION
• B.MERGE
• C.CONSOLIDATE
• D.INTEGRATE