Subject: Oracle DBA

Problem C: Tablespace and Indexes (a) Write SQL statements to create the following tables as user SCOTT for an order entry system that you are implementing. The tables and the columns are shown below:

Use tablespace USER5. (b) How do you find out which files and blocks contain the rows for the orders table? (c) You are now considering creating indexes on the NAME and REGION columns of the CUSTOMERS table. Suppose there are many distinct values for column NAME, but only a few distinct values for column REGION. What types of index are appropriate for the two columns? Write SQL to create the indexes, naming them CUST_NAME_IDX and CUST_REGION_IDX, respectively, and placing them in tablespace indx05.

Data Type and Size Table Column VARCHAR 2 (3) CUSTOMERS CUST CODE 5 VARCHAR 2 (50) NAME REGION VARCHAR 2 (5) NUMBER (3) ORDERS ORD ID ORD DATE DATE VARCHAR 2 (3) CUST CODE DATE OF DELY DATE