Important QnA referential integrity class 10

Important QnA referential integrity class 10 provides you with the questions and answers which help you to understand the concept and prepare well in exams. So don’t skip the article and read it completely. So here we go!

Important QnA referential integrity class 10

If you are a regular visitor of our blog then you must know that we are starting our important QnA article with objective type questions and then subjective type questions. So lets start Important QnA referential integrity class 10 with one mark questions.

  1. The ____________ is used to maintain accuracy and consistency of data in a relationship. (Ans. referential integrity)
  2. In OO base you cannot link data between two or more tables. (True/False)
  3. A ___________ refers to an association or connection between two or more tables. (Ans. relationship)
  4. The use of relationship in a database will help to reduce the data entry errors. (True/False)
  5. Which of the following menu provides you with the Relationship command in OO base?
    1. Edit
    2. View
    3. File
    4. Tools
  6. Which of the following is a valid relationship(s)?
    1. One to One
    2. One to Many
    3. Many to One
    4. All of these
  7. The New Relation command is available under which of the following menu when you are working with a design window of relationship?
    1. Insert
    2. Edit
    3. Tools
    4. File
  8. Which update or delete option allows to update or delete the record when the changes made to the primary key table?
    1. No action
    2. Update cascade/Delete cascade
    3. Set null
    4. Set default
  9. You can edit the relationship in OO base once it is created. (True/False)
  10. To remove the relationship which of the following step is correct:
    1. Click on the connecting line and click Edit > Delete Option
    2. Right-click on connecting line and choose the Delete option
    3. Drag the field outside area of relationship
    4. Select the field and press delete key

Now in the next section we will discuss the subjective type questions from Important QnA referential integrity class 10.

Subjective Type Questions

In this section of QnA referential integrity class 10 if the answers are not provided use the link for the answers.

Follow the below given link to find the answers.

Recommended – Referential Integrity

  1. What do you mean by referential integrity? Explain with example.
  2. What are the advantages of referential integrity?
  3. What are the types of relationships?
    1. One to One
    2. One to many or many to one
    3. Many to Many
  4. What are the ways to create relationships?
    1. Insert Menu
    2. Drag and Drop
  5. Write steps to create the relationship in OO base.
  6. Explain the update and delete options available in the relations dialog box.
    • There are four options available in the relations dialog box for update and delete options:
      1. No action – This means when the record from the parent table (primary key table) is updated or deleted there will be no change in the child table (foreign key table).
      2. Update cascade/ Delete cascade – This option update or delete records in both tables automatically when changes made to the parent table.
      3. Set null – When a record in the parent table is updated or deleted the child table values set null itself.
      4. Set default – When any changed made to parent table the default value is going to set in the subordinate table.
  7. Write steps to edit the relationship.
    • Open relationship window through Tools > Relationships. A new window will open.
    • Click on connecting line.
    • Right-click on the line and select the Edit option.
    • Relations dialog box will open, select the desired options and click on OK.
  8. How to remove a relationship?

That’s all from this article QnA referential integrity class 10. I hope this will help to understand the concept well. If you have any doubts or queries feel free to ask in the comment section.

You can share your views, feedback, suggestions through comment section.

Thank you for reading this article QnA referential integrity class 10.

Leave a Reply