Thread: Dynamic & static parameters

I am last year computer science student. I am doing one project where I use SQL as a backend. I have little bit knowledge of SQL.I want to know about what is the difference between Dynamic and static parameters in database. Any suggestion would be highly appreciated.

The parameters are plays a very important role in the database. It defines the structure of database. The parameters are stored in the database file named parameter files.

There are two types of files exist in the database, file and SPFILE both are used to define the structure of database. The parameters handle the database activity. If both are in the conditions of loss then you need to recover the database.

Actually two files named parameter file and password files are not stored into the database. If it would be controlled by the database then the database can't be start because these are the files which is responsible to start the database.