You want to maintain an audit of the date and time when each user of the database logs off.
Examine the following code:
Which two clauses should be used to fill in the blanks and complete the above code?
(Choose two.)
A.
ON SCHEMA
B.
ON QRXABASE
C.
AFTER LOGOFF
D.
BEFORE LOGOFF
Explanation:
b,d
“b” because it is typo of “ON DATABASE” and we need “maintain an audit .. WHEN EACH USER … logs off” and “ON SCHEMA” will audit only current user actitity.
“d” because “AFTER LOGOFF” event does not exist.
B,D
A,D
https://docs.oracle.com/cd/B28359_01/appdev.111/b28843/tdddg_triggers.htm#BABFBEJH
Answer: B, D
For single User logoff example – https://docs.oracle.com/cd/B28359_01/appdev.111/b28843/tdddg_triggers.htm#BABDHAEC
All user logoff in the Database Example –
http://www.dba-oracle.com/art_builder_sec_audit.htm
A,D
https://docs.oracle.com/cd/B28359_01/appdev.111/b28843/tdddg_triggers.htm#BABFBEJH
you are wrong it is an example for one user!
note_hr_logoff_trigger
In Example 5-5, you will create a table hr_users_log for keeping track of LOGON and LOGOFF events. You will then create triggers note_hr_logon_trigger (in Example 5-6) and note_hr_logoff_trigger (in Example 5-7) for writing these events to the log table.
Answer: B, D
For single User logoff example – https://docs.oracle.com/cd/B28359_01/appdev.111/b28843/tdddg_triggers.htm#BABDHAEC
All user logoff in the Database Example –
http://www.dba-oracle.com/art_builder_sec_audit.htm
Reply
B,D
B , D
BUT i hope it isn’t a trap
i mean
QRXABASE IS NOT DATABASE
WHAT’S THE RIGHT THING TO DO
MAY WE OR NOT ?
it’s a typo of DATABASE
B D is the right answer
B, D.
“A system trigger is defined on a schema or the database. A trigger defined on a schema fires for each event associated with the owner of the schema (the current user). A trigger defined on a database fires for each event associated with all users.”
https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/triggers.htm#LNPLS2001
bridestowe bear nz
http://www.ynwBRvyJ7B.com/ynwBRvyJ7B
Example 5.7 from ORACLE DOCUMENTATION (https://docs.oracle.com/cd/B28359_01/appdev.111/b28843/tdddg_triggers.htm#BABFBEJH): This trigger inserts a LOGOFF event record into the hr_users_log table whenever someone disconnects from the HR SCHEMA, not from DATABASE.
bd
ad
B,D