Online Access Free Data-Management-Foundations Practice Test

Which optional clause is used to reject inserts and updates that do not satisfy the WHERE clause of a view query?

• A.BASE TABLE
• B.WITH CHECK OPTION
• C.MATERIALIZED VIEW
• D.JOIN VIEWS

Which command is used to filter group results generated by the GROUP BY clause?

• A.WHERE
• B.REPLACE
• C.WITH
• D.HAVING

What is the last step in the logical design process for designing a database?

• A.Discover entities
• B.Apply a normal form
• C.Determine cardinality
• D.Analyze data requirements

Which term refers to a path from a top-level block to a bottom-level block?

• A.Branch
• B.Fan-out
• C.Sparse index
• D.Crow's foot

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.Outer Join
• D.Cross Join