Log on to SQL*PLUS and do the following assessment lab tasks:
1. prepare an SQL statement to display the tables owned by user newYear.
2. prepare an SQL statement to display the number of tables owned by user newYear.
3. prepare an SQL statement to display the column names, null characteristics, and data types of books table.
4. prepare 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. prepare 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. prepare an SQL statement to display the titles of all books that cost at least 25 dollars.
9. prepare an SQL statement to display the titles of all books that cost at least 25 dollars and the category is computer