IT 202 Test 2

Quiz 3: To get the value of a cookie, you can use the global ______________ variable. $_EAT $_SESSION $_COOKIE $_GET

$_COOKIE

Quiz 3: Once a session is started, which superglobal variable can be used to get and set the user's data for a session? $_SESSION $_USER $_COOKIE $_GET

$_SESSION

Quiz 3: To create a persistent cookie, you set the ___________ parameter of the setcookie() function. $name $expire $secure $value

$expire

QUIZ 2: If a PHP array contains 7 elements, what is the number of the index of the seventh element? 0 4 5 6

6

Quiz 3: Which of the following is a parameter of the setcookie() function? All of these $expire $name $value

All of these

Quiz 3: __________________ provides a way for a web application to store information in the user's web browser and retrieve it every time the user requests a page. Status bars Cookies Bookmarks Favorites

Cookies

QUIZ 2: When coding relative URLs, you can begin the URL with a single dot (.) to indicate that the URL should start with the _____________ directory. root current child parent

Current

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

DBL

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

Delete the rows

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

FROM

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

GRANT

Which of the following is an SQL statement that you can use to add a row to a database? ADD UPDATE INSERT MODIFY

INSERT

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

PDO

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

PDOException

Quiz 2: 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 Result set array PDOStatement object PDO object

PDOException object

Quiz 3: What is the default name of a session cookie in PHP? SESSIONID SESSIONCOOKIE session-name PHPSESSID

PHPSESSID

Each row in a table should be able to be uniquely identified by a: Primary Key Field Name Cell Record

Primary Key

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

SELECT

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

SELECT

Quiz 3: _______________________ refers to the length of the generated key that is created during the encryption process Basic authentication SSL strength digest bcrypt algorithm

SSL strength

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

WHERE

Quiz 3: The process of determining whether a server or client is who and what it claims to be is called ______________________. encryption revocation encapsulation authentication

authentication

QUIZ 2: 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() elements() fetch() exec()

bindValue()

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

can be a number or a string

The intersection of a column and row in a database table can be called a plot cell box slot

cell

Quiz 3: Algorithms used in cryptography are known as _____________________. sockets certificates hackers ciphers

ciphers

Quiz 3: Encryption and decryption algorithms used in cryptography are known as _________________________. cryptions hashes translators ciphers

ciphers

Quiz 3: When you use passwords to determine whether a user is authorized to use an application, the passwords are normally ____________________ before they are stored in the database. hashed encrypted scrambled translated

encrypted

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

exception

Quiz 2: A/An __________ is an object that contains information about an error. MySQL database PDO class exception username

exception

QUIZ 2: 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. get() fetch() fetchFirst() getFirst()

fetch()

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

fetch()

QUIZ 2: To return an array for all rows in a result set, you can call the _______________method of the PDOStatement object for the result set. fetch() get() getAll() fetchAll()

fetchAll()

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

foreach statement

Quiz 3: A hash function accepts a variable-size string and returns a fixed-size string known as a/an___________ digest hash cipher salt

hash

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

http://localhost/phpmyadmin

QUIZ 2: To refer to the elements in an array, you use a string or numeric __________________________. pointer id index locator

index

Quiz 2: 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. id name index number

index

Quiz 3: The $_SESSION variable for a session is an associative array is an object is a cookie is a regular array

is an associative array

QUIZ 2: What keyword must you code to create a PDO object? pdo new create make

new

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

new

The most common type of relationship between tables in a relational database is many-to-many one-to-one one-to-many

one-to-many

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 one-to-many-relationship many-to-many relationship

one-to-one relationship

Quiz 3: Which of the following is a PHP function used to encrypt a password? encrypt() password_hash() password_encrypt() encrypt_string()

password_hash()

Quiz 3: A cookie that does not expire when the user closes his or her browser is a(n) ____________ cookie. eternal session persistent perpetual

persistent

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

primary keys

To control what users can do with a database, SQL can be used to assign________ to users privileges permissions passwords keys

privileges

You can use phpMyAdmin to import and run a SQL ________ that creates one or more databases script file include file batch file exec file

script file

Quiz 3: Which PHP function can be used to end a session? session_destroy() session_start() session_remain() session_stop()

session_destroy()

Quiz 3: A session begins when a browser makes its first request to a page that executes the ___________________ function. session_begin() start_session() begin_session() session_start()

session_start()

Quiz 3: Which PHP function is used to resume a previous session? session_start() session_continue() session_resume() session_remain()

session_start()

Quiz 3: To delete a cookie, you use the delete_cookie() function use the remove_cookie() function set the cookie's value to an empty string and it's expiration date to a time in the past delete the $_COOKIE variable

set the cookie's value to an empty string and it's expiration date to a time in the past

Quiz 3: Which PHP function is used to create a cookie? $_COOKIE() create_cookie() setcookie() make_cookie()

setcookie()

What attribute of a column determined the data that can be stored in the column? whether it can contain null value the default value whether it's auto-incremented the data type

the data type

Quiz 3: When you use form-based authentication, the username and password are automatically encrypted and decrypted the browser automatically displays a dialog box for the username and password the username and password have to be sent for every protected page the programmer writes the code for the authentication process

the programmer writes the code for the authentication process

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

try/catch statement

QUIZ 2: To handle the PDO exceptions that can occur when database methods are executed, you use a _________ statement. method MySQL statement try/catch try block

try/ctach

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

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

Quiz 3: To check if a password the user enters matches an encrypted password that's stored in a database is valid, you can use the password_verify() function to compare the user entry with the encrypted password in the database decrypt the password in the database and compare it with the user entry use digest authentication to automatically encrypt the password and then compare it with the password in the database use the password_hash() function to encrypt the user entry and compare it with the encrypted password in the database

use the password_verify() function to compare the user entry with the encrypted password in the database