Which of the following can be addressed by enforcing a referential integrity constraint?
All phone numbers must include the area code
Certain fields are required (such as the email address, or phone number) before the record is accepted
Information on the customer must be known before anything can be sold to that custome
When entering an order quantity, the user must input a number and not some text (i.e., 12 rather than ‘a dozen’)
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 assertion?
Solution |
2
Discuss
|
What will be the result of the query?
Solution |
3
Discuss
|
____________ is preferred method for enforcing data integrity.
Solution |
4
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 |
5
Discuss
|
Which of the following is the right syntax for the assertion?
Solution |
6
Discuss
|
In order to ensure that the value of the budget is non-negative which of the following should be used?
Solution |
7
Discuss
|
To include integrity constraint in an existing relation use :
Solution |
8
Discuss
|
Domain constraints, functional dependency and referential integrity are special forms of _______
Solution |
9
Discuss
|
A foreign key is the one in which the ________ of one relation is referenced in another relation.
Solution |
10
Discuss
|
Which of the following is not an integrity constraint?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved