Dear All,
Please can help me in answering the following questions. I have an exam coming up very soon and would be extremely grateful for any help.
Thanks in advance for all your help!!
1. What happens when 2 queries are in same worksheet and you drill down on the first query
a. If u include 2 queries in a Workbook
b. The result of first query will affect the second query
c. User will be able to access First query only
d. The Display area of second query will be affected by result of first query.
2 .If you put two queries on a Report Designer then how will they conflict?
a. The display of one query effect the display of other
b. The result of one query will affect other
c. During final result, the result of one will affect other
3. .for global use of variable, they should be created at
a. InfoProvider level
b. Object level
c. Query level
4. which of the possible ways i need to use to send a report having single file forward a report...
a. use an email with html attached
b. use an email with a file zipped
c. use an email with a file and html separately.
5. A client wants the data in form of email in a single file bearing the report regarding the sale increase by 10% what will u suggest as the broadcasting type?
a. pre-calculated work book value.
b. tml with zip
c. independent html without zip
d. control query.