Data Types & Measurement
Notation and Character Sets
Data Analytics & IP
Programming
Databases
100

Most likely data type for this value: 43.22

What is floating point?

100

Character set most likely used to represent international text data.

What is Unicode?

100

IP protection that prohibits Jay from burning a copy of his Guardians of the Galaxy blu-ray disc for a friend.

What is copyright?

100

Value that can change when a program is executed.

What is a variable?

100

Name one advantage of a RDBMS over a flat file system.

What are: scalability, enforcement of data types; links between tables, number of concurrent users?

200

Most likely data type for this value: 221-B Baker Street

What is String?

200

Notational system that uses two digits, also known as base 2.

What is binary?

200

Software can be protected by these two IP protections.

What are copyright and patent?

200

Presents machine code in human-readable text.

What is assembly language?

200

This column contains unique values for each record and will be used to relate a table to other tables.

What is a primary key?

300

When data is transferred over a network or between computer components, connection speed is measured in this:

What is (multiples of) bits per second?
300

Notational system that allows you to represent the largest values with the fewest digits.

What is hexadecimal notation?

300

When data analytics software produces graphs, charts, or other human-friendly products that help with business insights, this is:

What is meaningful reporting?

300

One advantage and one disadvantage of compiled code.

What are better speed and platform dependence?

300

This kind of database is non-relational and semi-structured. It uses JSON (JavaScript Object Notation) to organize information.

What is a Key/Value Pair database?

400

Processor speed for a modern CPU is measured in this unit.

What is GHz?

400
The binary number 00000011 represents which decimal value?

What is 3?

400

Comparing the cost of a security solution with the likelihood and potential cost of a data breach.

What is Return on Security Investment (ROSI)?

400
Key difference between procedures and variables.

What is: function can return a value to the program?

400

UPDATE TableName changes column values. It is a Data _________ Language command.

What is Manipulation?

500

Number of bits in 2KB

What is 16,000?

500

The number 17 in hexadecimal notation.

What is 11?

500

Data analytics software detects that visitors to an online dating site spend more time on profiles with higher-definition photographs. This is an example of:

What is data correlation?

500

Result produced by the following code:

Do While i <= 25

     i=i+1

     print i

Loop

What is: print (display) numbers from 1 to 25?

500

SQL query that will display all records from a table called Students in which the value in a field called Program is IT.

What is:

SELECT * FROM Students

WHERE Program='IT';

M
e
n
u