When these commands are executed in SQL*Plus or a similar interface, what is the output?
CREATE TYPE temperature_t AS TABLE OF NUMBER; / CREATE TABLE hourly_temperatures (temperature_date DATE, temperatures temperature_t) NESTED TABLE temperatures STORE AS temperature_store; SELECT COUNT(*) FROM hourly_temperatures / SELECT COUNT(*) FROM temperature_store /
Assuming the same types and declarations shown in 7-10, what happens when a user issues the following SELECT statement?
SELECT COUNT(*) FROM temperature_store /
Knowitall Andthensome passed his MCSE exam by answering question number 1 as 10, question 2 as 20, question 3 as 30, question 4 as 40, and question 5 as 50. Given the following type definitions, create a single SQL statement that inserts Knowitall’s responses into the student_answers table:
CREATE TYPE answer_t AS OBJECT ( question_no NUMBER(10), answer_no NUMBER(10)); CREATE TYPE answer_list_t AS TABLE OF answer_t; CREATE TABLE student_answers ( student_id INTEGER, exam_date DATE, exam_id INTEGER, student_answer_values answer_list_t) NESTED TABLE student_answer_values STORE AS student_answer_store;
Now that there is an entry in the student_answers, what syntax is required to query all fields in the student_answers table? All fields in the nested table?
Continuing with the student_answers example, what SQL syntax is required to add another answer?
What is the SQL syntax to delete the entry just added?
An Oracle error is lurking within ...