· You will be asked to demonstrate your ability to apply what you’ve learned so far by writing SQL statements.
· The exam is issued in the class lab, so you many use our class materials, your personal notes and the SQL server software to assist you with answering questions. You may NOT use another person, or software which facilitates communication with another person (IM, chat, email, Twitter, Facebook, etc…)
· I will use classroom monitoring software during the exam to observe what each student has on his/her screens. Any student not completing the exam on their own merit or found assisting another student will receive a zero on the exam.
· You will access the exam questions through Blackboard, and upload your answers to Blackboard when you’re finished via the submission file.
· Some questions will require fudgemart tables from the lab; some will require NetFlix tables from the assignment.
· There will be 8 questions, worth 3 points each. You will be awarded
o 3 points for a correct answer,
o 2 points for an incorrect answer with only 1-2 minor mistakes,
o 1 point for an incorrect answer with serious errors (more than 3 mistakes).
o 0 points for an unanswered question, or completely incorrect question.
· You will receive a RAW exam score out of 24 which will then be translated into a score out of 100.
You will be asked to:
· Make tables, columns, check constraints, primary key constraints, and unique constraints using the CREATE TABLE statement.
· Use ALTER TABLE to add a foreign key constraint.
· INSERT or UPDATE data in a table
· Use CREATE PROCEDURE to write a simple procedure to INSERT or UPDATE data into a table.
· Use EXEC to run a stored procedure.
· Write a simple SELECT statement using one table. The statement may require column aliasing, WHERE, or ORDER BY.
· Write a SELECT statement that joins two tables. The statement may require column aliasing, WHERE, ORDER BY, or LEFT/RIGHT joins.
· Write a SELECT statement that requires you to use GROUP BY and/or HAVING.
· Demonstrate you can use CREATE VIEW to make a view from a select statement.