Technology Questions

Stack:

 - Stack is a ordered collection of items

 - Stack is a dynamic object whose size is constantly changing as items are pushed and popped .

 - Stack may contain different data types

Array:

- Array is an ordered collection of items

- Array is a static object i.e. no of item is fixed and is assigned by the declaration of the array

- It contains same data types.

The JIT compiler is an important element of CLR, which loads MSIL on target machines for execution. The MSIL is stored in .NET assemblies after the developer has compiled the code written in any .NET-compliant programming language, such as Visual Basic and C#.

JIT compiler translates the MSIL code of an assembly and uses the CPU architecture of the target machine to execute a .NET application. It also stores the resulting native code so that it is accessible for subsequent calls. If a code executing on a target machine calls a non-native method, the JIT compiler converts the MSIL of that method into native code. JIT compiler also enforces type-safety in runtime environment of .NET Framework. It checks for the values that are passed to parameters of any method.

For example, the JIT compiler detects any event, if a user tries to assign a 32-bit value to a parameter that can only accept 8-bit value.

Postback events does the bove stated task

The Data Definition Language (DDL) is used to manage table and index structure.

CREATE,

ALTER,

RENAME,

DROP and

TRUNCATE

statements are the names of few data definition elements.

A class can have any number of constructors. If a class have more than one constructor, we call it as the constructor is overloaded.

SQL has IsDate() function which is used to check passed value is date or not of specified format ,it returns 1(true) or 0(false) accordingly.

SELECT  ISDATE('1/08/13') AS "MM/DD/YY";

It will return 0 because passed date is not in correct format.

When amount of memory to be allocated is known beforehand i.e. at the the time of compilation, it is known as Static Memory Allocation. Once the memory is allocated statically, it cannot be deallocated during program run. So it leads to wastage of storage space.

Example:

int A[100];

When amount of memory to be allocated is not known beforehand, rather it is determined at the time of program run, it is called Dynamic Memory Allocation. It leads to efficient utilization of storage space.

Example:

cout << " Enter number of elements: ";

cin >> N;

int *A = new int[N]; // dynamic memory allocation