A.They can be used to track changes only to a table or index.

B.They can be defined by all users in the database or only by a specific user.

C.They are fired only when the owner of the object Issues the DDL statement.

D.They can be used to track changes to a table, table space, view, or synonym.

A.Any user who has the alter privilege on a table can create a trigger using that table.

B.Triggers become invalid if a dependent object, such as 3 stored subprogram that is invoked from the trigger body is modified, and have to be manually recompiled before the next invocation.

C.Oracle provides a two-phase commit process whether a trigger updates tables in the local database or remote tables in a distributed database.

D.All the triggers that are created on a table cannot be disabled simultaneously.

A.It is a private variable defined in a procedure or function within a package body whose
value is consistent within a user session.

B.It is a public variable in a package specification whose value is always consistent across all current active sessions.

C.It is a private variable in a package body whose value is consistent across all current active sessions.

D.It is a public variable in a package specification whose value is consistent within a user session.

A.All the blocks execute successfully and the anonymous block displays123cant: 4545cnt: 45.

B.All the blocks execute successfully and the anonymous block displays123cut: 045cart: 1.

C.The anonymous block gives an error because the function invocation in line 2 is not valid.

D.The procedure creation gives an error because the function invocation in line 1 is not valid.

A.The PROC3 procedure header should be declared at the beginning of the package body.

B.The PROC3 procedure should be declared in the package specification.

C.The variable x must be declared in the package body and removed from the specification,

D.The PROC2 procedure code should be defined in the package body.