Sawaal

 Technology Questions

Popular Latest Rated
Q:

________ intended to address issues such as bugs and errors within existing software.

A) Fix B) BugFix
C) CodeFix D) HotFix
 
Answer & Explanation Answer: D) HotFix

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Cloud Computing
Job Role: Analyst , IT Trainer

1 2099
Q:

What is a Collection? Explain collection types.

Answer

A collection just like an array is an ordered group of elements of the same type. Each elements position is determined by a unique subscript.


 


Index by tables:- They are similar to hash arrays that allows to search for subscript values using arbitrary numbers and strings.


They can be declared as:


TYPE type_name IS TABLE OF element_type [NOT NULL]


INDEX BY [BINARY_INTEGER | PLS_INTEGER | VARCHAR2(size_limit)];


INDEX BY key_type;


Example:


TYPE studenttyp IS TABLE OF emp%ROWTYPE


INDEX BY BINARY_INTEGER;


stud_tab studenttyp;


 


Nested tables:- they hold random number of elements and use sequential numbers as sub scripts.


They can be declared as:


TYPE type_name IS TABLE OF element_type [NOT NULL];


Example: TYPE employee_type IS TABLE OF NUMBER INDEX BY VARCHAR2(64);


 


Varrays: Holds a fixed number of elements which can be changed in run time. 


They can be declared as:


TYPE type_name IS {VARRAY | VARYING ARRAY} (size_limit) OF element_type [NOT NULL];


Example: TYPE Calendar IS VARRAY(366) OF DATE;

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2097
Q:

Explain the difference between trigger and stored procedure.

Answer

-  A stored procedure can accept parameters while a trigger cannot.
-  A trigger can’t return any value while stored procedures can.
-  A trigger is executed automatically on some event while a stored procedure needs to be explicitly called.
-  Triggers are used for insertions, update and deletions on tables while stored procedures are often using independently in the database.
-  A trigger cannot be written in a stored procedure. However, the reverse is not possible.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2096
Q:

What is a sub query? What are its various types?

Answer

- Sub Query also termed as Nested Query or Inner Query is used to get data from multiple tables.
- A sub query is added in the where clause of the main query.

There can be two types of subqueries:
a.) Correlated sub query :
- It can reference column in a table listed in the from list of the outer query but is not as independent as a query.
b.) Non-Correlated sub query :
- Results of this sub query are submitted to the main query or parent query.
- It is independent like a query

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2094
Q:

How to create a Delegate?

Answer

public delegate void Del<T>(T item);


Del<int> d1 = new Del<int>(Notify);

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2093
Q:

How to insert Javascript in HTML?

Answer

We can insert JavaScript in HTML using <Script tag>. JavaScript can be enclosed in <script type = text/javascript> and ending with </script>.


Example: 


<html> 


  <body> 


        <script type="text/javascript"> 


               ...JavaScript….


         </script> 


   </body> 


</html>

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2092
Q:

How to do MultiThreading in Java?

Answer

To do multi threading in java we use interfaces and classes defined in java.lang package.


Those classes and interfaces are:


Java.lang.Runnable, Java.lang. Thread, Java.lang.ThreadGroup

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2091
Q:

How to call argument constructor?

Answer

new ClassName( arg1, arg2, .... argN);


Ex:


Class sample {


   Sample(int a) {


   System.out.println("arg con a =" +a);


   }


}


class Demo {


    Public static void main( String[] args) {


     Sample s1= new Sample(23);


     Sample s2= new Sample(45);


    }


}

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2087