SQL> desc dba_triggers
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 OWNER                                     VARCHAR2(30)
 TRIGGER_NAME                              VARCHAR2(30)
 TRIGGER_TYPE                              VARCHAR2(16 CHAR)
 TRIGGERING_EVENT                          VARCHAR2(227 CHAR)
 TABLE_OWNER                               VARCHAR2(30)
 BASE_OBJECT_TYPE                          VARCHAR2(16 CHAR)
 TABLE_NAME                                VARCHAR2(30)
 COLUMN_NAME                               VARCHAR2(4000)
 REFERENCING_NAMES                         VARCHAR2(128)
 WHEN_CLAUSE                               VARCHAR2(4000)
 STATUS                                    VARCHAR2(8 CHAR)
 DESCRIPTION                               VARCHAR2(4000)
 ACTION_TYPE                               VARCHAR2(11 CHAR)
 TRIGGER_BODY                              LONG

SQL> select owner,trigger_name,trigger_type,triggering_event
  2  from dba_triggers
  3  where trigger_type like '%EVENT'
  4    and triggering_event like '%DROP%'
  5  order by 1,2
  6  /
OWNER                          TRIGGER_NAME                   TRIGGER_TYPE     TRIGGERING_EVENT
------------------------------ ------------------------------ ---------------- --------------------
EXFSYS                         EXPFIL_DROPOBJ_MAINT           BEFORE EVENT     DROP
EXFSYS                         EXPFIL_DROPUSR_MAINT           AFTER EVENT      DROP
LBACSYS                        LBAC$AFTER_DROP                AFTER EVENT      DROP
MDSYS                          SDO_DROP_USER                  AFTER EVENT      DROP
MDSYS                          SDO_DROP_USER_BEFORE           BEFORE EVENT     DROP
MDSYS                          SDO_TOPO_DROP_FTBL             BEFORE EVENT     DROP
SYS                            AW_DROP_TRG                    AFTER EVENT      DROP
SYS                            CDC_DROP_CTABLE_BEFORE         BEFORE EVENT     DROP
SYS                            NO_VM_DROP                     BEFORE EVENT     DROP
SYS                            NO_VM_DROP_A                   AFTER EVENT      DROP
XDB                            XDB_PI_TRIG                    BEFORE EVENT     DROP OR TRUNCATE

select owner, object_type, object_name from dba_objects where upper(object_name) = 'VATRATE';

SQL> drop table non_existent;
drop table non_existent
           *
ERROR at line 1:
ORA-00942: table or view does not exist

select owner,trigger_name,trigger_type,triggering_event
from dba_triggers
where trigger_type like '%EVENT'
  and triggering_event like '%DDL%'
order by 1,2
/

select trigger_type,triggering_event
from dba_triggers
where owner='CTXSYS'
  and trigger_name='DRIACC'
/