Server-Side

Which of the following built-in arrays do you use in PHP to get the data that is submitted with an HTTP GET request?

$_GET

Which of the following assigns a string literal to a variable?

$name = 'Tom' , $name = "Tom"

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);

(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);

Which character is used to separate parameters that are appended to a URL?

&

What extension of a filename is typically associated with a static Web page?

.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

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);}

1100

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;

2

Code example 3-1SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotalFROM vendors INNER JOIN invoicesON vendors.vendorID = invoices.vendorIDWHERE invoiceTotal >= 500ORDER BY vendorName DESC (Refer to code example 3-1.) How many columns will the result set have?

4

How many data types are used by PHP

6

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

6

A PHP tag that's embedded within HTML starts with

<?php

Which of the following is a web server that is commonly used for web applications that are written in PHP?

Apache

Which of the following is software that is a web server?

Apache

Which of the following techniques can you use to code a comment at the end of a line of code?

Code two slashes (//) followed by the comment

Which of the following is NOT a common MySQL data type?

DBL

The ________________ for a MySQL connection specifies the host computer for the MySQL database and the name of the database.

DSN(Data Source Name)

Which of the following can a SELECT statement NOT do to the data in a table?

Delete the rows

Which clause in a SQL statement specifies the table(s) that should supply the data that is returned?

FROM

What type of a request does a web browser typically send to a server?

HTTP

Which of the following is NOT a common MySQL privilege?

INSERT TABLE

Which of the following is NOT true about MariaDB?

Like MySQL, it is owned by Oracle.

What does the acronym MVC stand for?

Model-View-Controller

Which PHP class can be used to connect to a MySQL database?

PDO

Which of the following is a class used for errors thrown by the PDO library?

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

PDOException object

Which of the following software components generates the HTML that is returned in an HTTP response?

PHP

The ________________ extension to PHP defines an interface for accessing databases.

PHP Data Objects

When the web server receives an HTTP request for a PHP page, the web server calls the

PHP interpreter

Which method of the form passes data without appending the parameters to the URL?

Post

Which of the following is NOT a database server that can be used for dynamic Web pages?

Python

Which of the following is a SQL statement that you can use to retrieve data from a SQL database?

SELECT

When you create a PDO object, you have to pass all but one of these arguments to it: Which one is it?

Server name

URL stands for

Uniform Resource Locator

Code example 3-1SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotalFROM vendors INNER JOIN invoicesON vendors.vendorID = invoices.vendorIDWHERE invoiceTotal >= 500ORDER BY vendorName DESC When you code a DELETE statement, you usually need to include

a WHERE clause

A request and response for a file are made by

a client and a server

A web application starts when

a client sends an HTTP request to a server

If a URL specifies a directory that doesn't contain a default page, Apache displays

a list of all of the directories in that directory

When you use the header() function to redirect a request,

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

Google Chrome is

a web browser

What software does a client use to access the web server where a web application resides?

a web browser

Which of the following is used to make websites available to other computers over a network?

a web server

An advantage of using MySQL is:

all of these

Which of the following can be displayed if you omit the filename of a URL?

all of these

(Refer to code example 5-1) What does this function return when it is called?

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 inner join

________________ are used in PHP to perform mathematical calculations, such as addition.

arithmetic operators

The intersection of a column and row in a database table can be called a

cell

A web application is a type of

client/server application

Which of the following techniques can you use to code a multi-line comment?

code /* followed by the comment and */

A ________________ contains a value that does not change during the course of program execution.

constant

When coding relative URLs, you can begin the URL with a single dot (.) to indicate that the URL should start with the ________________ directory.

current

What part of a URL identifies the web server that an HTTP request will be sent to?

domain name

What type of web pages are generated by PHP scripts that are running on the web server?

dynamic

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

equal

A/An ________________ is an object that contains information about an error.

exception

Which of the following is an object that contains information about an error that occurred?

exception

To return an array for the first row of a result set that's returned by a SELECT statement, you use the ________________ method of the PDOStatement object for the result set.

fetch()

Which of the following is a method of the PDOStatement class that returns an array for the next row in a result set?

fetch()

To get an array for all rows in a result set, you can call the ________________ method of the PDOStatement object for the result set.

fetchAll()

Which of the following is a PHP function that you should always use when getting values from a superglobal array?

filter_input()

Which of the following can be used to get the data from an array that contains all rows of a result set?

foreach statement

What does a relational database use to relate the tables in a database to other tables?

foreign keys

The HTTP response for a dynamic web page is passed

from the web server to the browser

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

global

Code example 3-1SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotalFROM vendors INNER JOIN invoicesON vendors.vendorID = invoices.vendorIDWHERE invoiceTotal >= 500ORDER BY vendorName DESC When you code an INSERT statement, you don't have to include the data for a column that

has a default value

An inner join combines data from two or more tables

if the primary key and foreign key are equal

The order of precedence for arithmetic expressions causes

increment operations to be done first

To access one of the elements in an array, you code the array name and a set of brackets that contains the ________________ of the element you want to access.

index

To refer to the elements in an array, you use a string or numeric ________________.

index

Which of the following is a SQL statement that you can use to add a row to a database?

insert

One reason for using the header() function to redirect a request

is to have a PHP file run itself again

When you use the MVC pattern, you

make each layer as independent as possible

Which attribute of a form element determines how the data is passed to a file?

method

What keyword must you code to create a PDO object?

new

Which keyword is used to create an object from a class in PHP?

new

Which of the following is NOT part of an HTTP URL:

node

In an if statement, the statements in the else clause are executed if

none of the conditions in the if or elseif clauses are true

If a row in one table is related to just one row in another table, the tables are said to have a

one-to-one relationship

What is the concatenation operator in PHP?

period

Each row in a table should be able to be uniquely identified by a:

primary key

What does a relational database use to uniquely identify each row in a table?

primary keys

To control what users can do with a database, SQL can be used to assign ________________ to users.

privileges

The first part of a URL is called the

protocol

Which of the following is a term that refers to modifying the organization or structure of an application?

refactoring

To view the source code for a web page in a web browser, you can display the View Page Source command by

right-clicking on the page

You can use phpMyAdmin to import and run a SQL ________________ that creates one or more databases.

script file

Which clause in a SQL statement specifies the columns to return?

select

Which of the following is NOT a benefit of using the MVC pattern for an application?

the application runs more efficiently

What attribute of a column determines the data that can be stored in the column?

the data type

To deploy a PHP application on your own computer, you copy the application root directory to

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 and the view

To handle exceptions, first you code a/an ________________ around any PHP statements that might throw an exception.

try block

To handle the PDO exceptions that can occur when database methods are executed, you use a ________________ statement.

try/catch

The result set retrieved by the following SELECT statement contains rows that haveSELECT balance, numberFROM accountsWHERE balance < 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

uses localhost as the domain name

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

vendors and invoices

The column definition for a MySQL table can be used to determine all but one of the following. Which one is it?

what range of values the column can contain

Which clause in a SQL statement specifies the records to return based on criteria?

where