CS 2316 Midterm: CS2316 GT PracticeExam3
Document Summary
This practice exam is slightly longer than your actual exam. Note that any material on the previous exams are also fair exam questions for your actual exam 3. Take this exam on a piece of paper, then check your answers using your computer. Use the following table people to answer the next 4 questions id name address. Georgia tech email summetj@gatech. edu timetravel@harvard. edu georgepbudell@gatech. edu random@uga. edu whoisthis@gatech. edu (2) write an sql query that prints the name and email of every person whose last name is. "doe". (2) write an sql query that changes the address of any record with the name "jay. Summet" to "6464 atlantic drive". (2) write an sql query that prints out the every name in the database alphabetically (starting with a,b,c,). Do not print out multiple copies of the same name. (2) write an sql query that deletes every entry in the database that does not have a school name of "georgia tech" (cid:1)
