before trigger
after trigger
row level trigger
statement level trigger

Row level trigger

For DDL commands, We cannot do autocommit off. It is modify structure of database object such as table, view and these commands have automatically commit.

Set autocommit on/off is used for DML.

by using set autocommit on we can do it

Yes.Becoz sysdate contains date and time.For example: if u create a table like thiscreate table ex(id number,date1 date defualt sysdate unique);u get table created. After that if u insert rows in that...

yes it will