Online Access Free Data-Management-Foundations Practice Test

Which relationship or association exists between a supertype and its subtype entities?

• A.Strong entity
• B.Associative entity
• C.Weak entity
• D.IsA relationship

Which database operation locates the needed table blocks?

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

What is the role of a query processor in the database system architecture?

• A.It sends results back to the application that requested the queries.
• B.It writes log records before applying changes to the database.
• C.It uses information from the catalog to perform query optimization.
• D.It translates instructions into file system commands.

Which action does the % operator accomplish in MySQL?

• A.Divides two numeric values and returns the remainder
• B.Raises a numeric value to the power of another
• C.Subtracts a numeric value from another
• D.Compares two numeric values for equality

Which keyword is used to introduce a limiter in a SELECT statement?

• A.WHERE
• B.DROP
• C.FROM
• D.INTO