Run sqlplus system/Oracle11 and spool to c:\cis4210\M6spool.txt. You might want to set linesize to 132 and pagesize to 10000. Using the information available in the dba tables (dba_users, dba_tables, etc.) find and print the following information using SELECT statements.

1. Which is the largest table in the database and who owns it?

2. Which tables belonging to SCOTT do not have indexes?

3. Do the data files have fixed sizes or do they expand automatically to accommodate more data?

***What I would need it the correct statements to type in order to achieve the answeres to the about 3 questions; and create a spool from the results. For Example, for Question 1, I believe the statement would be select owner,table_name,sample_size from dba_tables where sample_size = (select max(sample_size) from dba_tables); Please correct me if I'm wrong. I am unsure what to type in order to achieve the answers to question 2 and 3. Thank you.