CSCI-315-Final-StudyGuide
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 .data label label.data #data label
#data label
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);
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 .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;i f ( $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
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
Code example 3-1 SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotal FROM vendors INNER JOIN invoices ON vendors.vendorID = invoices.vendor ID 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 character is used to separate the original URL from the parameters that are appended to it? ? & $ =
?
A table in a relational database consists of columns and ________________.
Answer: rows
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
A ________________ value is a value of true and false. Switch Null Constant Boolean
Boolean
Chapter 1 Start
Chapter 1 Start
Chapter 2 Start (Missing the 2 example 2-1 trace questions as quizlet won't allow that code.)
Chapter 2 Start (Missing the 2 example 2-1 trace questions as quizlet won't allow that code.)
Chapter 3 Start
Chapter 3 Start
Chapter 4 Start
Chapter 4 Start
Chapter 5 Start
Chapter 5 Start
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)
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
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 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 of the following is NOT a common MySQL privilege? INSERT TABLE SELECT UPDATE DELET
INSERT TABLE
Which clause in a SQL statement is typically used to return data from more than one table? SELECT FROM WHERE JOIN
JOIN
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.
________________ operators are used for combining conditional expressions. Equal Binary Logical Or
Logical
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
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 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
URL stands for Universal Refresh Location Uniform Resource Locator Unique Register Location Undeclared Resource Location
Uniform Resource Locator
Which clause in a SQL statement specifies the records to return based on criteria? SELECT FROM WHERE ORDER BY
WHERE
Code example 3-1 SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotalFROM 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
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
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
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
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()
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
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
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 parent directory
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;
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 an object that contains information about an error that occurred? catch exception handler block
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() sit() getArray() getRow()
fetch()
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
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
Code example 3-1 SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotalFROM 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 URL can be used to start phpMyAdmin on a local system? http://localhost/phpmyadmin http://phpmyadmin http://phpmyadmin.localhost phpmyadmin://localhost
http://localhost/phpmyadmin
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
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
Which HTML tag or element is used to load an external stylesheet? script link style type
link
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
Which attribute of a form element determines how the data is passed to a file? action method submit default
method
The ________________ operator divides one operand by another operand and returns the remainder. addition subtraction division modulus
modulus
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
What is the concatenation operator in PHP? ampersand (&) plus sign (+) period (.) pound sig (#)
period (.)
Each row in a table should be able to be uniquely identified by a: primary key field name cell record
primary key
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 of the following is not a database server that can be used for dynamic Web pages? MySQL SQL Server Oracle Python
python
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
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
How many data types are used by PHP? six nine eleven twelve
six
When HTML was first developed, Web pages were typically cryptic invisible dynamic static
static
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 accountsWHERE 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 invoicesON 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
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
