最新的Oracle9i program with pl/sql - 1Z0-147免費考試真題

A. When referencing a package procedure or function from a stand-alone procedure or function, if the package body changes and the package specification does not change, the stand-alone procedure referencing a package construct becomes invalid

B. When referencing a package procedure or function from a stand-alone procedure or function, If the package specification changes, the stand-alone procedure referencing a package construct as well as the package body become invalid

C. When referencing a package procedure or function from a stand-alone procedure or function, if the package body changes and the package specification does not change, the stand-alone procedure referencing a package construct remains valid.

D. When referencing a package procedure or function from a stand-alone procedure or function, if the package specification changes, the package body remains valid but the stand-alone procedure becomes invalid

A. All LOBs have read and write access

B. NCLOB represents a multi-byte character object

C. BFILES are stored in the database

D. The Oracle9i server performs implicit conversions between BLOBs and NUMBER data types

E. The Oracle9i server performs implicit conversions between CLOBs and VARCHAR2 data types

A. Stored in the database.

B. A table.

C. A column that is a primary key.

D. A file stored outside of the database, with an internal pointer to it from a database column.

A. A compile time error occurs.

B. A runtime error occurs. The effect of trigger body is rolled back, but the update on the EMP table takes place.

C. A runtime error occurs. The update on the EMP table does not take place, but the insert into the AUDIT_TABLE occurs.

D. The trigger fires successfully. The update on the EMP table occurs, and data is inserted into theAUDIT_TABLE table.

E. A runtime error occurs. The effect of trigger body and the triggering statement are rolled back.

A. Invalid objects cannot be described.

B. The Oracle server automatically records dependencies among objects.

C. You can view whether an object is valid or invalid in the USER_OBJECTS data dictionary view.

D. An object with status of invalid cannot be a referenced object.

E. You can view whether an object is valid or invalid in the USER_STATUS data dictionary view.

F. All schema objects have a status that is recorded in the data dictionary.

A. GRANT EXECUTE ON ADD_PLAYER TO PUBLIC;

B. GRANT INSERT ON PLAYER TO PUBLIC;

C. GRANT EXECUTE,INSERT ON ADD_PLAYER TO PUBLIC;

D. GRANT SELECT ON ADD_PLAYER TO PUBLIC;

E. REVOKE INSERT ON PLAYER FROM PUBLIC;

A. add_dept(, 'New York');

B. add_dept;

C. add_dept(p_location=>'New York');

D. add_dept('Accounting');

A. privilege

B. view

C. sequence

D. procedure

E. packaged procedure or function

F. anonymous block

A. The packaged function cannot execute an INSERT, UPDATE, or DELETE statement against the table that is being queried.

B. 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.

C. 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.

D. The COMMIT and ROLLBACK commands are allowed in the packaged function.

E. You can not use packaged functions in a query statement.