What is the use of Referential Integrity in MS Access?

  1. Home

- Online Exam Test Papers | - MCQs[multiple choice questions and answers ] | - Mock Test Papers | - Practice Papers | - Sample Test Papers |

Question:
What is the use of Referential Integrity in MS Access?

1.It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table

2.It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table

3. It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table

4.None of above

Posted Date:-2021-02-19 15:09:45

More MCQS Questions and answers

  1. To create a table in Access
  2. Primary key is
  3. In a table to insert User’s Voice, Data field should be
  4. In MS Access “Hyperlink” Data Type can store
  5. in MS Access, AutoNumber Data Type
  6. in MS Access, OLE Object Data type can store
  7. in MS Access, which data type is appropriate to store large text and numbers?
  8. On the property sheet, which of the following tabs contains the Caption property?
  9. To assign a macro to an event, users need to open the form in Design View.
  10. What is the use of Cascade Delete Option in MS Access?
  11. Which control lets a user create multiple pages in a form?
  12. Which of the following statements regarding charts is incorrect?
  13. A collection of related tables is called
  14. A report module includes code for all event _______ triggered by events occurring on a specific report or its controls.
  15. A(n) ____ is the default control for a Yes/No field.
  16. A(n) _______ is major object that completes an action or a set of actions.
  17. A(n)_______ is a major object that can run independent of a control.
  18. After creating the table which of the following is correct?
  19. By default, what is the name of a new module in the Modules folder of the Project pane called?
  20. Data can be import into Access Database from
  21. In a module, a(n) _______ is a series of commands and properties that perform a specific task.
  22. In a module, the VB Name used to display a warning query icon is _______.
  23. In MS Access “Lookup Wizard” is used to
  24. In MS Access, Field Value may contain
  25.  Which of the following is not a valid Data Type in MS Access?
  26. Macros can recover from _______ in a controlled manner.
  27. Queries can be created in Access by
  28. Query can be use to select data from
  29. Relationship can be establish between two tables by
  30. The appropriate Data Type to store Time in MS Access?
  31. The option button ____ identifies each button or check box in an option group.
  32. The option group ____ describes the contents of the entire option group.
  33. The VB Name used to display the warning message icon is _______.
  34. Validation Rule in a field will
  35. What happens when a user double-clicks an object in the Project pane of the Visual Basic Editor?
  36. What is the use of Referential Integrity in MS Access?
  37. Which of the following components has a property sheet that includes settings for the frame and the option group?
  38. Which of the following data type is used to store logical value in MS Access?
  39. Which of the following Data Type is used to store picture in MS Access
  40. Which of the following Format supports for Data Type Yes/No?
  41. Which of the following is a condensed form of standard generalized markup language?
  42. Which of the following is invalid field name?
  43. Which of the following is the DBMS type
  44. Which of the following is use to get data from user?
  45. Which of the following is use to view or print the data in organized manner?
  46. Which of the following options is NOT a part of an option group?
  47. Which of the following relationship is not valid in MS Access ?
  48. Which of the following statements about a tab control in a form is incorrect?
  49. Which of the following statements about option group is incorrect?
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!