Unit 8 evaluation test. Summary 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 summary query allows us to see the rows contained in a table and at the end a new row with totals.
a) True.


b) False.


2. If we edit any of the data resulting from a summary query, this data will also be edited in the source table.

a) True.


b) False.


3. The Min value of a date type column would be the oldest date.
a) True.


b) False.



4. A summary query can be defined from more than one table.
a) True.


b) False.

5. When the average of a column is being calculated, the null values count as zero values.
a) True.


b) False.


6. The button serves to...
a) ...total a column.

b) ...add a Total: row to the query.

c) ...add a new table to the query.

7. To select the source rows of a summary query....
a) ...Impossible, it always picks all the source rows.

b) ...in the column that contains the search criteria, the Total: row contains Where value.

c) ...in the column that contains the search criteria, the Total: row contains Expression value.


8. If we group by way of two columns...
a) ..we will obtain two resulting rows.

b) ...we will obtain a number of rows according to the values contained in the columns.

c) ...impossible, it can not goup by way of two columns.

9. In a column of the QBE grid of a summary query...
a) ...total(amount)/avg(price) can not be written in the Field: row.

b) ...total(avg(amount)) can not be written in the Field: row.

c) Both the previous answers are correct.

d) All three answers are false.

10. A summary query obtains only one resulting row at most...
a) ...if there are no group columns.

b) ...only if the source table has only one row.

c) ...depending on how many rows the source table has.

d) All three answers are valid.




   

EV.Page.
8.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.