IT Week 12

You need to know how to program to

• create animations in PowerPoint.

• 1. create unique software solutions for specialized problems

• 1. use Microsoft Word to type text and select various fonts

• 1. open a template file for budgeting in Microsoft Excel.

What is the first step of the SDLC?

• Design

• Analysis

• Development

• Problem identification

How the program should behave if the input data is invalid is part of

• process

• scope creep

• beta testing

• error handling

The database programming language SQL stands for

• Structured Question Lingo

• Structured Query Language

• Selected Query Launch

• Simple Quick Language

When is a flat database sufficient to use when organizing data?

• 1. When the data needs to be organized into two or more tables

• 1. When the data is simple and can be organized in one table

• 1. When more than one person needs to access the data

• 1. When the data includes video and audio

A process to ensure that data in a database is organized most efficiently is called

• 1. centralization

• 1. data staging

• 1. normalization

• 1. integration

Data captured as users navigate through a website is called

• 1. staged data

• 1. web-user data

• 1. time-variant data

• 1. clickstream data

Which of the following is used to create a subset of data that matches certain criteria and that can be saved for future reference or use?

• Relationship

• Query

• Request

• Filter

Which of the following data-mining techniques is used to create charts and dashboards?

• Classification

• Affinity grouping

• Clustering

• Visualization

Unnecessary duplication of data in a database is referred to as

• 1. data redundancy

• 1. normalized data

• 1. validated data

• 1. data inconsistency