Unit 6 evaluation test. Relationships

There is only one correct answer to each question. Click on the answer you consider to be correct.

Answer all the questions and press the Revise button to see the answers.

If you press Reset you will be able to repeat the evaluation.

1. The relationships most frequently defined are one-to-many relationships.
a) True.

b) False.


2. We can use any kind of field to relate two tables.
a) True.

b) False.

3. Once we have some tables in the Relationships window, we can not add more tables.
a) True.

b) False.


4. La primary key will normally be one of the related fields between two tables.
a) True.

b) False.

5. If I delete a table from the Relationships window all of its associated relationships are deleted from the database.
a) True.

b) False.

6. The button serves to...
a) ... visualize all the relationships associated to a table.

b) ... visualize all defined relationships within a database.

c) ... add a relationship.

7. The button serves to....
a) ... delete a relationship from the database.

b) ... leave the Relationships window blank.

c) ... remove a relationship from the Relationship window without deleting it from the database.

8. Every time I want to define a new relationship between two tables...
a) ... I need to add these tables to the Relationships window.

b) .. only add the tables if they are not already in the window.

c) ... there is no need to add them as they are always in the window.

9. Referential Integrity is...
a) ... a rule that obligate that once a record is deleted from the primary table, the related records are deleted from the related table.

b) ... a rule that enables it so that on editing a record in a table, it is edited in the other table as well.

c) Both of the previous answers are true.

d) All three answers are false.


10. To be able to define a relationship...
a) ... the two related fields must be the same data type.

b) ...the two fields that intervene in the relationship must have the same name.

c) Both of the previous answers are true.

d) All three answers are false.




   

Ev. Page
6.1

Aviso legal: Uso off-line autorizado a alumnos de aulaClic exclusivamente. No está permitido utilizar estos cursos en empresas, academias o centros de enseñanza privados.

© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited. April-2006.