Tag: databases
Questions Related to databases
-
Local variables.
-
Arguments.
-
Boolean variables.
-
Substitution variables.
-
VARCHAR2.
-
BOOLEAN.
-
OUT.
-
IN.
-
When the procedure contains no SQL statements.
-
When the procedure contains no PL/SQL commands.
-
When the procedure needs to be used by many client applications accessing several remote databases.
-
When the procedure needs to be used by many users accessing the same schema objects on a local database.
-
V_SUM
-
CALC_ORD.
-
FORWARD_PACK
-
GENERATE_SUMMARY.
-
When declaring arguments length is not allowed.
-
When declaring arguments each argument must have a mode specified.
-
When declaring arguments each argument must have a length specified.
-
When declaring a VARCHAR2 argument it must be specified.
-
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) PROCEDURE add_product (p_order_date DATE);
-
b) PROCEDURE add_product (p_name VARCHER2, P_ORDERED DATE);
-
c) PROCEDURE add_product (p_prodname VARCHER2, P_PRISE NUMBER);
-
d) PROCEDURE add_product (p_prize NUMBER, P_DESCRIPTION VARCHER2);
-
show users;
-
display user;
-
show name;
-
show user;
-
SQL> set sqlprompt “Qwest > “
-
SQL> set prompt “Qwest > “
-
SQL> sqlprompt set “Qwest > “
-
SQL> prompt “Qwest > “
-
bye
-
end
-
host
-
None of above