Daily Archives: September 30, 2015

Data Warehousing Test

1. Which of the following are the modes of OLAP? Answers: MOLAP ROLAP KOLAP 2. OLAP queries can be characterised as on-line transactions that do not: Answers: Access small amounts of data Analyse the relationships between many types of business elements e.g. sales, products, regions, and channels Compare aggregated data over hierarchical time periods e.g. [...]

By | September 30th, 2015|Upwork Databases|0 Comments

Data Structures Test

1. Which graph traversal algorithm uses a queue to keep track of the vertices which need to be processed? Answers: Breadth-first search Depth-first search 2. A simple graph with n vertices and k components can have at the most _______. Answers: n edges n-k edges (n-k)(n-k-1)/2 edges (n-k)(n-k+1)/2 edges 3. What is the minimum number [...]

By | September 30th, 2015|Upwork Databases|0 Comments

ANSI SQL Test

1. The simplest query must include at least________ and _________. Answers: A select clause A where clause A from clause A group by clause A having clause An order by clause 2. Which of the following are aggregate functions in SQL? Answers: Avg Select Order By Sum Union Group by Having 3. Which logical operator [...]

By | September 30th, 2015|Upwork Databases|0 Comments

Windows XP Test

1. Which of the following descriptions about the Windows Task Scheduler is most accurate? Answers: It is a tool that enables you to schedule programs and other utilities to run regularly, when it is most convenient for you. t is a utility available in the Windows Accessories that helps you arrange your daily routine and [...]

By | September 30th, 2015|Upwork Computer Skills|0 Comments