Technology Questions

The Java programming language provides a system-level thread to track memory allocation.

Garbage collection has the following characteristics:

• Checks for and frees memory no longer needed

• Is done automatically

• Can vary dramatically across JVM implementations

- 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.

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

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!

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

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.

An unspecified passive open has the server waiting for a connection request from a client. A fully specified passive

open has the server waiting for a connection from a specific client.

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) );