Online Access Free 1Z0-147 Practice Test

When using a PL/SQL stored package, how is a side effect defined?

• A.changes to database tables or packaged variables defined in a package specification
• B.changes only to packaged public variables defined in a package body
• C.changes only to packaged public variables defined in a package specification
• D.changes only to database tables
• E.changes to database tables or packaged public variables defined in a package body

Examine this code:
CREATE OR REPLACE PROCEDURE audit_action (p_who VARCHAR2) AS BEGIN INSERT INTO audit(schema_user) VALUES(p_who); END audit_action; /
CREATE OR REPLACE TRIGGER watch_it AFTER LOGON ON DATABASE CALL audit_action(ora_login_user) / What does this trigger do?

• A.The trigger invoked the procedure audit_action each time a user logs on to his/her schema and adds the username to the audit table.
• B.The trigger invokes the procedure audit_action each time a user logs on to the database and adds the username to the audit table.
• C.The trigger records an audit trail when a user makes changes to the database.
• D.The trigger marks the user as logged on to the database before an audit statement is issued.

All users currently have the INSERT privilege on the PLAYER table. You only want your users to insert into this table using the ADD_PLAYTER procedure. Which two actions must you take? (Choose two)

• A.GRANT INSERT ON PLAYER TO PUBLIC;
• B.REVOKE INSERT ON PLAYER FROM PUBLIC;
• C.GRANT EXECUTE ON ADD_PLAYER TO PUBLIC;
• D.GRANT SELECT ON ADD_PLAYER TO PUBLIC;
• E.GRANT EXECUTE,INSERT ON ADD_PLAYER TO PUBLIC;

When using a packaged function in a query, what is true?

• A.You can not use packaged functions in a query statement.
• B.The COMMIT and ROLLBACK commands are allowed in the packaged function.
• C.The packaged function can execute an INSERT, UPDATEM or DELETE statement against the table that is being queried if the pragma RESTRICT REFERENCE is used.
• D.The packaged function can execute and INSERT, UPDATE, or DELETE statement against the table that is being queried if it is used in a subquery.
• E.The packaged function cannot execute an INSERT, UPDATE, or DELETE statement against the table that is being queried.

What part of a database trigger determines the number of times the trigger body executes?

• A.Trigger body
• B.Trigger timing
• C.Trigger event
• D.Trigger type