1. What are the SQL statements to perform the following tasks?

a) Create a tablespace Hw3Tbs that contains a 32MB datafile in directory C:\app\Student\oradata\csc544744\TEMP.

b) Add another 8MB to tablespace Hw3Tbs.

c) Create a new user UserForHw3. The user will use hw3pass as the password, and have 4MB of quota on the default tablespace Hw3Tbs and unlimited quota on tablespace USERS. The user should be allowed to create session and create tables in its schema.

c) Assume all tasks in problem 1 have been completed successfully and you logged into the database as user UserForHw3. What is the SQL statement to create a table TB1 with three columns a, b and c, where a is an integer with at most 5 digits and serves as the primary key, b is a string with exactly 8 characters, and c is string with at most 25 characters?

d) What is the SQL statement to insert a row (279, computer, something) into table TB1?

e) Assume steps c) and d) have been completed successfully. How many segments will be generated for table TB1?