Test 1 Study Guide

Which PHP class can be used to connect to a MySQL database? > db > PDO > DataConnect > argument

PDO

Which of the following is a class used for errors thrown by the PDO library? > PDOException > PDOCatch > PDOHandler > CatchException

PDOException

In the catch block of a try/catch statement for handling PDO exceptions, you can get a message that describes the exception by using the getMessage() method of the: > PDO object > PDOStatement object > PDOException object > Result set array

PDOException object

Which of the following software components generates the HTML that is returned in an HTTP response? > Apache > MySQL > Chrome > PHP

PHP

When the web server receives an HTTP request for a PHP page, the web server calls the: > database server > static web page > web browser > PHP interpreter

PHP interpreter

Which method of the form passes data without appending the parameters to the URL? > GET > POST > ACTION > APPEND

POST

Which of the following is not a database server that can be used for dynamic Web pages? > MySQL > SQL Server > Oracle > Python

Python

Which clause in a SQL statement specifies the records to return based on criteria? > SELECT > FROM > WHERE > ORDER BY

WHERE

What is the goal of testing an application before it is put into production? > fix all errors > find all errors > create errors > fix the most critical errors

find all errors

Which HTML tag or element is used to load an external stylesheet? > script > link > style > type

link

Which attribute of a form element determines how the data is passed to a file? > action > method > submit > default

method

Which of the following consists of the PHP files that represent the data of the applications? > controller > model > inheriter > requester

model

When you ________________ a request, all processing takes place on the server. > forward > initiate > cancel > demand

forward

The HTTP response for a dynamic web page is passed: > from PHP to the browser > from the web server to the browser > from the database server to the web server > from the web server to PHP

from the web server to the browser

Which function can be used to redirect a request to another URL? > include( ) > require( ) > header( ) > response( )

header( )

Which of these would NOT be considered a common syntax error in PHP? > misspelling keywords > forgetting to end a statement with a semicolon > forgetting a closing quotation mark > multiplying by the wrong variable

multiplying by the wrong variable

Each row in a table should be able to be uniquely identified by a: > primary key > field name > cell > record

primary key

Which of the following is not a compound assignment operator in PHP? > += > -= > %= > !=

!=

In PHP, all variables begin with a: > $ > & > lowercase letter > uppercase letter

$

To round and format the value of a variable named $number to 3 decimal places and store it in a variable named $number_formatted, you code: > $number_formatted = number_format($number, 3, round); > $number_formatted = number_format($number, 3); > $number_formatted = format_number($number, 3, round); > $number_formatted = format_number($number, 3);

$number_formatted = number_format($number, 3);

Code example 5-1 function get_product($product_id) { global $db; $query = 'SELECT * FROM products WHERE productID = :product_id'; $statement = $db->prepare($query); $statement->bindValue(':product_id', $product_id); $statement->execute(); $product = $statement->fetch(); $statement->closeCursor(); return $product; } (Refer to code example 5-1) Which of the following is a proper PHP statement for calling the function in this example. > $product = get_product($product_id); > $product = get_product(product_id); > $product = $get_product($product_id); > $product = $get_product(product_id);

$product = get_product($product_id);

Which character is used to separate the original URL from the parameters that are appended to it? > ? > & > $ > =

?

Code example 3-1 SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotal FROM vendors INNER JOIN invoices ON vendors.vendorID = invoices.vendorID WHERE invoiceTotal >= 500 ORDER BY vendorName DESC When you code a DELETE statement, you usually need to include: > a SORT BY clause > a WHERE clause > an inner join > an outer join

a WHERE clause

A request and response for a file are made by: > a browser and an application > a client and an agent > the Web page > a client and a server

a client and a server

An advantage of using MySQL is: > cost > speed > ease of use > all of these

all of these

Which of the following can be displayed if you omit the filename of a URL? > index.htm > index.html > index.php > all of these

all of these

Which of the following can be used in a conditional expression? > equality operators > relational operators > logical operators > all of these

all of these

Which of the following is a relational operator in PHP? > < > <= > > > all of these

all of these

An index for a PHP array: > must be a string > must be a number > can be a number or a string > does not exist

can be a number or a string

Which type of input element should be used on a form when the user can select zero, one, or many of the options in a group? > checkbox > radio > text > submit

checkbox

To print a variable with the echo statement, you simply pass the variable name to the echo statement. For example: > echo "$VotingAge;" > echo $VotingAge; > echo &VotingAge; > echo(VotingAge;)

echo $VotingAge;

What does $salutation contain after the following code executes? $company_name = ''; $salutation = $company_name ?? 'To whom it may concern'; > empty string ('') > null > To whom it may concern

empty string ('')

Which type of loop will always execute its code at least once? > while > do-while > for > for-in

do-while

A hidden field: > appears on the form but its data is hidden > has data that is obscured by bullets or asterisks > doesn't appear on the form but its data is sent to the server > appears on the form with its data grayed out

doesn't appear on the form but its data is sent to the server

The equality operator consists of two ________________ signs and performs a different function than the one performed by the assignment operator that consists of a single sign. > percent > greater than > equal > division

equal

A/An ________________ is an object that contains information about an error. > exception > PDO class > MySQL database > username

exception

Which of the following is software that is a Web server? > Apache > MySQL > phpMyAdmin > htdocs

Apache

________________ are used in PHP to perform mathematical calculations, such as addition. > Arithmetic operators > Binary operators > Unary operators > Bitwise operators

Arithmetic operators

Which of the following is an object that contains information about an error that occurred? > catch > exception > handler > block

exception

A switch statement in PHP starts by evaluating a switch ________________. > case > expression > return statement > break

expression

Which of the following is a method of the PDOStatement class that returns an array for the next row in a result set? > fetch() > sit() > getArray() > getRow()

fetch()

The goal of testing is to: > fix all errors in the application > find all errors in the application > make sure the application works with valid data > make sure the application works with invalid data

find all errors in the application

What is the goal of debugging an application before it is put into production? > fix all errors > find all errors > minimizing errors > create job security

fix all errors

Which of the following can be used to get the data from an array that contains all rows of a result set? > roll over > fetch() method > foreach statement > forall loop

foreach statement

What does a relational database use to relate the tables in a database to other tables? > indexes > foreign keys > non-primary keys > primary keys

foreign keys

A ________________ value is a value of true and false. > Switch > Null > Constant > Boolean

Boolean

To make a variable that is declared outside of a function usable inside the PHP function, which keyword can be used? > local > module > public > global

global

Which of the following can a SELECT statement NOT do to the data in a table? > Get selected rows > Get selected columns > Sort the rows > Delete the rows

Delete the rows

When creating a function, ________________ can be included in the parentheses that follow the name. > parameters > properties > controllers > formatters

parameters

What is the concatenation operator in PHP? > ampersand (&) > plus sign (+) > period (.) > pound sig (#)

period (.)

What does a relational database use to uniquely identify each row in a table? > indexes > foreign keys > non-primary keys > primary keys

primary keys

The first part of a URL is called the: > domain identifier > directory > protocol > filename

protocol

Which type of input element should be used on a form when the user can select only one of the options? > checkbox > radio > text > submit

radio

How many data types are used by PHP? > six > nine > eleven > twelve

six

Which of the following lists the functions in the reverse order in which they were called? > stack trace > breakpoint > called collection > IntelliSense

stack trace

When HTML was first developed, Web pages were typically: > cryptic > invisible > dynamic > static

static

Code example 2-1 <h1>Future Value Calculator</h1> <?php if (!empty($error_message)) { ?> <p class="error"><?php echo $error_message; ?></p> <?php } ?> <form action="display_results.php" method="post"> <div id="data"> <label>Investment Amount:</label> <input type="text" name="investment" value="<?php echo $investment; ?>"/><br /> <label>Yearly Interest Rate:</label> <input type="text" name="interest_rate" value="<?php echo $interest_rate; ?>"/><br /> <label>Number of Years:</label> <input type="text" name="years" value="<?php echo $years; ?>"/><br /> </div> (Refer to code example 2-1) If this code is from the first page of this application, what does the if statement in the PHP tag do the first time this page is executed? > Displays an error message in a <p> tag > Displays an empty error message in a <p> tag > Displays an empty <p> tag > Doesn't do anything because $error_message will be empty

Doesn't do anything because $error_message will be empty

________________ operators are used for combining conditional expressions. > Equal > Binary > Logical > Or

Equal

Which clause in a SQL statement specifies the table(s) that should supply the data that is returned? > SELECT > FROM > WHERE > ORDER BY

FROM

Which of the following is NOT a common MySQL privilege? > INSERT TABLE > SELECT > UPDATE > DELETE

INSERT TABLE

Which character is used to separate parameters that are appended to a URL? > $ > & > ? > =

&

Which of the following can be used to style a label in an id named data? > data_label > .data label > label.data > #data label

.data label

What extension of a filename is typically associated with a static Web page? > .htm > .asp > .php > .pl

.htm

How many times will the while loop that follows be executed? $months = 5; $i = 1; while ($i > $months) { $futureValue = $futureValue * (1 + $monthlyInterestRate); $i = $i+1; } > 0 > 1 > 4 > 5

0

If $total_months has a value of 13, what does $message contain after this if statement is executed? $years = $total_months / 12; $years = number_format($years); $months = $total_months % 12; if ( $years == 0 ) { $message = $months . " months"; } else if ( $months == 0 ) { $message = $years . " years"; } else { $message = $years . " years, and " . $months . " months"; } > 1 years, and 1 months > 1 year, and 1 month > 1 years > 1 year

1 years, and 1 months

What will $future_value contain after the for loop that follows has been executed one time? $years = 10; $annual_rate = 10; $future_value = 1000; $annual_rate = $annual_rate / 100; for ( $i = 1; $i <= $years; $i++ ) { $future_value = $future_value * (1 + $annual_rate); } > 1000 > 1100 > 11000 > 1010

1100

What does $shipping_cost contain after the following code executes? $quantity = 3; $shipping_cost = ($quantity > 1) ? 5 + ($quantity * 2.5) : 5; > 5 > 7.5 > 10 > 12.5

12.5

After the code that follows is executed, what will the value of $units_per_store be? $units = 30; $stores = 4; $units_per_store = $units % $stores; > 7 > 7.5 > 2 > 0

2

How many radio buttons from the following code can be selected at any given time? <input type="radio" name="address" value="Home">Home Address <input type="radio" name="delivery" value="FedEx">Federal Express <input type="radio" name="delivery" value="UPS">UPS > 0 > 1 > 2 > 3

2

Which of the following operators does NOT perform type coercion? > == > === > >= > !=

===

How many operands does a ternary operator have? > 1 > 4 > 3 > 2

3

Code example 3-1 SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotal FROM vendors INNER JOIN invoices ON vendors.vendorID = invoices.vendorID WHERE invoiceTotal >= 500 ORDER BY vendorName DESC (Refer to code example 3-1.) How many columns will the result set have? > 4 > 5 > 6 > 7

4

After the if statement that follows is executed, what will the value of $discount_amount be? $discount_amount; $order_total = 200; if ($order_total > 200) { $discount_amount = $order_total * .3; } else if ($order_total > 100) { $discount_amount = $order_total * .2; } else { $discount_amount = $order_total * .1; } > 0 > 20 > 40 > 60

40

If a PHP array contains 7 elements, what is the number of the index of the seventh element? > 6 > 7 > 0 > 8

6

After the code that follows is executed, what will the value of $units_per_store be? $units = 30; $stores = 4; $units_per_store = intdiv($units, $stores); > 7 > 7.5 > 2 > 0

7

Which of the following is considered the assignment operator in PHP? > $ > & > = > #

=

Which of the following is NOT a common MySQL data type? > CHAR > VARCHAR > INT > DBL

DBL

The ________________ for a MySQL connection specifies the host computer for the MySQL database and the name of the database. > username > password > DSN (Data Source Name) > server name

DSN (Data Source Name)

Assume that the second radio button in the code below has been selected by the user. When you get the value of that radio button, what will the value be? <input type="radio" name="delivery" value="USPS">USPS <input type="radio" name="delivery" value="FedEx">Federal Express <input type="radio" name="delivery" value="UPS">UPS > FedEx > Federal Express > fedex > federal express

FedEx

What does $message contain after the following code executes? $statusCode = "403"; switch ( $statusCode ) { case "200": $message = "OK"; break; case "403": $message = "Forbidden"; break; case "404": $message = "Not Found"; break; default: $message = "Unknown Status"; break; } > OK > Forbidden > Not Found > Unknown Status

Forbidden

Which method of the form appends values to the URL to pass data? > GET > POST > ACTION > APPEND

GET

What type of SQL statement is used to assign user privileges in MySQL? > GIVE > ASSIGN > GRANT > REVOKE

GRANT

What type of a request does a Web browser typically send to a server? > IPsec > TCP/IP > HTTP > FTP

HTTP

Which clause in a SQL statement is typically used to return data from more than one table? > SELECT > FROM > WHERE > JOIN

JOIN

What does $message contain after the following code executes? $message = "L: "; for ($i = 0; $i < 10; $i++ ) { $message .= $i . ", "; if ($i == 7) break; } > L: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, > L: 0, 1, 2, 3, 4, 5, 6, 7, > L: 1, 3, 5, 7, 9, > L: 1, 3, 5, 7

L: 0, 1, 2, 3, 4, 5, 6, 7,

Which of the following is NOT true about MariaDB? > It is being maintained by many of the original developers of MySQL. > One goal is to maintain high compatibility with MySQL. > Newer versions of XAMPP use MariaDB rather than MySQL. > Like MySQL, it is owned by Oracle.

Like MySQL, it is owned by Oracle.

What does the acronym MVC stand for? > Module-View-Controller > Most-Valuable-Computer programmer > Mixed-Vector-CPU > Must-Verify-Constraints

Module-View-Controller

Assigning ________________ to a variable indicates the variable does not contain a usable value. > ZERO > NONE > BLANK > NULL

NULL

Which clause in a SQL statement specifies how the result set should be sorted? > SELECT > FROM > WHERE > ORDER BY

ORDER BY

What does $message contain after the following code executes? $rate = 0.1; if ( ! is_numeric($rate) ) { $message = 'Rate is not a number.'; } else if ($rate < 0) { $message = 'Rate cannot be less than zero.'; } else if ($rate > 0.2) { $message = 'Rate cannot be greater than 20%.'; } else { $message = 'Rate is valid.'; } > Rate is not a number. > Rate cannot be less than zero. > Rate cannot be greater than 20%. > Rate is valid.

Rate is valid.

Which clause in a SQL statement specifies the columns to return? > SELECT > FROM > WHERE > ORDER BY

SELECT

Which type of SQL statement returns a result set? > UPDATE > CREATE > SELECT > INSERT

SELECT

When you create a PDO object, you have to pass all but one of these arguments to it: Which one is it? > Data source name > Server name > User name > Password

Server name

Code example 2-1 <h1>Future Value Calculator</h1> <?php if (!empty($error_message)) { ?> <p class="error"><?php echo $error_message; ?></p> <?php } ?> <form action="display_results.php" method="post"> <div id="data"> <label>Investment Amount:</label> <input type="text" name="investment" value="<?php echo $investment; ?>"/><br /> <label>Yearly Interest Rate:</label> <input type="text" name="interest_rate" value="<?php echo $interest_rate; ?>"/><br /> <label>Number of Years:</label> <input type="text" name="years" value="<?php echo $years; ?>"/><br /> </div> (Refer to code example 2-1) If this code is from the first page of this application, what do the three <input> tags display the second time this page is executed? > Text boxes that contain zero values > Text boxes that contain empty strings > Text boxes that contain the data the user entered the first time the page was displayed > The text boxes aren't displayed because the condition in the if statement is false

Text boxes that contain the data the user entered the first time the page was displayed

What does $message contain after the following code executes? $age = 19; $score = 750; if ( $age >= 21 && $score >= 700 ) { $message = 'Loan approved'; } else if ( $age >= 21 && $score >= 650 ) { $message = 'Cosigner needed.'; } else if ( $age >= 18 && $score >= 680 ) { $message = 'Two cosigners needed.'; } else { $message = 'Loan denied.'; } > Loan approved. > Cosigner needed. > Two cosigners needed. > Load denied.

Two cosigners needed.

URL stands for: > Universal Refresh Location > Uniform Resource Locator > Unique Register Location > Undeclared Resource Location

Uniform Resource Locator

Assume that the statements that follow get the data from a text area named comments. After these statements are executed, how will the $comments_esc variable be displayed by an echo statement? $comments = filter_input(INPUT_POST, 'comments'); $comments_esc = htmlspecialchars($comments); > With character entities for both special characters and new line characters > With <br> tags for new line characters > With character entities for special characters > With both character entities and <br> tags

With character entities for special characters

If a URL specifies a directory that doesn't contain a default page, Apache displays: > an error message > a list of the PHP applications in that directory > a list of all of the web applications in that directory > a list of all of the directories in that directory

a list of all of the directories in that directory

When you use the header() function to redirect a request: > a response is sent to the web server so it requests another page > the web server returns a new page to the browser > a response is returned to the browser that tells it to request another page > the web server returns a new page to the controller of the MVC pattern

a response is returned to the browser that tells it to request another page

Code example 3-1 SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotal FROM vendors INNER JOIN invoices ON vendors.vendorID = invoices.vendorID WHERE invoiceTotal >= 500 ORDER BY vendorName DESC (Refer to code example 3-1.) If vendorName contains string data and invoiceTotal contains decimal values, how will the result set be ordered? > alphabetically starting with A > alphabetically starting with Z > numerically starting with 0 > numerically starting with 500

alphabetically starting with Z

Code example 5-1 function get_product($product_id) { global $db; $query = 'SELECT * FROM products WHERE productID = :product_id'; $statement = $db->prepare($query); $statement->bindValue(':product_id', $product_id); $statement->execute(); $product = $statement->fetch(); $statement->closeCursor(); return $product; } (Refer to code example 5-1) What does this function return when it is called? > an array of all the rows in the products table > an array of all the rows with the specified category ID > an array of the columns in the first row of the products table > an array of the columns in the row with the specified product ID

an array of the columns in the row with the specified product ID

A join that returns records from related tables only if their related fields match is called: > an outer join > an inner join > a cross join > a data join

an inner join

In HTML, parameters are called: > attributes > properties > switches > options

attributes

To make it easier to enter names into your code, NetBeans provides a feature known as: > error checking > auto-completion > syntax coloring > warning icons

auto-completion

To execute a prepared SQL statement, you can use the ________________ and execute() methods of the PDOStatement object to set parameter values and execute the statement. > fetch() > bindValue() > exec() > elements()

bindValue()

A/an ________________ statement can be used to jump out of a loop.

break

Which type of statement ends or jumps out of a loop? > break > continue > for > next

break

When debugging an application, you can set a(n) ________________ to view the value of a variable at a particular point. > debug > rebug > breakpoint > exception

breakpoint

A web application is a type of: > client/server application > database application > client-side application > server-side application

client/server application

A ________________ contains a value that does not change during the course of program execution. > variable > constant > function > integer

constant

Which of the following statements will restart the execution of a loop? > halt > continue > stop > break

continue

Which type of statement ends the current iteration of a loop? > break > continue > switch > conditional

continue

In the code that follows, if $error_message isn't empty if ($error_message != '') { include('index.php'); exit(); } > control is passed to a page named index.php that's in the current directory > control is passed to a page named index.php that's in the parent directory > control is passed to a page named index.php that's in the child directory > nothing happens because the condition is false

control is passed to a page named index.php that's in the current directory

A switch statement in PHP is often useful in the ________________ of an application that uses the MVC pattern. > model > view > controller > header

controller

Which of the following receives requests from users, gets the appropriate data, and returns the appropriate views to the users? > controller > view finder > model > verifier

controller

When you use the htmlspecialchars() and nl2br() functions to process a user's entry and then pass that entry to a web page, the browser will > process any HTML tags that the user entered instead of displaying them > display any HTML tags entered by the user instead of processing them > execute any JavaScript code entered by the user > ignore any line breaks entered by the user

display any HTML tags entered by the user instead of processing them

Code example 3-1 SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotal FROM vendors INNER JOIN invoices ON vendors.vendorID = invoices.vendorID WHERE invoiceTotal >= 500 ORDER BY vendorName DESC When you code an INSERT statement, you don't have to include the data for a column that: > is a foreign key > is a primary key > has a default value > does not allow null values

has a default value

Which PHP function converts some special characters into character entities? > htmlspecialchars() > convertchars() > substr() > double_encode()

htmlspecialchars()

Which URL can be used to start phpMyAdmin on a local system? > http://localhost/phpmyadmin > http://phpmyadmin > http://phpmyadmin.localhost > phpmyadmin://localhost

http://localhost/phpmyadmin

Which function can be used to forward a request from one PHP file to another? > include( ) > location( ) > return( ) > response( )

include( )

The order of precedence for arithmetic expressions causes: > addition to be done before subtraction > multiplication to be done before division > increment operations to be done first > modulus operations to be done last

increment operations to be done first

Which HTML element is used to create items in a drop-down list? > list > item > option > value

option

A(n) ________________ is a positive or negative number with no decimal places. > variable > exponential notation > floating-point number > integer

integer

When double quotes are used to assign values to string variables, the PHP interpreter must check the entire string to see if it contains any variables that need to be inserted into the string. This process is called: > interpolation > concatenation > encapsulation > initialization

interpolation

a PHP variable name: > is case-sensitive > can contain special characters > can start with a letter, a digit, or two underscores > can be a PHP reserved word

is case-sensitive

One reason for using the header() function to redirect a request: > is that it's more efficient than forwarding a request > is to have a PHP file run itself again > is to reduce the number of round trips that are required > is to do all processing for the request on the server

is to have a PHP file run itself again

Which PHP function can be used to determine if a checkbox is checked? > is_checked() > boolean() > isset() > value()

is_checked()

While loops and for loops are often referred to as ________________ structures. > selection > sequence > iteration > ill-advised

iteration

Which type of error is often most difficult to find and fix? > syntax > runtime > logic > complex

logic

An error that lets the application run but produces the wrong results is known as a: > runtime error > user error > logic error > syntax error

logic error

When you use the MVC pattern, you: > make each layer as independent as possible > perform all data validation on the client > use the pattern for every page in the application > put all of the PHP code in the controller

make each layer as independent as possible

The ________________ operator divides one operand by another operand and returns the remainder. > addition > subtraction > division > modulus

modulus

Which optional attribute of a select element allows the user to select more than one option in a list box? > size > multiple > morethanone > plural

multiple

In order to group multiple radio buttons so that only one of the radio buttons can be selected at a time, which attribute of the input element must have the same value for all radio buttons in the group? > checked > value > name > id

name

Which keyword is used to create an object from a class in PHP? > new > create > instantiate > argument

new

Which of the following is NOT part of an HTTP URL: > protocol > path > node > filename

node

If a row in one table is related to just one row in another table, the tables are said to have a: > one-to-many relationship > one-to-one relationship > many-to-many relationship

one-to-one relationship

When you ________________ a request, the server returns a response that tells the browser to request another URL. > forward > initiate > cancel > redirect

redirect

Which of the following is a term that refers to modifying the organization or structure of an application? > interpolation > refactoring > instantiation > inheritance

refactoring

If many different files may load an external file, what statement can be used instead of 'include' to make sure the external file is only loaded once? > one_time > require_once > include_first > load_once

require_once

Which type of statement should be included if the function should send a value back to where the function was called? > return > send > parameter > argument

return

To view the source code for a web page in a web browser, you can display the View Source command by: > restarting the browser > clicking on the File menu > right-clicking on the page > none of the above

right-clicking on the page

A table in a relational database consists of columns and ________________.

rows

When you click on the Continue button while you're debugging with NetBeans, the application: > runs to the next breakpoint > executes the next statement in sequence > lets you step through the statements > removes the breakpoint

runs to the next breakpoint

Which type of error does not violate the rules for how PHP statements must be written but will cause the PHP interpreter to display errors? > syntax > runtime > logic > complex

runtime

The type of error that does not violate syntax rules, but causes the PHP interpreter to display errors is called a: > runtime error > user error > logic error > syntax error

runtime error

Which HTML element is used to create a drop-down list? > select > list > drop-down > input

select

An if statement can be used to implement a ________________ structure. > selection > sequence > case > logical

selection

Which type of error is considered the easiest to find? > syntax > runtime > logic > invisible

syntax

Which type of error is considered the easiest to fix? > syntax > runtime > logic > complex

syntax

When you test an application with NetBeans and a breakpoint is reached, you can click: > the Step Through button to step through the statements one at a time > the Step Into button to execute the current statement and move to the next statement > the Step Over button to skip execution of the next statement > the Step Out button to continue normal execution of the application

the Step Into button to execute the current statement and move to the next statement

Which of the following is NOT a benefit of using the MVC pattern for an application? > it's easier to make changes to the application > web designers can work independently on the view > there's less repetition of code > it's easier to test and debug the application > the application runs more efficiently

the application runs more efficiently

To deploy a PHP application on your own computer, you copy the application root directory to: > the htdocs directory of the Apache server > the htdocs directory of the MySQL server > the xampp directory of the Apache server > the xampp directory of the MySQL server

the htdocs directory of the Apache server

When you use the MVC pattern, the controller gets the HTTP requests and then directs the use of the files that represent: > the model, the view, and the database > the database and the view > the model, the view, and the user interface > the model and the view

the model and the view

To handle exceptions, first you code a/an ________________ around any PHP statements that might throw an exception. > method > try/catch statement > try block > MySQL statement

try block

The result set retrieved by the following SELECT statement contains rows that have SELECT balance, number FROM accounts WHERE balance < 0 > all of the columns from the accounts table > two of the rows from the account table > all of the columns from the accounts table where balance is less than 0 > two of the columns from the accounts table where balance is less than 0

two of the columns from the accounts table where balance is less than 0

To run a PHP application that has been deployed on your own computer, you can enter a URL in the address bar of your browser that: > specifies just the application root directory > uses localhost as the domain name > specifies just the application root directory and the starting filename > uses apache as the domain name

uses localhost as the domain name

Code example 3-1 SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotal FROM vendors INNER JOIN invoices ON vendors.vendorID = invoices.vendorID WHERE invoiceTotal >= 500 ORDER BY vendorName DESC (Refer to code example 3-1.) What table(s) does the data in the result set come from? > vendors > invoices > vendors and invoices

vendors and invoices

Which of the following consists of the PHP and HTML files that represent the user interface of an application? > logic > model > view > classes

view

The column definition for a MySQL table can be used to determine all but one of the following. Which one is it? > what type of data the column can contain > whether the column can contain a null value > whether the column has a default value > what range of values the column can contain

what range of values the column can contain