Technology Questions

Oracle SQL developer is an Oracle Database IDE.

Standard modules contain variables, procedures and functions that are accessible anywhere within the project. A class module contains properties and events, and is made accessible only by objects that were created as an instance of that class.

IDMS uses record locks to prevent another run-unit from updating the same record.

Copy constructor is a constructor function with the same name as the class and used to make deep copy of objects.

A Monitor defines a lock and condition variables for managing concurrent access to shared data. The monitor uses the lock to ensure that only a single thread inactive in the monitor code at any time.

A monitor allows only one thread to lock an object at once.

DLR is a runtime environment that allows you to integrate dynamic languages with the Common Language Runtime (CLR) by adding a set of services, such as expression trees, call site caching, and dynamic object interoperability to the CLR.

The System.Dynamic and System.Runtime.CompilerServices namespaces are used to hold the classes for DLR. It also provides dynamic features to statically-typed languages, such as C# and Visual Basic to enable their interoperation with dynamic languages.

-  The process of having a copy of redo log files is called mirroring.
-  It is done by creating group of log files together. This ensures that LGWR automatically writes them to all the members of the current on-line redo log group.
-  In case a group fails, the database automatically switches over to the next group. It diminishes the performance.