Tag: technology

help mv

man mv

mv ?

mv help

grep test *

lookup test *

search test *

dir test .

ren FILE1 FILE2 - i

ren FILE1 FILE2

cp FILE1 FILE2

mv FILE1 FILE2

dir *

dir .

list all

ls -a

a) To duplicate the functionality of other triggers.

b) To replicate built-in constraints in the Oracle server such as primary key and foreign key.

c) To guarantee that when a specific operation is performed, related actions are performed.

d) For centralized, global operations that should be fired for the triggering statement, regardless of which user or application issues the statement.

a) A function must return a value.

b) A procedure must return a value.

c) A function executes a PL/SQL statement.

d) A function is invoked as part of an expression.

e) A procedure must have a return data type specify in its declaration.

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) Only local or packaged sub programs can be overloaded.

b) Overloading allows different functions with the same name that differ only in their return types.

c) Overloading allows different subprograms with the same number, type and order of the parameter.

d) Overloading allows different subprograms with the same name and same number or type of the parameters.

e) Overloading allows different subprograms with the same name but different in either number or type or order of parameter.

a) Packages can be nested.

b) You can pass parameters to packages.

c) A package is loaded into memory each time it is invoked.

d) The contents of packages can be shared by many applications.

e) You can achieve information hiding by making package constructs private.

a) CREATE OR REPLACE FUNCTION tax_amt (p_id NUMBER) RETURN NUMBER

b) CREATE OR REPLACE PROCEDURE tax_amt (p_id NUMBER) RETURN NUMBER

c) CREATE OR REPLACE PROCEDURE tax_amt (p_id NUMBER, p_amount OUT NUMBER)

d) CREATE OR REPLACE FUNCTION tax_amt (p_id NUMBER) RETURN NUMBER(10,2)

e) CREATE OR REPLACE PROCEDURE tax_amt (p_id NUMBER, p_amount OUT NUMBER(10, 2))