Data integrity constraints are used to
Control who is allowed access to the data
Ensure that duplicate records are not entered into the table
Improve the quality of data entered for a specific property (i.e., table column)
Prevent users from changing the values stored in the table
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
Which of the following is used to delete the entries in the referenced table when the tuple is deleted in the course table?
Solution |
2
Discuss
|
To include integrity constraint in an existing relation use :
Solution |
3
Discuss
|
Which of the following is the right syntax for the assertion?
Solution |
4
Discuss
|
Drop Table cannot be used to drop a table referenced by a _________ constraint.
Solution |
5
Discuss
|
Which of the following is the right syntax for assertion?
Solution |
6
Discuss
|
What will be the result of the query?
Solution |
7
Discuss
|
Which of the following can be addressed by enforcing a referential integrity constraint?
Solution |
8
Discuss
|
____________ is preferred method for enforcing data integrity.
Solution |
9
Discuss
|
In order to ensure that the value of the budget is non-negative which of the following should be used?
Solution |
10
Discuss
|
Domain constraints, functional dependency and referential integrity are special forms of _______
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved