There will be 20 Scantron type questions (multiple choice/true-false) worth 3 points each for a total of 60 points . They will be taken from the review questions used for the weekly quiz plus questions regarding debugging (Hint: The questions on the handout "might" prove very informative.) The coding section will include 10 questions worth 40 points. The total point value for the test is 100 points.
There may also be some basic questions on security, SQL Injection, SHAH1, MD5, and Salt.Notes may be
used during the test. The notes may be no larger than one 3”x 5” note card (or sheet of paper of equivalent size). The notes must be
student prepared (hand written or word processed) It may not be a photocopy
of class handouts, portions of the text, or similar items. It is hoped that
by allowing notes it will help students to organize the material and
determine the most important concepts. The notes must be submitted with the
test and will not be returned to the student.
There will be a 25 point deduction if the notes used during the test do not meet the above specifications.
| Coding Content | ||
|---|---|---|
| Chapter 7 - SQL Commands | ||
| CREATE DATABASE | ORDER BY | INSERT INTO |
| SELECT DATABASE | GROUP | LOAD DATA INFILE |
| SHOW DATABASES | DROP | AVG(), MIN(),MAX(), SUM(), COUNT() |
| USE | CREATE TABLE | UPDATE |
| SELECT, WHERE | ALTER TABLE | DELETE |
| Chapter 8 - Using PHP code and SQL Statements | ||
| Open and close MySQL connections ansd Query Results | ||
| Reporting and suppressing errors (including abbreviated syntax p.451 and error control/supression operator p.452) | ||
| Creating, selecting, and deleting a database | ||
| Three common database operations which should include error trapping before additional coding is executed. | ||
| Retrieving records | ||
Retrieving records into an indexed and into an associative array |
||
| Secure Coding - SQL Injection, Authentication, SSL, Password Encryption | ||
| mysql_real_escape_string(), mysqli_real_escape_string() | ||
| Code that could be used for SQL injection | ||
| MD5() SHA1() Salt Values - know the number of bits for each | ||
Hint: This test I like Pink ... it is very Spring-like. Hint, Hint!