True

False

True

False

True

False

True

False

True

False

True

False

True

False

True

False

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))

a) EXECUTE UPD_BAT_STAT;

b) EXECUTE UPD_BAT_STAT(V_AB=>10, V_ID=>31);

c) EXECUTE UPD_BAT_STAT(31, 'FOUR', 'TWO');

d) UPD_BAT_STAT(V_AB=>10, V_ID=>31);

e) RUN UPD_BAT_STAT;

a) An exception cannot propagate across remote procedure calls.

b) An exception raised inside a declaration immediately propagates to the current block.

c) The use of the RAISE; statement in an exception handler reprises the current exception

d) An exception raised inside an exception handler immediately propagates to the enclosing block.

[_] [a] JDBC is an API to connect to relational-, object- and XML data sources

[_] [b] JDBC stands for Java DataBase Connectivity

[_] [c] JDBC is an API to access relational databases, spreadsheets and flat files

[_] [d] JDBC is an API to bridge the object-relational mismatch between OO programs and relational

O (a) java.jdbc and javax.jdbc

O (b) java.jdbc and java.jdbc.sql

O (c) java.sql and javax.sql

O (d) java.rdb and javax.rdb

O (a) Type 1 driver

O (b) Type 2 driver

O (c) Type 3 driver

O (d) Type 4 driver

O (a) Type 1 driver

O (b) Type 2 driver

O (c) Type 3 driver

O (d) Type 4 driver