题目内容

Oracle物理结构包括数据文件、______ 、重做日志文件、归档文件、初始化参数文件、跟踪文件、口令文件、警告文件、备份文件等。

查看答案
更多问题

系统触发器是建立在系统或______ 上的触发器,响应系统事件和DDL(CREATE,ALTER,DROP)操作。

Oracle安全管理中,______ 角色拥有全部特权,是系统最高权限,只有它才能修改数据库结构。

Which three statements are true regarding database triggers?

An database trigger is a PL/SQL block or a PL/SQL procedure associated with a table, view, schema, or the database
B. An database trigger needs to be executed explicitly whenever a particular event takes place
C. An database trigger executes implicitly whenever a particular event takes place
D. An database trigger fires whenever a data event (such as DML) or system event (such as logon, shutdown) occurs on a schema or database
E. With a schema, triggers fire for each event for all users; with a database, triggers fire for each event for that specific user

You need to remove the database trigger trg_emp. Which command do you use to remove the trigger in the SQL*Plus environment?

A. DROP TRIGGER trg_emp
B. DELETE TRIGGER trg_emp
C. REMOVE TRIGGER trg_emp
D. ALTER TRIGGER trg_emp REMOVE

答案查题题库