Unit 7 evaluation test. Queries

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. A query allows us to select data from tables or from another query.
a) True.

b) False.


2. If we change any data from the result of the query, this data will also be changed in the source table.

a) True.

b) False.

3. The rows in a query can be sorted into more than one field.

a) True.

b) False.


4. A query can be based on more than one table.
a) True.

b) False.

5. In order to use a field in a search criteria, this must be seen in the result of the query.
a) True.

b) False.

6. The button serves to...
a) ...execute the query.

b) ...access the help window.

c) ...change the type of query.

7. If in the tables area there are two tables not combined...
a) ... impossible, tables always appear joined.

b) ... I obtain all the possible combinations of the rows in the two tables.

 

8. If an arrow appears between the two tables in the tables areas...
a) ...the result will include all the records of the table that receive the arrow.

b) ...the result will include all the records of the table where the arrow begins.


c) ...impossible, an arrow can not appear.


9. To express two conditions using AND operator.
a) Both conditions need to be written in the same Criteria: row

b) Both conditions need to be written in different Criteria: rows.

c) Both answers are correct.

d) All three answers are false.

10. If I want to use wildcard characters in a condition...
a) ... its not possible.

b) ... I must type the wildcard character into brackets.

c) ...I must use the LIKE operator.

d) ...I do not need to do anything special.




   

Ev. Page.
7.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.