Technology Questions

User defined data-types in SQL is an extension to the base SQL server data-types by provision of a descriptive name.

We use them to format the database and segregate specific repetitions of rows and columns in the database.

- Use a COBOL II CALL statement to invoke a subprogram. This method is transparent to CICS, which sees only the one load module. 

- EXEC LINK is similar to a call; it invokes a separate CICS program and ends with a RETURN to the invoking program

- EXEC XCTL which transfers control to another CICS program and does not get control 

back. 

COBOL II allows for static calls which are more efficient than the LINK instruction which establishes a new run-unit. 

ArrayList and LinkedList both implements List interface and maintains insertion order. Both are non synchronized classes.

But there are many differences between ArrayList and LinkedList classes that are given below.

ArrayList    V/s     LinkedList ::

1) ArrayList internally uses dynamic array to store the elements.

                   Whereas

LinkedList internally uses doubly linked list to store the elements.

2) Manipulation with ArrayList is slow because it internally uses array. If any element is removed from the array, all the bits are shifted in memory.

                   Whereas

Manipulation with LinkedList is faster than ArrayList because it uses doubly linked list so no bit shifting is required in memory.

3) ArrayList class can act as a list only because it implements List only.

                   Whereas

LinkedList class can act as a list and queue both because it implements List and Deque interfaces.

4) ArrayList is better for storing and accessing data.

                   Whereas

LinkedList is better for manipulating data.

In a SQL Database, a 'correlated subquery' is a kind of sub query yet connected subquery is dependent on another query for a value that is returned. In case of execution, the sub query is executed first and afterwards the correlated query will be executed.

Optimized code tends to run faster and make more efficient use of the system’s resources. Optimized codes are also less susceptible to errors and take lesser space in memory and in file size.

The basic difference between ASP and ASP.NET is that ASP is interpreted; whereas, ASP.NET is compiled. This implies that since ASP uses VBScript; therefore, when an ASP page is executed, it is interpreted. On the other hand, ASP.NET uses .NET languages, such as C# and VB.NET, which are compiled to Microsoft Intermediate Language (MSIL).

Function: A Function is a block of statement which perform some operation.

Declaring the function before using the function in program is known as implicit declaration of the function.

For Example::

int bar(void); // function (forward) declaration

int main(void) {

bar(); // bar was declared, the compiler has all the info

return foo(123); // foo not yet known; impl. decl. warning

}

// not previously declared function definition

int foo(int a) {

return a;

} 

// previously declared function definition

int bar() {

return 321;

}

MIME - Multi-purpose Internet Mail Extensions. 

MIME types represents a standard way of classifying file types over Internet. 

Web servers and browsers have a list of MIME types, which facilitates files transfer of the same type in the same way, irrespective of operating system they are working in.

A MIME type has two parts: a type and a subtype. They are separated by a slash (/). 

MIME type for Microsoft Word files is application and the subtype is msword, i.e. application/msword.