Which three statements correctly describe the functions and use of constraints? (Choose three.)

The correct answer is C. Constraints enforce rules at the view level. D. Constraints enforce rules at the table level. E. Constraints prevent the deletion of a table if there are dependencies. Constraints have functions to enforce rules at the view and table levels and to prevent the deletion of data if dependencies exist between tables. Incorrect Answers A: Constraints are used to put dependencies on data. B: Constrains are not used to make complex queries more…

Creating and Managing Schema Objects

Question

Options

AConstraints provide data independence.
BConstraints make complex queries easy.
CConstraints enforce rules at the view level.
DConstraints enforce rules at the table level.
EConstraints prevent the deletion of a table if there are dependencies.
FConstraints prevent the deletion of an index if there are dependencies.

How the community answered

(46 responses)

A
2% (1)
B
9% (4)
C
85% (39)
F
4% (2)

Explanation

Constraints have functions to enforce rules at the view and table levels and to prevent the deletion of data if dependencies exist between tables. Incorrect Answers A: Constraints are used to put dependencies on data. B: Constrains are not used to make complex queries more easy. F: Constraints does not prevent the deletion of an index if there are dependencies.

Topics

#constraints#data integrity#table constraints#referential integrity

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice