What are the major inputs into the physical database design and build process?

Discuss in detail thedecisions that are influenced bythose inputs

b$)$ With an Oracle Database in mind, outline the basic data storage options

avallable, discuss primary and secondary storage and the options available today.

c$)$ What are the many benefits of usingTablespaces? Give examples.

d$)$ What is the role and benetit of an Index?

e$)$ Explain query optimisation as implemented in an Oracle environment.