Technology Questions

Q:

What are the steps required to execute a query in JDBC?

Answer

First we need to create an instance of a JDBC driver or load JDBC drivers, then we need to register this driver with DriverManager class. Then we can open a connection. By using this connection , we can create a statement object and this object will help us to execute the query.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 1769
Q:

What do you think is the most important responsibility of a business analyst?

Answer

Requirements gathering, functional design and business process, change management etc are very critical tasks for a business analyst.

Report Error

View answer Workspace Report Error Discuss

2 1768
Q:

Why an infocube has maximum of 16 dimensions?

Answer

Because any Database will supports only 16 foreign keys in a database table. 


It depends upon the Database limits provided to define the Foreign key constraint, e.g. in Sql Server 2005, the recommended max limit for foreign keys is 253, but you can define more.

Report Error

View answer Workspace Report Error Discuss

0 1767
Q:

Both PL/SQL and Java (or) .NET code can be used to create Oracle stored procedures and triggers. Which of the one should be used and why?

Answer

Even though both PL/SQL and Java (or) .NET can be used, PL/SQL stands above these two in terms of integration overhead. This is because Java is an open source proprietary and Data manipulation is slightly faster in PL/SQL than in Java. 

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 1766
Q:

What is Pareto Analysis?

Answer

Pareto analysis is otherwise known as the 80/20 rule. It stipulates that 80%of problems will arise from 20% of causes – that few factors can create big problems.


 

Report Error

View answer Workspace Report Error Discuss

0 1765
Q:

What is abstract method?

Answer

abstract method is a method declared with abstract modifier but  with out body.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 1764
Q:

What is a delegate?

Answer

A delegate declares a ref type that references a named of anonymous method. Delegates are secure and type-safe. Consider them as type safe function pointers.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 1761
Q:

AND, OR and NOT are examples of

A) Clauses B) Boolean operators
C) Conjuctive operators D) Exclusive operators
 
Answer & Explanation Answer: B) Boolean operators

Explanation:
Report Error

View Answer Report Error Discuss

1 1756