TestOut IT Fund Ch 7 & 8

Question 1

A software developer is working on a website and has been tasked with adding interactive elements to it. Choose one

Accepted Answer

JavaScript

Question 2

The concern that Big Data is often obtained without the knowledge or consent of users falls under which Big Data concept

Accepted Answer

Data ethics

Question 3

A programmer has created specific statements, including conditional loops to accomplish a task. What has she created?

Accepted Answer

Algorithm

Question 4

Which of the following programming models are built from class templates that have properties, attributes, and methods?

Accepted Answer

Objects

Question 5

Mary needs to view all records from the Clients table. Which command should she use?

Accepted Answer

SELECT * FROM Clients

Question 6

What is the general term for software that creates and manages databases?

Accepted Answer

DBMS

Question 7

Data collected from Internet searches, social media, customer transactions, military surveillance, medical tests & more

Accepted Answer

Big Data

Question 8

On a flowchart, which of the following represents a decision?

Accepted Answer

Diamond

Question 9

Which of the following careers is responsible for backing up and securing an organization's databases?

Accepted Answer

Database administrator

Question 10

Software developer wants to add custom Google Map to a customer's website. Which would the developer use?

Accepted Answer

Application programming interface (API)

Question 11

Which of the following is a way for programmers and others to make sense of complex business flows

Accepted Answer

Data modeling

Question 12

Which of the following is a programming identifier that would be used to define values that don't change?

Accepted Answer

Constants

Question 13

What is the term for code that keeps running as long as a certain condition is met?

Accepted Answer

While loop

Question 14

A developer is creating an application that requires a value to be stored with decimal precision. Which data type?

Accepted Answer

Float

Question 15

Which of the following should not be used as a primary key in a table?

Accepted Answer

First name

Question 16

Which of the following BEST describes a back-end developer?

Accepted Answer

They accesses information from databases and prevents unauthorized access

Question 17

Which database access methods should the developer use to be able to read, write, update, and delete database records?

Accepted Answer

Programmatic access

Question 18

A programmer is creating an application that needs to store a value indicating if user is logged in or not. Which one?

Accepted Answer

Boolean

Question 19

Which of the following is the main benefit of using a relational database?

Accepted Answer

Data can be organized into separate tables that are related to each other.

Question 20

Diana, a developer, needs to program a logic component that will allow the user to enter a series of values.

Accepted Answer

Looping

Question 21

A programmer needs to create an interactive web page. Which programming languages types would he MOST likely use?

Accepted Answer

Interpreted

Question 22

Which of the following is found in one or more columns of data and contains a unique identifier for the row?

Accepted Answer

Primary Key

Question 23

What is the technology that aggregates structured data from one or more sources called?

Accepted Answer

Data warehousing

Question 24

What are non-relational databases that deal with Big Data often referred to as?

Accepted Answer

NoSQL

Question 25

You are working on a program that needs to keep track of many values at the same time. Which would you use?

Accepted Answer

An array

Question 26

Marty has added a foreign key to a table in a database. Which of the following describes the purpose of a foreign key?

Accepted Answer

For one table to reference records in another table.

Question 27

Which acronym describes the traditional way to make sure data stays consistent across the entire database?

Accepted Answer

ACID

Question 28

In object-oriented programming, which of the following concepts is used to describe properties?

Accepted Answer

Attributes

Question 29

Software developer wants to create application that will work on Windows 7 Apple iOS operating systems. What's easier?

Accepted Answer

Use the APIs for each operating system.

Question 30

What is the computer language that makes relational databases work?

Accepted Answer

SQL

Question 31

Which of the following DBMS programs is open source?

Accepted Answer

MySQL

Question 32

Which of the following database objects provides a summary of data?

Accepted Answer

Reports

Question 33

Which data type uses historical data to make decisions in the present?

Accepted Answer

Analytical

Question 34

Which SQL command is used to give a user permission to a specific database object?

Accepted Answer

GRANT

Question 35

Which command is used to add, change, or remove fields on an existing table?

Accepted Answer

ALTER TABLE

Question 36

Which of the following makes it easier for users to enter data into their tables?

Accepted Answer

Forms

Question 37

In a relational database table, columns are better known as ________________.

Accepted Answer

Fields

Question 38

Which of the following BEST describes a front-end developer?

Accepted Answer

He or she is concerned with the aesthetics of a website.

Question 39

Which of the following are the four general tasks a user needs to perform for a database to function properly?

Accepted Answer

Create, Read, Update, Delete

Question 40

A NOT NULL __________ is a rule that prevents certain fields in a database from being left blank.

Accepted Answer

constraint

Question 41

What is asking specific questions to interpret Big Data called?

Accepted Answer

Data analytics

Question 42

Developer is creating a program that will store a customer's latest order number. Value will change each time.

Accepted Answer

Variable

Question 43

Which type of data have elements in common but do not fit into rigid rows and columns in a table?

Accepted Answer

Semi-structured

Question 44

Which data model focuses on high-level concepts?

Accepted Answer

Conceptual

Question 45

A value that's used to identify a record from a linked table is called a ________________.

Accepted Answer

Foreign Key

Question 46

Which process exports a database into a format that can be read by another program like a spreadsheet?

Accepted Answer

Database dump

Question 47

Python provides programming functions that can be used by a software developer. Which is correct?

Accepted Answer

import random

Question 48

Which type of analytical data can help you make investment decisions?

Accepted Answer

Market

Question 49

Which database object is essentially questions that we can ask the database?

Accepted Answer

Queries

Question 50

A software developer wants to provide a compiled executable program to a customer. Which language?

Accepted Answer

C++

Question 51

Which of the following needs to be done before Big Data can be analyzed and interpreted?

Accepted Answer

Data extraction

Question 52

Mary needs to view the records from the Clients table that pertain to Travis. Which command should she use?

Accepted Answer

SELECT * FROM Clients WHERE name = Travis

Question 53

Which programming language type is the most basic human-readable and closest to actual machine language?

Accepted Answer

Assembly

Question 54

Which of the following database features would provide a formatted, easy-to-read listing of the results of a query?

Accepted Answer

Report

Question 55

Which of the following BEST describes a flowchart?

Accepted Answer

It is a visual representation of the logic in a program.

TestOut IT Fund Ch 7 & 8

Questions 55

TestOut IT Fund Ch 7 & 8

Questions 55