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