Technology Questions

Q:

What are user defined data-types and when do you use them?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 2614
Q:

Explain the difference among the EXEC LINK, EXEC XCTL and Cobol II static call statements in CICS?

Answer

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

Report Error

View answer Workspace Report Error Discuss

0 2609
Q:

Difference between Arraylist and Linked list?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

3 2609
Q:

Define "Correlated Subqueries" ?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

6 2606
Q:

Why is code optimization important?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

0 2605
Q:

What is the basic difference between ASP and ASP.NET?

Answer

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

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2603
Q:

Warning implicit declaration of function?

Answer

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;


}

Report Error

View answer Workspace Report Error Discuss

Subject: Java
Job Role: IT Trainer , Analyst

2 2601
Q:

What is MIME?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2600