Use the sql plus and deliver the spool file

o Realizing the importance of the initialization parameters

o Knowing the values of some key parameters

SQL> SPOOL C:\Users\studentx\Desktop\result.txt

You can use any folder with any path you want in your local hard disk to save all the executed statements in the active session.

SQL> select * from emp;

SQL > SPOOL off

REQUESTS

1. By reference to the database startup stages, you are requested to:

1..2. Use the Enterprise Manager and deliver the screen shots.

2. How to flush all the information in the shared pool? Write the related SQL statements using SQL PLUS and deliver the spool file. Explain why DBA use this action?

5. List all the initialization parameters that can be modified on session level and those that can be modified on system level too:

5..1. Use the SQL PLUS and deliver the spool file.

7. Create a user named “SUCCESS_USER” and give him the required privileges to access the database and create sessions, with the following quotas on the tablespaces: Users: 20 MB, system: 5 MB. And with the authentication method: external:

7..1. Use the SQL PLUS and deliver the spool file.

1- Group number, names of the students, IDs and their classes in a separate page.

2- Written answers for the questions.