Unit 3 Exam

CSS

Adds colors, fonts, and other design elements to website

Databases, authentication, and user accounts are all part of a website's ____.

Backend

The vast amount of data collected from Internet searches, social media posts, customer transactions, military surveillance, medical tests, weather sensors, and other data sources are collectively referred to as _____.

Big data

A developer is writing a program that will store the value of a single character. Which of the following datatypes will work best to store this value?

Char

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

Constants

HTML

Creates website structure and content

______ is a principle that limits access to certain parts of a program to public methods.

Encapsulation

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

Fields

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

First name

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

For one table to reference records in another table

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

Foreign Key

Report

Formatted summary of information from a database

Computer programming is ______.

Giving a computer precise instructions for what it should do

A software developer is creating a variable to hold whole numbers and will perform numeric operations on the values stored in that variable. Which of the following data types is the best for this purpose?

Integer

The idea of programming by modeling real-world things into computer code is called _____.

Object-oriented programming

In programming, which of the following is the best use of a function?

Provide reusable code snippets

Gina is a database user and her supervisor has asked her to generate a report from the structured database. Gina does not know how to write SQL commands and no forms have been created. Which of the following would be her BEST option to generate the report?

Query builder

A business user wants to retrieve data from a relational database. Which of the following would they use to get the data they need?

Query language

In a relational database table, rows are better known as _______.

Records

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

Report

An application developer needs to store configuration data that can be retrieved each time the application is launched. The data must be in a format that could possibly be easily viewed outside of the application and edited using any editor. Which of the following would be the best choice?

Text-based flat file

After running the following pseudocode, what will the value of the variable be?

10

Which of the following logic components is being used and how much is the interest if the amount is 5,000?

8% and Branching

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

Algorithm

Which of the following SQL commands would you use to delete an entire table and all of is data?

DROP

Which of the following terms describes the set of SQL commands that change the structure of schema of a database, such as the DROP command?

Data Definition Language (DDL)

What group of database commands is used to define and modify metadata?

Data definition

Alberto works in human resources and wants to move all personnel files to a system that would provide a user interface for adding, updating, and removing personnel records. He also wants to ensure the data cannot be viewed without correct permissions. Which of the following would be the best option to restore and retrieve this data?

Database

Using HTML and CSS to provide visual elements to the end user would be considered part of a website's ____.

Frontend

Which of the following is technically not a programming language?

HTML

A database administrator is setting up a new table that will contain customer information. The fields include name, address, company, phone, email, and customer ID. The administrator is using the customer ID to uniquely identify each customer record. Which of the following best descries the customer ID field?

Primary Key

A developer is working on an application that needs to be able to read, write, update, and delete database records. Which of the following database access methods should the developer use?

Programmatic access

Which of the following describes a code snippet?

Pseudocode

Edward, a database user, would like to gather some specific information from a database and then manipulate the data in a spreadsheet. Edward then wants to save that information in a file format that will be used by another application. Which of the following database features would work best to accomplish this?

Query

Query

Retrieves specific information from a database. Can also be used to update, edit, and remove data

Marty, a database administrator, needs to build a database query that will return results from the start of January through the end March. Which of the following commands would be used?

SELECT

Which of the following is a SQL statement?

SELECT * FROM Orders WHERE OrderID+5

A developer is creating an application hat required a value to be stored with decimal precision. Which of the following data types should be used for the variables that will store these values?

Float

Julien, a programmer, was fixing a bug in the programming code written by another developer. He discovered that the code with the bug was repeated several times. Instead of fixing he bug in multiple places, which of the following programming features should he use so the code i only located in one place?

Functions

Alan, a programmer, needs to create an interactive web page. Which of the following programming languages types would he most likely use?

Interpreted

Diana, a developer, needs to program a logic component that will allow the user to enter a series of values. Which of the following would best provide that functionally?

Looping

Cindy wants to use a database to store and retrieve information for a research project. She has gathered photos, newspaper articles, interviews, and notes. The information does not appear to have a clear pattern. Which of the following types of data does Cindy want to store?

Non-structured

Which of the following flow chart concepts is depicted below?

Sequence

A business wants to set up a database to store customer and order information. They have decided to use a relational database. Which of the following is the main benefit of using a relational database?

The data can be organized into separate tales that are related to each other

Form

User-friendly interface for adding to or retrieving information from a database

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

Assembly

A user is shopping online and has added two items to the cart. When the user clicks the Checkout button, the shopping cart programming logic checks to see if the user is logged in already. If the user is logged in, the checkout process continues, otherwise, the user is prompted to sign in. Which of the following describes the logical component being used?

Branching

A database administrator ants to export all the data in a database to a comma separated value file. (.CSV) where it can be opened by spreadsheet software. which of the following would be the easiest way to create the exported file?

Database Dump

A developer is creating a program that will store a customer's latest order number. The value will change each time a custom creates a new order. Which of the following would most likely be used to store the value?

Variable

Table

Stores raw data in a relational database

A software developer wants to provide a compiled executable program to a customer. Which of the following computer languages would provide this capability?

C++

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

Constraint

JavaScript

Makes website elements interactive

Which of the following is a type of variable that can hold many values at the same time?

Array

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

Attributes

A database administrator wants to export a table as a backup before changes are made to the table structure. Which of the following commands should be executed?

BACKUP

A programmer is creating an application that needs to store a value indicating if the user is logged in or not. Which of the following would be the best data type to accomplish this?

Boolean

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

Objects