$(7-2)$ Question $1$:

Modify the select statement in this section to display the hire$\_$date column in the format:

January $10,2012.$

$(7-3)$ Question $2$:

Add a new row to a copy of the employees table, sec$0703\_$employees. Set the hire date to show

that the person was hired at $10$:$00$ AM$.$

$(7-6)$ Question $3$:

Create a new sequence named seq$0706\_$my$\_$stuff. Set the beginning value to $100.$

$(7-7)$ Question $4$:

Determine the current value of the sequence seq$\_$sec$0707.$ Then use its next three values to add

new rows to the sec$0707\_$sequence table. This table has only one column. It holds the value of

the sequence number.

$(7-9)$ Question $5$:

Build an index on a copy of the departments table, sec$0709\_$departments. Index the

department$\_$name field.

$(7-12)$ Question $6$:

Find information about the datatypes of all the columns of the L$\_$FOODS table.

$(7-14)$ Question $7$:

Find out what indexes there are on the L$\_$DEPARTMENTS table.

$(7-16)$ Question $8$:

Find all the tables in the Oracle Data Dictionary about views.

$(7-17)$ Question $9$:

Find the meanings of all the columns of the user$\_$tables table