Log on to SQL*PLUS and do the following assessment lab tasks:
1. Write an SQL statement to display the tables owned by user newYear.
2. Write an SQL statement to display the number of tables owned by user newYear.
3. Write an SQL statement to display the column names, null characteristics, and data types of books table.
4. Write an SQL statement to display the column names, null characteristics, and data type of author table.
5. Perform a full-table scan on the promotion table.
6. Write an SQL statement to display each shipping date for customer 1005 from the orders table. Display both the customer number and the shipping date.
7. Describe the customers table.
8. Write an SQL statement to display the titles of all books that cost at least 25 dollars.
9. Write an SQL statement to display the titles of all books that cost at least 25 dollars and the category is computer