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
Which statement about triggers is true?
A. You use an application trigger to fire when a DELETE statement occurs
B. You use a database trigger to fire when an INSERT statement occurs
C. You use a system event trigger to fire when an UPDATE statement occurs
D. You use an INSTEAD OF trigger to fire when a SELECT statement occurs
Which two statements about the overloading feature of packages are true?
A. Only local or packaged subprograms can be overloaded
B. Overloading allows different functions with the same name that differ only in their return types
C. Overloading allows different subprograms with the same name, number, type and order of parameters
D. Overloading allows different subprograms with the same name and same number or type of parameters
E. Overloading allows different subprograms with same name, but different in either number, type or order of parameters