BIS 345 MENTOR Think Big /bis345mentor.com BIS 345 MENTOR Think Big /bis345mentor.com | Page 4

11. (TCO 4) Assume you have two queries that must extract all
rows that have a value of greater than $100 in an Income column.
You are considering two ways of writing your WHERE clause. The
first option is to extract all columns that are NOT less than or
equal to $100. The second option is to extract all columns that are
greater than $100. Which option should you choose to ensure
your query runs as quickly as possible? (Points : 5)
The first option
The second option
It doesn't matter which option you pick; they will run the same no
matter what.
All of the above
12. (TCO 7) Which of the file formats can be viewed using Adobe
Acrobat Reader? (Points : 5)
CSV
PDF
TIFF
XLSX
13. (TCO 8) Name the security concept involves ensuring that
one person doesn't have control over too many steps in a
process. (Points : 5)
zroles
Separation of duties
Securing forms and reports
Using views
14. (TCO 8) _____ encryption offers a more granular level of
encryption. (Points : 5)
Role based
Object-based security
Column-level