Set - 9

Question 21 :

How do you add a data file to a tablespace

Answer :

ALTER TABLESPACE ADD DATAFILE SIZE


Question 22 :

How do you resize a data file?

Answer :

ALTER DATABASE DATAFILE RESIZE ;


Question 23 :

What view would you use to look at the size of a data file?

Answer :

DBA_DATA_FILES


Question 24 :

What view would you use to determine free space in a tablespace?

Answer :

DBA_FREE_SPACE


Question 25 :

How would you determine who has added a row to a table?

Answer :

Turn on fine grain auditing for the table.