Quiz 12 -- CS 290W -- Apr 22, 99
(1) Which of the following retrieves only one column from the table
Vehicle for vehicle IDs between 200 and 300?
(1) SELECT Motor FROM Vehicle WHERE VehID >= 200 AND VehID <= 300;
(2) SELECT * FROM Vehicle WHERE VehID >= 200 AND VehID <= 300;
(3) SELECT * FROM Vehicle;
(4) SELECT Motor FROM Vehicle WHERE VehID = 200-300;
(1)
(2) What Oraperl function returns a row of database values?
(1) &ora_login
(2) &ora_open
(3) &ora_fetch
(4) &ora_return
(3)
(3)
$_ = "purdue university";
$iHuh = tr/udin/1234/;
What is $iHuh after the tr statement?
(1) "p1r21e 143vers3ty"
(2) "p1r2e 1vers3ty"
(3) "purdue university"
(4) 7
(4)