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 the right syntax for the assertion?
Solution |
2
Discuss
|
What will be the result of the query?
Solution |
3
Discuss
|
In order to ensure that the value of the budget is non-negative which of the following should be used?
Solution |
4
Discuss
|
Which of the following is not an integrity constraint?
Solution |
5
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 |
6
Discuss
|
To include integrity constraint in an existing relation use :
Solution |
7
Discuss
|
Which of the following can be addressed by enforcing a referential integrity constraint?
Solution |
8
Discuss
|
Domain constraints, functional dependency and referential integrity are special forms of _______
Solution |
9
Discuss
|
____________ is preferred method for enforcing data integrity.
Solution |
10
Discuss
|
Which of the following is the right syntax for assertion?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved