Homework CS3431 1 (Fall 2007, B term)
Homework Homework Homework Homework Out: Friday, Oct 26, 2007 (in class) Due: Monday, Nov 2nd, 2007 at 9:59 am (before class) Submit: In hardcopy at start of class Monday! Points: A maximum of 50 pts.
Problem: Getting You Started With Oracle. You need to do the following: Create a table GameScore with attributes playerNumber of type integer, and score of type integer. We provide a script to randomly generate data to be loaded into your Game database. For that, save the script available at: http://www.cs.wpi.edu/cs3431/b07/hw1/ in your local directory. Execute the above script as ./createData.pl. Make sure that this script is executable, otherwise change permissions as chmod 755 createData.pl . This will create sample data in a le sample.dat. Now load this data into your table. The number of tuples will be huge. So you are encouraged strongly to use a bulk loader. You do not want to be entering all those tuples by hand. From SQLPLUS, if we execute the command SET TIMING ON, for every SQL statement, you will get the time it took for the database server to execute that statement. For each of the following SQL statements, run them, and then report the answer, as well as the time it took for executing that statement. Lastly make some observations about which query ran the quickest, and which one the slowest. Indicate if this is what you had e...