harder questions

A web application is a type of: A) database application B) server-side application C) client-side application D) client/server application

D

When the web server receives an HTTP request for a PHP page, the web server calls the: A) database server B) static web page C) web browser D) PHP interpreter

D

Which of the following software components generates the HTML that is returned in an HTTP response? A) Apache B) PHP C) MySQL D) Chrome

B

To deploy a PHP application on your own computer, you copy the application root directory to: A) the htdocs directory of the MySQL server B) the xampp directory of the Apache server C) the htdocs directory of the Apache server D) the xampp directory of the MySQL server

C

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

D

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

D

An inner join combines data from two or more tables: A) if the primary key and foreign key are equal B) if the primary key and foreign key aren't equal C) if the primary keys in each table are equal D) if the primary keys in each aren't equal

A

You can use phpMyAdmin to import and run a SQL ________________ that creates one or more databases. A) batch file B) script file C) exec file D) include file

B

The ________________ extension to PHP defines an interface for accessing databases. A) SQL Data Objects B) PHP Data Objects C) PHP_SQL D) PDO_EXT

B

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

C

To handle the PDO exceptions that can occur when database methods are executed, you use a ________________ statement. A) on-error B) if/else C) try/catch D) handle-exception

C

To get an array for all rows in a result set, you can call the ________________ method of the PDOStatement object for the result set. A) fetch() B) fetchAll() C) get() D) getAll()

B

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. A) fetch() B) fetchFirst() C) get() D) getFirst()

A

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

C

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

A

To refer to the elements in an array, you use a string or numeric ________________. A) id B) index C) locator D) pointer

B

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. A) number B) name C) index D) id

C

When coding relative URLs, you can begin the URL with a single dot (.) to indicate that the URL should start with the ________________ directory. A) root B) parent C) current D) Child

C

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

B

What does the acronym PRG stand for? A) Pass-Regress-Go B) Pass-Redirect-Get C) Post-Regress-Go D) Post-Redirect-Get

D

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

A

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

B

What is the goal of debugging an application before it is put into production? A) fix all errors B) find all errors C) minimize errors D) create job security

A

When you're using NetBeans, you can step through the execution of an application one statement at a time by clicking on the ________________ button. A) Continue B) Step Into C) Step Over D) Step Out

B