BIT quizes

What declares a variable in PHP?

$

What event handlers can correctly handle a click event on an element with an id value="starter"?

$("#starter").click(function(){...})

Which of the following jQuery methods is used to initiate an asynchronous web request?

$.ajax()

Which PHP system variable is initialized when a HTTP POST request is sent to the web server?

$_POST

What method will load the same PHP code page when the user clicks the Submit button?

$_SERVER['PHP_SELF'];

What XPath expression selects nodes no matter where they are in the XML doc?

//

What is the IP address of the loopback address, localhost?

127.0.0.1

ajax stands for:

Asynchoronous JavaScript and XML

Format of a delete statement:

DELETE FROM table WHERE criteria

XMl stands for?

Extensible Markup Language

Which technology is mostly used at the logic tier?

HTML

PHP stands for:

Hypertext Preprocessing

Format of an insert statement:

INSERT INTO table(cols...) VALUES(vals....)

jQuery is a:

JavaScript library

Complete the following SQL statement that lists all employees in the departments of 'Sal' and 'Mkt'. SELECT * FROM Employee WHERE dept_code='Sal' _______ dept_code='Mkt'

OR

What is a limitation for client-side scripting?

Placing large amounts of JavaScript on the client can cause security issues

MySQL is a:

RDBMS

What SQL statement will list employees whose last name is four letter and ends in 'e'?

SELECT * FROM Employee WHERE emp_lastname = '_ _ _e'

In the DOM, 2 nodes are __________ nodes when they have the same parent node.

Sibling

An XML doc is well-formed is an XML parser can process the doc successfully

True

DTDs and schemas are used to define element types, attributes, and their relationship.

True

XML allows document authors to create their own element tags.

True

Format of an update statement:

UPDATE table SET col = val WHERE criteria

In the jQuery syntax, $(selector:filter).action() the $ represents:

a jQuery object

A jQuery $(":text") selects:

all form elements with type="text"

A jQuery $("p") selects:

all paragraph elements

Session data ____________________ after the user has left the website or closed the browser.

are deleted

A user is directed to page2.php after submitting form data from page1.php. The user then clicks a link on page2.php to return to page1.php. The submitted form data _______________________________. are no longer available on page1.php

are no longer available on page1.php

The _____ command should be used to break a loop if the next command to be executed is the one that follows the loop.

break

In a switch statement, which statement must be used at the end of a case branch code segment?

break;

HTML SVG element is a/an:

container element for SVG graphics

What are 3 solutions to the data persistence problem?

cookie session databases

Which D3 method is used to open a JSON file?

d3.json()

Rich Internet Applications (RIA) are desktop applications that approximate the performance and rich GUI of web applications.

false

The html <style> tag is used reference the jQuery library

false

When a synchronous web request is being processed on the server, the user can still interact with the client web page.

false

What are core features in jQuery?

handling events DOM element selection/manipulation creating animation

JSON is a data format good for storing:

hierarchical data

Which of the following PHP functions determines if a variable has a value and is not NULL?

isset()

D3.js is a ________________________ for producing dynamic and interactive data visualizations.

javascript library

What does this code do? SELECT * FROM Employee WHERE emp_hiredate>='1997-01-01' AND emp_hiredate<='1997-12-31'

lists full details of employees who were hired in 1997

An HTTP cookie is a small piece of data stored ___________________.

locally in the user's browsers

In a multi-tier app architecture, the ____ tier implements business logic/controller logic.

middle

Which PHP function gets the number of affected DB records when executing an INSERT/UPDATE/DELETE statement?

mysqli_affected_rows()

What PHP method can get a row from the resultset of a SELECT statement and turn it into an array?

mysqli_fetch_array

Which PHP methods converts a row from a SELECT result into s JSON object

mysqli_fetch_assoc()

Session data are stored:

on the remote server

When PHP commands are processed _________ is sent by the web server to the clients browser.

only the output

Which of the following XMLHttpRequest properties stores a function to be called automatically each time the readystate property changes?

onreadystatechange

Which XMLHttpRequest methods is used to initialize an asynchronous web request?

open.('GET', dest.html', true)

What does DISTINCT do?

returns only unique values

SVG stands for:

scalable vector graphics

XPath is a language of expressions used to:

search data in XML docs

What method is used to initialize the $_SESSION variable?

session_start()

What method is used to create a cookie?

setcookie()

The top-level of the DOM is:

the document object

What is the correct way to specify that a cookie expires in 2 days?

time()+606024*2

A new session array, $_SESSION, must be initialized.

true

An Ajax application usually updates part of the web page after receiving a response from the server.

true

D3.js can use CSS and jQuery selectors.

true

In a 3-tier application architecture, the middle tier is located on a web server.

true

T/F During a cookie's lifespan, its data will be transmitted to the web server each time the user visits the website that the cookie belongs to.

true

The D3.js Axis component allows for addition of a horizontal-axis and vertical-axis to any graph.

true

The Same Origin Policy prevents the XMLHttpRequest object from requesting resources from domains other than the one that serves the application

true

The XMLHttpRequest object is used to manage interaction with the server in Ajax applications.

true

jQuery can achieve what JavaScript can do with less coding.

true

jQuery can completely seperate JavaScript from HTML

true