you have security to send a DEP record from a content management ticket. there is a PLS pool record networked to DEP record, a master file for which you also have security. that PLS pool record does not exist in the destination environment yet. when you click calculate dependencies, in which section will the PLS record appear?

The Car Maintenance team wants to add Tire Change (ID: 1) maintenance task for all cars with the due date of 1 September, 2021. However, the team also wants to know that if an error occurs the updates will rollback to their previous state. Create a script for them to first add all tasks and then rollback the changes.     COMMIT TRANSACTION;    PRINT 'Tire change maintenance task added for all cars with due date of 1 September, 2020.';END

Discuss the merits and demerits of supporting links to files that cross mount points (that is, the file link refers to a file that is stored in a different volume).

Suppose that a DBMS recognizes increment, which increments an in- teger-valued object by 1, and decrement as actions, in addition to reads and writes. A transaction that increments an object need not know the value of the object; incre- ment and decrement are versions of blind writes. In addition to shared and exclusive locks, two special locks are supported: An object must be locked in I mode before incrementing it and locked in D mode before decrementing it. An I lock is compatible with another I or D lock on the same object, but not with S and X locks. 1. Illustrate how the use of I and D locks can increase concurrency. (Show a schedule allowed by Strict 2PL that only uses S and X locks. Explain how the use of I and D locks can allow more actions to be interleaved, while continuing to follow Strict 2PL.) 2. Informally explain how Strict 2PL guarantees serializability even in the presence of I and D locks. (Identify which pairs of actions conflict, in the sense that their relative…