WorksheetsTest Out Chapter 7 and 8 programming and databases
Total questions: 44
Worksheet time: 33mins
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
Float
Integer
String
A developer is creating an application that requires 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?
String
Boolean
Float
Integer
A developer is creating a program that will store a customer's latest order number. The value will change each time a customer creates a new order. Which of the following would MOST likely be used to store the value?
Object
Array
Variable
Constant
Which of the following programming models are built from class templates that have properties, attributes, and methods?
Encapsulation
Objects
Vector
Functions
Which of the following is a programming identifier that would be used to define values that don't change?
Arrays
Variables
Vectors
Constants
In object-oriented programming, which of the following concepts is used to describe properties?
Methods
Polymorphism
Attributes
Encapsulation
A software developer wants to provide a compiled executable program to a customer. Which of the following computer languages would provide this capability?
Ruby
PowerShell
Perl
C++
Alan, a programmer, needs to create an interactive web page. Which of the following programming languages types would he MOST likely use?
Interpreted
Query
Assembly
Compiled
On a flowchart, which of the following represents a decision?
Rectangle
Diamond
Arrow
Parallelogram
Which of the following BEST describes a flowchart?
It does the same thing over and over in exactly the same way.
It starts at the first line and then executes one line at a time until the end.
It is a step-by-step procedure that illustrates how a problem is to be solved.
It is a visual representation of the logic in a program.
What is the term for code that keeps running as long as a certain condition is met?
Branch
For loop
While loop
Decision
You are working on a program that needs to keep track of many values at the same time. Which of the following would you use?
A variable
An array
A float
A constant
What makes website elements interactive?
JavaScript
HTML
CSS
Which program adds colors, fonts, and other design elements to website
CSS
JavaScript
HTML
What creates website structure and content
CSS
HTML
JavaScript
Which programming language type is the most basic human-readable and closest to actual machine language?
Assembly
Compiled
Query
Interpreted
Which of the following tags contains all the elements that will be presented on the visual portion of a website?
<p></p>
<div></div>
<body></body>
<head></head>
How many heading tags are available for heading and subheading when using HTML?
8
6
2
4
To be a proper HTML document, there are a few tags that every web page needs. What is the correct answer ?
<head>
</body>
<head>
<body>
</html>
<html>
<head>
</head>
<body>
</body>
</html>
Which of the following are the proper HTML tags used to create a numbered list?
<ol>
<i>Item 1</i>
<i>Item 2</i>
<i>Item 3</i>
</ol>
<ol>
<li>Item 1</li>
<li>Item 2</li>
<li>Item 3</li>
</ol>
You want to have a hyperlink to testout.com on your web page. What is the correct HTML syntax to accomplish this?
<a href="www.testout.com">Link to the TestOut homepage</a>
<a href=>Link to the TestOut.com homepage</a>
<a href="www.testout.com"></a>
<a href=www.testout.com>
What lets the browser know that it should interpret the document as HTML?
<html>
<head>
<body>
What contains all the elements that will be presented on the screen.
<body>
<html>
<head>
What contains the title of the web page, links to stylesheets, and metadata to help search engines find the page?
<html>
<head>
<body>
What does JavaScript do?
Links digital objects to each other.
Makes web pages interactive.
Makes websites look good.
Contains the title of the web page.
Which of the following BEST describes a back-end developer?
He or she controls what you see visually in your web browser when you visit a site.
He or she needs to make the website as user-friendly as possible
He or she accesses information from databases and prevents unauthorized access.
He or she uses HTML, CSS, and JavaScript to determine the way a website looks.
Which of the following BEST describes a front-end developer?
He or she may use query languages like SQL.
He or she is concerned with the aesthetics of a website.
He or she services the website and manages user accounts.
He or she may use Ruby, Java, PHP, and Python.
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
User interface access
Programmatic access
Direct access
April is a database manager who wants to insert some new records (rows) into the company's customer contact database. Instead of using a database client to insert the records, she wants to use a command.
Which of the following languages provides a command for inserting records into a database?
DDL (Data Definition Language)
DCL (Data Control Language)
DML (Data Manipulation Language)
HTML (HyperText Markup Language)
Which of the following are the four general tasks a user needs to perform for a database to function properly?
Create, Reuse, Unleash, Delete
Create, Read, Update, Delete
Create, Read, Unleash, Deny
Configure, Read, Update, Deny
Which process exports a database into a format that can be read by another program like a spreadsheet?
Database backup
CRUD
Database dump
CSV
Which SQL command is used to give a user permission to a specific database object?
REVOKE
UPDATE
VALUES
GRANT
Mary needs to view the records from the Clients table that pertain to Travis. Which command should she use?
UPDATE * FROM Clients WHERE name = Travis
SELECT Travis FROM Clients
SELECT * FROM Clients WHERE name = Travis
SELECT ^ FROM Clients WHERE name = Travis
Mary needs to view all records from the Clients table. Which command should she use?
SELECT * FROM Clients
WHERE * FROM Clients
SELECT ^ FROM Clients
WHERE ^ FROM Clients
Which command is used to add, change, or remove fields on an existing table?
CREATE TABLE
DROP TABLE
ALTER TABLE
INSERT INTO
What is the computer language that makes relational databases work?
Python
SQL
C++
Java
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?
Query builder
Direct access
User interface access
Programmatic access
Which type of data have elements in common but do not fit into rigid rows and columns in a table?
Non-relational
Structured
Non-structured
Semi-structured
What is the technology that aggregates structured data from one or more sources called?
Data warehousing
Non-relational
Relational
Big Data
Which of the following acronyms describes the traditional way to make sure data stays consistent across the entire database?
CRUD
ACID
DBA
SQL
What are non-relational databases that deal with Big Data often referred to as?
SQL
NoSQL
RDBMS
CRUD
The concern that Big Data is often obtained without the knowledge or consent of users falls under which Big Data concept?
Data analytics
Data extraction
Data ethics
Data mining
What is asking specific questions to interpret Big Data called?
Data analytics
Data extraction
Data ethics
Data mining
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 be easily viewed outside of the application and edited using any editor. Which of the following would be the BEST choice?
Binary flat file
Database Management System
Relational database
Text-based flat file
