Test 1 for php
Which of the following is not a compound assignment operator in PHP?
!=
Which of the following can be used to style a label in an id named data?
#data label
In PHP, all variables begin with a:
$
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);
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);
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
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
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
SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotal FROM vendors INNER JOIN invoices ON vendors.vendorID = invoices.vendorID WHERE invoiceTotal >= 500 ORDER BY vendorName DESC How many columns will the result set have?
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; }
40
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
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
Which of the following is considered the assignment operator in PHP?
=
Which character is used to separate parameters that are appended to a URL?
?
Which of the following is software that is a Web server?
Apache
________________ are used in PHP to perform mathematical calculations, such as addition.
Bitwise operators
A ________________ value is a value of true and false.
Boolean
Which of the following software components generates the HTML that is returned in an HTTP response?
Chrome
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
<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>
Doesn't do anything because $error_message will be empty
Which clause in a SQL statement specifies the table(s) that should supply the data that is returned?
FROM
Which method of the form appends values to the URL to pass data?
GET
What type of SQL statement is used to assign user privileges in MySQL?
GRANT
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 clause in a SQL statement is typically used to return data from more than one table?
JOIN
____________ operators are used for combining conditional expressions
Logical
Which clause in a SQL statement specifies how the result set should be sorted?
ORDER BY
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 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 clause in a SQL statement specifies the columns to return?
SELECT
Which type of SQL statement returns a result set?
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
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? <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>
Text boxes that contain the data the user entered the first time the page was displayed
URL stands for
Uniform Resource Locator
Which clause in a SQL statement specifies the records to return based on criteria?
WHERE
Assigning ________________ to a variable indicates the variable does not contain a usable value.
ZERO
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 WHERE clause
A request and response for a file are made by
a client and a server
A join that returns records from related tables only if their related fields match is called
a inner join
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
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 where balance is less than 0
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
SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotal FROM vendors INNER JOIN invoices ON vendors.vendorID = invoices.vendorID WHERE invoiceTotal >= 500 ORDER BY vendorName DESC If vendorName contains string data and invoiceTotal contains decimal values, how will the result set be ordered?
alphabetically starting with Z
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 the columns in the row with the specified product ID
In HTML, parameters are called
attributes
To make it easier to enter names into your code, NetBeans provides a feature known as
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.
bindValue()
An index for a PHP array:
can be a number or a string
A web application is a type of
client/server application
A ________________ contains a value that does not change during the course of program execution.
constant
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
To print a variable with the echo statement, you simply pass the variable name to the echo statement. For example
echo $VotingAge;
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.
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
Which of the following is a method of the PDOStatement class that returns an array for the next row in a result set?
fetch()
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
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
has a default valueS
Which URL can be used to start phpMyAdmin on a local system?
http://localhost/phpmyadmin
The order of precedence for arithmetic expressions causes
increment operations to be done first
A(n) ________________ is a positive or negative number with no decimal places.
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
A PHP variable name
is case-sensitive
Which of the following is NOT true about MariaDB?
it is being maintained by many of the original developers of MySQL.
Which HTML tag or element is used to load an external stylesheet?
link
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
The ________________ operator divides one operand by another operand and returns the remainder.
modulus
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
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
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
The first part of a URL is called the
protocol
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?
require_once
To view the source code for a web page in a web browser, you can display the View Source command by
right-clicking on the page
A table in a relational database consists of columns and ________________.
rows
When HTML was first developed, Web pages were typically
static
Which of the following is NOT a benefit of using the MVC pattern for an application?
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
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 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
SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotal FROM vendors INNER JOIN invoices ON vendors.vendorID = invoices.vendorID WHERE invoiceTotal >= 500 ORDER BY vendorName DESC What table(s) does the data in the result set come from?
vendors
When the web server receives an HTTP request for a PHP page, the web server calls the
web browser
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
