Tag: technology
Questions Related to technology
-
a) When declaring arguments length is not allowed.
-
b) When declaring arguments each argument must have a mode specified.
-
c) When declaring arguments each argument must have a length specified.
-
d) When declaring a VARCHAR2 argument it must be specified.
-
a) In the package body.
-
b) In the data base triggers.
-
c) In the package specification.
-
d) In the procedures declare section using the exact name in each.
-
a) The COMMIT and ROLLBACK commands are allowed in the packaged function.
-
b) You can not use packaged functions in a query statement.
-
c) The packaged function cannot execute an INSERT, UPDATE, or DELETE statement against the table that is being queried.
-
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 can execute an INSERT, UPDATEM or DELETE statement against the table that is being queried if the pragma RESTRICT REFERENCE is used.
-
a) GRANT SELECT ON ADD_PLAYER TO PUBLIC;
-
b) GRANT EXECUTE ON ADD_PLAYER TO PUBLIC;
-
c) GRANT INSERT ON PLAYER TO PUBLIC;
-
d) GRANT EXECUTE, INSERT ON ADD_PLAYER TO PUBLIC;
-
e) REVOKE INSERT ON PLAYER FROM PUBLIC;
-
a) V_SUM
-
b) CALC_ORD.
-
c) FORWARD_PACK
-
d) GENERATE_SUMMARY.
-
a) V_SUM
-
b) CALC_ORD.
-
c) FORWARD_PACK
-
d) GENERATE_SUMMARY.
-
assert
-
interface
-
extend
-
transient
-
a) When declaring arguments length is not allowed.
-
b) When declaring arguments each argument must have a mode specified.
-
c) When declaring arguments each argument must have a length specified.
-
d) When declaring a VARCHAR2 argument it must be specified.
-
Tells you who's logged in, and what they're doing
-
Tells you when the user last logged
-
Lets you change your password
-
None of the above
-
a) Trap it with a Handler
-
b) Propagate it to the Calling Environment
-
c) a & then b
-
d) b & then a