Architecture & Administration tips are as follows:
There are 4 dba triggers which we must be aware of :
Instance --startup , shutdown
User --logon, logoff
Schema -- alter,create , drop
Error messages
Just remember this any way you can.
I use a scheme like :IUSE:
where each capital word stands for the first letter of the type
of trigger.(I=>Instance,U=>User,S=>Schema and E=>Error Messages).
OEM :
1.)Back up manager -- For backup,recover and restoring a DB.
2.)Data Manager --Export ,import and load data.
3.)Storage manager --
4.)Instance Manager -- Ability to start up, shutdown, change
system parameters
5.)Security Manager
6.)Schema Manager
7.)
A Index cannot have a PCTUSED storage clause associated with it.
A user cannot be granted access to a private synonym on another user.
A Rollback Segment cannot have a PCTINCREASE parameter associated with
it, because all extents in a rollback segment should be of the same size.
When a synonym's underlying object is dropped the synonym becomes
invalid and needs to be re-compiled.
Create Sequence is a statement which does not require any storage
clause to it.