Technology Questions

Managed execution process is a process where CLR executes the managed code. The steps involved in this process are:

1.  Choosing the right compiler


2.  Compiling the code to MSIL. This also generates the required metadata.


3.  Compile the MSIL ode to native machine code.


4. Executing the code with the variety of services available

SQL> ALTER USER user_name ACCOUNT LOCK;

SQL> ALTER USER user_name ACCOUNT UNLOCK;

JDK is Java Development Kit which is for development purpose and it includes execution environment also.

JVM is Java Virtual Machine which is a run time environment for the compiled java class files .Hence you will not be able to compile your source files using a JVM.

new and delete operators are mainly used to allocate and deallocate
during runtime.

a nonmatching index scan if ACCESSTYPE = 1

Requirements tracing, a process of documenting the links between the requirements and the work products developed to implement and verify those requirements. Requirement Traceability Matrix (RTM) is a document which records the mapping between the high-level requirements and the test cases in the form of a table. The RTM captures all requirements and their traceability in a single document delivered at the conclusion of the life cycle. 

That’s how it ensures that the Test Plan covers all the requirements and links to their latest version.

- Physical Data Integration is all about creating new system that replicates data from the source systems.

- This process is done to manage the data independent of the original system.

- Data Warehouse is the example of Physical Data Integration.

- The benefits of PDI include data version management, combination of data from various sources, like mainframes, flat files, databases.

- A separate system is needed for handling vast data volumes.