Technology Questions

- A process is an execution of a program, while a Thread is a single execution sequence within a process.

- A process can contain multiple threads. A Thread is sometimes called a lightweight process.

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.

jQuery is a quick as well as concise JavaScript Library that simplifies HTML document traversing, animating, event handling, & Ajax interactions for the purpose of quick web development needs. So although they are not entirely different, both are not the same either!

To open a page in a new window, you have to use client script using onclick="window.open()" attribute of HTML control.

SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA). Its purpose is to ease the implementation of tasks for the DBA, with its full- function scheduling engine, which allows you to schedule your own jobs and scripts.

Language Integrated Query (LINQ) adds the ability to query objects using .NET languages. The LINQ to SQL object/relational mapping (O/RM) framework provides the following basic features:

- Tools to create classes (usually called entities) mapped to database tables

- Compatibility with LINQ's standard query operations

- The DataContext class, with features such as entity record monitoring, automatic SQL statement generation, record concurrency detection, and much more

Oracle check constraint is used to ensure that before inserting the data in the database, it is validated and checked for the condition.
Example:
Below, the constraint is that the id has to be between 0 and 1000.
create table employee ( id number check (id between 0 and 1000), Name varchar(200) );