[go: up one dir, main page]
Scribd
Upload
1K views3 pages

Understanding Remote Dependencies

This document is a quiz about remote dependencies in Oracle databases. It covers topics like: - Signature mode vs timestamp mode for checking remote dependencies - How timestamps are used to determine if a procedure needs to be recompiled - What constitutes a remote dependency (when an object depends on another residing on a separate database node) - That the default setting for remote dependency checking is timestamp mode

Uploaded by

Catalina Achim
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
1K views3 pages

Understanding Remote Dependencies

This document is a quiz about remote dependencies in Oracle databases. It covers topics like: - Signature mode vs timestamp mode for checking remote dependencies - How timestamps are used to determine if a procedure needs to be recompiled - What constitutes a remote dependency (when an object depends on another residing on a separate database node) - That the default setting for remote dependency checking is timestamp mode

Uploaded by

Catalina Achim
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 3

Test: Quiz: Understanding Remote Dependencies 1.

In Signature Mode, a procedure will not compile if the signatures of th e remote dependencies do not match. True or False? Mark for Review (1) Points True (*) False

Correct 2. In this scenario, the following status is given for each procedure: Procedure A is local and has a time stamp of 10 AM Procedure B is remote and has a local time stamp of 5 AM and has a remote time s tamp of 4 AM In Timestamp Mode, Procedure A will execute successfully at 11 AM. True or False ? Mark for Review (1) Points True False (*)

Correct 3. In Signature Mode, a compiled procedure is still valid if its dependent procedure has a parameter data type change from NUMBER to INTEGER. Mark for Review (1) Points True (*) False

Correct 4. The Data Dictionary controls the remote dependency mode. True or False? Mark for Review (1) Points True False (*)

Incorrect. Refer to Section 14 Lesson 2. 5. A remote dependency is when a dependent object resides on a database on a separate node. True or False? Mark for Review (1) Points True (*) False

Incorrect. Refer to Section 14 Lesson 2. 6. In this scenario, the following status is given for each procedure: Procedure A is local, executed, and invalidated because the remote Procedure B t ime stamp does not match the local time stamp for Procedure B Procedure A is recompiled. In Timestamp Mode, now Procedure A will execute successfully. True or False? Mark for Review (1) Points True (*) False

Correct 7. With remote dependencies, one master data dictionary that resides on on e server identifies the status of all schema objects. True or False? Mark for Review (1) Points True False (*)

Correct 8. Which statement for setting a database parameter is the default for rem ote dependency checking? Mark for Review (1) Points ALTER SESSION SET REMOTE_DEPENDENCIES_MODE = TIMESTAMP (*) ALTER SESSION SET REMOTE_DEPENDENCIES_MODE = SIGNATURE

ALTER SESSION REMOTE_DEPENDENCIES_MODE = TIMESTAMP ALTER SESSION REMOTE_DEPENDENCIES_MODE = SIGNATURE

Incorrect. Refer to Section 14 Lesson 2.

You might also like