Module 2 Review Questions

Give an example of unstructured data.

Images, text files, and other document formats

What part of the process of data analytics is most closely supported by meaningful reporting?

Insights

Which data type provides for whole numbers only?

Integer

Give two examples of semi-structured data stores.

Key/value pair databases/markup language document

What is it that defines the relationship between tables in an RDBMS?

Primary key

What is the difference between a procedure and a function?

Procedure does something/function does something but returns a value

You need a developing environment with a library of database functions. What type of interface are you using?

Programmatic Access

What are constants and variables examples of?

Programming identifiers

What type of software manages tasks, dependencies, and timelines?

Project Management

What shows the structure of the code without using the specific syntax of any one language?

Pseudocode

What term is used to describe selecting and viewing information in a database?

Query

What type of software would you use to configure a server by connecting to it over the network?

Remote Desktop

Why might one of your first tasks on receiving a new computer be to remove software applications?

Remove unnecessary bloatware/bundled software

In a program, what does a loop do?

Repeats a task until the condition(s) is met

What language is usually used to request data from an RDBMS such as Oracle?

Structured Query Language

True or false? You do not need to install a web application to your computer; it would be accessed via a browser.

True

What three things define an object?

Attributes, methods, and properties

What is the advantage of a local network hosted application, in terms of data storage?

Backups the data and stores it in another storage location

What three scripting options are commonly used in Windows 10 to perform administrative tasks?

Batch files, Powershell scripts, and VB scripts

What are the structural elements of a database table?

Columns(fields) and rows(records)

What is an interpreted language?

Does not need to be compiled

What is the difference between freeware and open source software?

Freeware is free of charge to use but prohibits any changes made to the software and cannot be redistributed for commercial purposes/Open source is open to the public and allows changes to be made to the software

In order to obtain support, the software vendor wants to know the application's product ID. How would you locate this information?

Help menu of the software, in the About tab

Which notation system supports presenting the largest numbers using the fewest digits: Binary, Decimal, or Hexadecimal?

Hexadecimal

How does an RDBMS such as Microsoft SQL Server differ from Microsoft Excel when used to store a dataset?

Excel is a flat-file and is not scalable while RDBMS is the opposite

Windows comes with web server software but it is not enabled by default. How would you install this software?

Turn Windows Features On or Off

How can a client-server application architecture be described if there is the potential for the structure of the application platform to be developed further?

Two-tier client-server application

Which data representation format can encode the widest range of characters?

Unicode

What type of programming concept allows for a variable size container?

Vector

Following installation of a program written for an older version of Windows, you receive an alert that it might not have installed correctly. What feature could you use to make the program run correctly?

Compatibility Tab

What compatibility information should you confirm before installing a software application?

Compatible w/ operating system and hardware

You want to check whether a condition has been met, and if it has, perform one action. Otherwise, you want your program to perform a second action. What sort of programming operation would help achieve this?

Conditional branch; if then statement

How is a markup language differ from a compiled language?

Markup language does not provide instructions for the CPU to run

What is the difference between the char and string data types?

Char is a single textual character/String is a collection or line of characters

What data protection technology could you implement in order to restrict the type of activity that users could employ on digital products that they have purchased or rented?

Digital Rights Management

Following installation of an application, another program on your computer has stopped working. What could you do to fix it?

File repair or reinstallation of program

Is an INSERT statement an example of a definition or manipulation language statement?

Manipulation language statement

What type of legal protection could be obtained for a novel software algorithm?

Patent

Why would Windows prompt you to enter a password if you try to install a software application?

Requires authoritative power to change files