Instructions: For each problem

Write and execute an SQL query in Oracle Live SQL or SQL$*$Plus

Execute the following command: select sysdate, 'your name' from dual; where your$\_$name is substituted with your name

Take a screenshot that includes both SQL statements and all results

Copy and paste the screenshot into a Word file containing your solutions

Practice Problems: Table Creation and Management

Create a new table containing at least four columns of four different data types $($CHAR$,$ VARCHAR$2,$ NUMBER, DATE$).$ Name the table your$\_$first$\_$name$\_$your$\_$last$\_$name $($substitute your$\_$first$\_$name with your first name and your$\_$last$\_$name with your last name$).$

Retrieve a list of tables in your schema to confirm that the table created in Problem $1$ is stored in your schema.

Obtain information about the table created in Problem $1.$ Display the structure of the table that includes column names, data types, and constraints.

Add a column to the table created in Problem $1.$

Change the size of any column in the table created in Problem $1.$

Add a new constraint $($UNIQUE$,$ CHECK, etc.$)$ to any column in the table created in Problem $1.$

Drop a column in the table created in Problem $1.$

Mark one of the columns in the table created in Problem $1$ as unused. Verify that the column is no longer available.

Rename the table created in Problem $1.$

Delete the table created in Problem $1$ permanently so that it isn$$t moved to the recycle bin.