Final Web Programming
The ____ method changes the selection to the sibling element immediately following each selected element.
Next()
By default, field values in an external text file that are being inserted in a table are separated by the ____ keyboard character.
Tab
An HTML document is a text document that contains codes called ____.
Tags
You plan to do some research on the types of web browsers your users will use. Referring to the figure above, this information fits in the ____ section of the project plan.
Target Audience
A Web page ____ is a single Web page that is divided into sections
Template
A __________ allows users to enter multiple lines of text.
Text area
In the figure above, the application "Notepad++" is a(n) ____.
Text editor
Referring to the figure above, the large text box shown to the right of "Feedback, special requests, or other information" is a(n) ____ element.
Textarea
A three-tier, or multitier, client/server system consists of three distinct pieces: These are ____.
The client tier, the processing tier, and the data storage tier
How you enable MySQL support in PHP depends on the version of PHP and how you installed MySQL.
True
In PHP, use the mysql_query() function to send SQL statements to ____________________.
True
Most relational database systems cannot work directly with many-to-many relationships.
True
MySQL Monitor is a command-line program for manipulating MySQL databases.
True
One of the most popular PEAR code modules is PEAR DB, which simplifies access between PHP and a database server.
True
Parentheses are used with expressions to change the associativity with which individual operations in an expression are evaluated.
True
Primary and foreign keys are the only pieces of information in a relational database table that should be duplicated.
True
Primary and foreign keys link records across multiple tables in a relational database.
True
The NOT NULL keywords are often used with primary keys to require that a field include a value.
True
The mysql_fetch_row() function returns the fields in the current row of a resultset into an indexed array and moves the result pointer to the next row.
True
You can include the jQuery library by specifying the location in your HTML document of a jQuery file on a publicly accessible server.
True
jQuery is a cross-browser library.
True
A ____ form contains one page that displays the Web form and one page that process the form data.
Two-part
A system consisting of a client and a server is known as a ____ system.
Two-tier
A(n) ____ operator requires a single operand either before or after the operator.
Unary
The ____ method retrieves the value of the first element in the selection, or sets the value of the selected elements.
Val()
Assignment operators are used to assign a ____ to a variable.
Value
Referring to the figure above, the word "Celebration" is an example of the value of the ____ attribute for an option button.
Value
Which keyword do you use to create a variable?
Var
A result pointer is a special type of ____ that refers to the currently selected row in a resultset.
Variable
One of the simplest types of loop statements is the ____ statement, which repeats a statement or series of statements as long as a given conditional expression evaluates to a truthy value.
While
For any fields that require numeric values, you can use JavaScript's built-in ____ function to determine whether a user actually entered a number.
isNaN()
An input element with a type value of ____ creates a generic button that can be programmed using a script.
Button
Use the appropriate MySQL command to run the Total_Orders stored procedure, storing the results in the variable $t.
CALL Total_Orders($t)
The ___ keyword is used with the ALTER TABLE statement to rename a column in a table.
CHANGE
Type the MySQL command used to define a new stored procedure.
CREATE PROCEDURE
To select elements in jQuery, you specify a(n) ____.
CSS Selector
The ____ is the ordered list maintained by a JavaScript processor containing all the procedures that have been called but have not yet finished processing.
Call Stack
A(n) ____ label in a switch statement represents a specific value and is followed by one or more statements that are executed if the value of the label matches the value of the switch statement's expression.
Case
One way to ensure that a variable is of the correct data type is through type ____.
Casting
After you throw an error, you use a ____ statement to handle the error.
Catch
Referring to the figure above, "Vacation" is chosen by default by using the ____ attribute.
Checked
The ____ method selects the child elements of each element matched by the main selector.
Children()
A case label consists of the keyword case, followed by a literal value or variable name, followed by a ____.
Colon
The ____ operator executes one of two expressions based on the results of a conditional expression
Conditional
Many aspects of the way browsers present browser-based validation feedback are customizable through the properties and methods of the ____.
Constraint validation API
A ____ statement restarts a loop with a new iteration.
Continue
A ____ is a variable that increments or decrements with each iteration of a loop statement
Counter
Referring to the figure above, Monotype Corsiva and Comic Sans are examples of ____ fonts
Cursive
<!DOCTYPE html> creates an element known as the DOCTYPE ____, which lets user agents know that the document contents are written in HTML.
Declaration
The ____ label contains statements that execute when the value returned by the switch statement expression does not match a case label.
Default
A set of connected nodes that are not part of a document is known as a(n) ____.
Document fragment
Instead of document.getElementsByTagName("form")[0], you could use the code
Document.forms[0]
Each piece of data contained in an array is called a(n) ____.
Element
A literal string can be assigned a zero-length string value called a(n) ____ string.
Empty
The symbol ( @), used to suppress error messages, is called ____.
Error control operator
A(n) ____ tells the compiler or interpreter that the character that follows it has a special purpose.
Escape character
A(n) _____ is a specific circumstance that is monitored by JavaScript and that your script can respond to in some way.
Event
____ allows programs to handle errors as they occur in the execution of a program.
Exception handling
A(n) ____ is a literal value or variable that can be evaluated by the PHP scripting engine to produce a result.
Expression
A common use of Web pages is to gather information that is stored in a database on a client PC.
False
A foreign key is a type of index, which identifies records in a database to make retrievals and sorting faster.
False
A logical operator is used to compare two string operands for equality.
False
A related table is the main table in a relationship that is referenced by another table.
False
An anonymous function is a set of related statements that is assigned a name.
False
Database management systems can run on only a single platform.
False
In JavaScript code, you use the words yes and no to indicate Boolean values.
False
Like HTML, XHTML is not case sensitive.
False
Most database management systems can import each other's file formats, and they can also read directly each other's files.
False
MySQL assigns permissions to specify which actions and operations a user can perform with a table or database.
False
MySQL is part of PHP.
False
PHP, you use the mysql_send() function to send SQL statements to MySQL.
False
SQL stands for sequential query language.
False
The PHP Extension and Application Representation (PEAR) is a committee that oversees the open source PHP code.
False
The PRIMARY KEY keywords are used to generate a unique id for each new row in a table.
False
jQuery 2.x supports IE 6, 7, and 8.
False
Referring to the figure above, Papyrus and Impact are examples of ____ fonts.
Fantasy
Referring to the figure above, the box around the text "Schedule" and "Number of nights" was created with the __________ element.
Fieldset
After you evaluate code for exceptions, you can use a ____ statement to perform cleanup or necessary tasks.
Finally
Which jQuery method narrows the group of selected elements to the first element?
First()
(picture has layout with flex boxes)Referring to the figure above, to achieve the page flow shown on the right, you would use _____ .
Float left
Referring to the figure above, the fact that the Web page width can vary means that this is an example of a ____ layout.
Fluid
The ____ statement is used to repeat a statement or series of statements as long as a given conditional expression evaluates to a truthy value.
For
A ____ statement is used to iterate or loop through the elements in an array.
Foreach
In JavaScript programming, you can write your own procedures, called ____, which refer to a related group of JavaScript statements that are executed as a single unit.
Functions
A ____ variable is one that is declared outside a function and is available to all parts of your program.
Global
In the figure above, the meta element can be referred to as a ____ element of the html element.
Grandchild
(1)<!DOCTTYPE HTML>(4)<html>(2)*whitespace*</html>(3), In the figure above item 3 shows a(n)___ tag
HTML
When a client requests a server-side script, a client will never see the server-side script, only the ____ that the web server software returns from the script.
HTML
(1)<!DOCTTYPE HTML>(4)<html>(2)*whitespace*</html>(3), In the figure above item 2 shows a(n)___
Html tag pair
"<html><head><meta charset="utf-8" />", In the figure above, the html element is the ___ element of the meta element.
grandparent
The ___ function returns a text string describing the error in PHP code.
Mysql_error()
Almost every command sent to MySQL from PHP is executed with the ____ function.
Mysql_query()
The ____ package is designed to work with MySQL version 4.1.3 and higher.
Mysqli
The ___ keyword, often used with the primary key, requires that the field include a value.
NOT NULL
Referring to the figure above, the word "occasion" is an example of the value of the ____ attribute for a set of option buttons.
Name
Use a MySQL command to disable autocommit in the current session.
SET AUTOCOMMIT=0
The ____ command with a mysql_query() function executes successfully if the table already exists.
SHOW TABLES LIKE
A command that indicates an action for the browser to take should end with a _____.
Semicolon
Referring to the figure above, Times New Roman and Georgia are examples of ____ fonts.
Serif
On client/server systems, heavy processing, such as calculations, usually takes place on the ____.
Server
Some jQuery animation methods allow you to specify the keywords ____ to set the speed of the animation.
Slow and fast
The variables or values that you place in the parentheses of a function call statement are called ____.
String operators
Programming languages that require you to declare the data types of variables are called ____ typed programming languages.
Strongly
In a ____ programming language the data type for a variable will not change after it has been declared.
Strongly typed
The ____ event fires when a form is submitted.
Submit
The ____ statement controls program flow by executing a specific set of statements, depending on the value of an expression.
Switch
A ____ error occurs when the interpreter fails to recognize code.
Syntax
<html><head><meta charset="utf-8" />", In the figure above, the head element is___.
Both A and B
The And operator is ____.
&&
In a jQuery statement, a reference to the elements on which the statement operates is contained in ____.
()
Which arithmetic operators have the highest precedence?
* / %
What is the extension of the file that contains the jQuery library?
.js
Which of the following is a falsy value?
0
Referring to the figure above, the minimum width for the element is ____.
40em
Referring to the figure above, which lines of code will create a drop cap?
59-63
Referring to the figure above, the maximum width for the element is ____.
60em
Function statements are contained within the function ____.
Braces
The strict equal operator is ____.
===
The ____ operator executes one of two expressions based on the results of a conditional expression.
?:
Which of the following is NOT an acceptable value for referencing the element(s) on which a jQuery statement operates?
A Javascript Method
By default, most browsers surround the fields in a fieldset with ____, creating a visual cue that the fields share a common subject.
A box
Modify the Orders table to use the InnoDB storage engine.
ALTER TABLE Orders ENGINE=innodb
The ___ keyword is often used with the primary key to generate a unique id for each new row in a table.
AUTO_INCREMENT
A(n) ____ operator is used in PHP to perform mathematical calculations.
Arithmetic
Browsers display a drop-down menu as a small text box with a(n) ____ next to it.
Arrowhead
When you assign a value to a variable, you use an equal sign, which is also called a(n) __________ operator.
Assignment
You can use the compound ____ to combine two strings.
Assignment Operator
A(n) ____ comment hides multiple lines of code.
Block
If you want to execute one set of statements when a condition evaluates to a truthy value and another set of statements when the condition evaluates to a falsy value, you need the ____ statement.
If/else
How does the PHP engine process whitespace?
Ignores it
The figure above shows a project plan that includes a section for the budget. In general, it is recommended that a budget be included ____.
In every website design project
A(n) ____ is an element's numeric position within an array.
Index
A(n) ___________ element with a type value of submit is used to create a submit button.
Input
A(n) ____ is a positive or negative number with no decimal places.
Integer
What action does a jQuery event method perform if it is called with empty parentheses?
It fires the indicated event
(CSS read article p:first-line) Referring to the figure above, what do you know about the first line of each paragraph?
It will be bold
Each repetition of a looping statement is called a(n) ____.
Iteration
What language is the jQuery library written in?
JavaScrip
____ can turn static documents into applications such as games or calculators.
JavaScript
Use a MySQL command to load data in the file newbooks.txt into the books table.
LOAD DATA INFILE "newbooks.txt" INTO TABLE books;
Referring to the figure above, the words "Name" and "Email" were created with the ____ element.
Label
Every jQuery statement begins with which character?
Last()
A descriptive title for a fieldset is known as a(n) __________.
Legend
Referring to the figure above, the word "Schedule" was created with the ____ element.
Legend
A(n) ____ comment occupies only a single line or part of a line.
Line
A single statement that declares a variable and specifies array values as its content is called an array ____.
Literal
A variable's scope can be either global or ____.
Local
A ____ error is a flaw in a program's design that prevents the program from running as you anticipate.
Logic
A program's ____ is the order in which various parts of the program run, or execute.
Logic
An infinite loop is an example of a(n) ____ error.
Logic
The debugging tools built into modern browsers are especially useful in tracking down ____.
Logic Errors
A ____ statement is a a control flow statement that repeatedly executes a statement or a series of statements while the value of a specific condition is truthy or until the value of a specific condition becomes truthy.
Loop
JavaScript is a ____ programming language.
Loosely typed
Figure B(landscape). shows the Web page at its maximum width which was set using the ____ property.
Max-width
The procedures associated with an object are called ____.
Methods
Figure A. shows the Web page at its minimum width which was set using the ____ property.
Min-width
The ____ operator uses the % symbol to find the remainder of integer division.
Modulus
Referring to the figure above, Courier New and Lucida Console are ____ fonts because each character uses the same amount of horizontal space.
Monspace
The mysql_info() function only returns query information when you add ___ records with the INSERT keyword.
More than one
Project Plan for Lakeland Reeds Bed and Breakfast, The Figure above shows a timeline that includes milestones, the date the project will be completed, and who is responsible for each task. Normally, you do NOT need to include ____ in the timeline.
None of the above, all of these items should be included
In PHP, which bitwise operation is signified by the pipe (|) character?
OR
Variables and literals contained in an expression are known as ____.
Operands
Symbols such as + and * used in expressions to manipulate operands are known as ____.
Operators
Some of the more popular server-side scripting languages include ____.
PHP, ASP.NET, and Python
A(n) ____ is a variable that is used within a function.
Parameter
In the client/server system, one of the primary roles of the client, or front end, is to ____.
Present an interface to the users
Data types that can be assigned only a single value are called ____ types.
Primitive
An object is ____ that can be treated as an individual unit or component.
Programming code and data
The ___ keyword is used with the ALTER TABLE statement to rename a table.
RENAME
An option button is also known as a(n) ____ button and is best suited for prompting users to select only one item from a group.
Radio
Referring to the figure above, the buttons were created using the ____ value for the type attribute.
Radio
You can use an arithmetic operator to return the modulus of a calculation, which is the ____ when you divide one number by another number.
Remainder left
Special words that are part of the JavaScript language syntax and that can't be used as variable names are known as ____.
Reserved Words
The list of records that is returned from a mysql_query() is a called a ____.
Resultset
A(n) ____ statement is a statement that returns a value to the statement that called the function.
Return
A ____ error occurs when the JavaScript interpreter encounters a problem while a program is executing.
Run-time
A _____ occurs after a script has been successfully loaded with no syntax errors and is being executed by a browser.
Run-time error
Objectives
The owner of your company said he primarily wants to know one thing: "Why do you want a website?" Referring to the figure above, the answer to this question is in the ____ section of the project plan.
A _________ is a JavaScript command that is run after a specified amount of time has passed.
Time-delayed command
(CSS uses . for title) Referring to the figure above, which style rule uses a class selector?
Title
A breakpoint is a designation added to a specific statement in a program that causes program execution to pause when it reaches that statement.
True
A budget should be included as part of a website's project plan.
True
A comparison operator is used to compare two operands and determine if one numeric value is greater than another.
True
A list of records that are returned from a query is called a resultset.
True
A node attached with the appendChild() method is always added as the last child element of the parent element.
True
Although JavaScript is considered a programming language, it is also a critical part of web page design and authoring.
True
Any information that can be organized into ordered collection of data can be considered a database.
True
Apache, PHP, and MySQL are all examples of open-source software.
True
Both private and free, publicly available JavaScript libraries are in common use on the web today.
True
Each row in a database is called a record.
True
Each time a program calls a procedure, the procedure is added to the top of the call stack, and then removed after it finishes executing.
True
Elements that do not require a closing tag are called empty elements.
True
For each error encountered, a browser's console displays a line number and a description of the error.
True
How you enable MySQL support in PHP depends on the version of PHP and how you installed MySQL
True
The ____ method adds specified class name(s) to the selection.
addClass()
Which jQuery method do you use to add a class name to one ore more selected elements?
addClass()
(1)<!DOCTTYPE HTML>(4)<html>(2)*whitespace*</html>(3), In the figure above item 3 shows a(n)___ tag.
closing
Which of the following is a PHP function used to declare constants?
define
jQuery includes a(n) ____ method that allows jQuery code to coexist with code for another library that uses the same alias.
noConflict()
(picture has layout with spaced boxes)Referring to the figure above, to achieve the page flow shown on the left, the element uses the default arrangement known as___.
normal flow
(1)<!DOCTTYPE HTML>(4)<html>(2)*whitespace*</html>(3), In the figure above item 4 shows a(n)___ tag.
opening
Identifying the type of website is an important part of a project plan; and the figure above lists this site type as "Billboard." Usually websites have one of a small number of main functions that do NOT include: ____.
site that converts HTML into XML
A three-tier, or multitier, client/server system consists of three distinct pieces: These are ____.
the client tier, the processing tier, and the data storage tier
Which of the following is a logical operator?
||
