Write queries for thiS

1.Login to root database as sys. Create a new user johnny/johnny. Then log in with their username and password. What happens?

Login as sys again. Grant him a dba role.

Then log in as johnny. Try to shutdown the instance. What happens? How can you make johnny to shutdown the instance?

Once you solve the problem, shutdown the instance. Then startup the instance (as johnny) with a pfile of you created (please take a screenshot or copy/paste pfile content in your submission). Explain the parameters of your pfile and why you choose them. Once the instance started check if the instance started correctly with your parameters using SHOW PARAMETER (or you can query views) for each parameter you specified in spfile. Make sure that your instance started with your parameter values.


 

2.Login as a sys to container (root) level.

Check if you are running on server parameter file. If not, first startup with an spfile. Then check the size of your SGA.

Then increase the SGA_MAX_SIZE by

100MB (or something reasonable). Check the size of your SGA again. If it is not changed, why? How can you make it changed in your instance? Take the necessary steps and show them step by step.

3. Login as a sys to container (root) level. List me all the dynamically modifiable parameters in your instance. Then pick one of them and modify it. Make it persistent.Briefly describe the reason you pick that parameter and the reason you modified (increased/decreased) it. Show that the parameter modification is persistent.