Technology Questions

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 1935
Q:

What are Cursors? Explain Types of cursors in PL/SQL

Answer

Cursors help you manipulate the information retrieved by select statements. This can be done by assigning a name to the cursor.


Example:


CURSOR emp_cur 


IS 


SELECT emp_number from employee_tbl where employee_name = name_in;


Types of Cursors:


Implicit cursors- These cursors are not declared by the programmer. They are issued when the SQL statement is executed. The open, close and fetching is done by itself.


Example:


UPDATE employee SET salary = salary * 2.1;


Here, an implicit cursor is issued to identify the set of rows in the table which would be affected by the update.


 


Explicit cursors- These cursors are defined by programmer. They are used in queries that return multiple rows.


Example:


CURSOR emp_cur 


IS 


SELECT emp_number from employee_tbl where employee_name = name_in;

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

1 1933
Q:

What are the the different ways for creating a thread?

Answer

A thread can be created by subclassing Thread, or by implementing the Runnable interface.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 1933
Q:

How does a try statement determine which catch clause should be used to handle an exception?

Answer

When an exception is thrown , the catch block of the try statement are examined in the order in which they appear. The first catch block that is capable of handling the exception is executed. The remaining catch blocks are ignored

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 1930
Q:

How would you automatically transfer your visitors to a new web page?

Answer

- You can do it with the help of meta tag mentioned below: 


<META HTTP-EQUIV="Refresh" CONTENT="2"; URL="https://www.yoursite.com"> 


- Place this tag between <HEAD></HEAD> . 


- It will load yousite.com in 2 seconds.

Report Error

View answer Workspace Report Error Discuss

0 1929
Q:

What are the principles in providing the security for the computer programs?

Answer

- The principle of least privilege is used to provide more security to the computer programs. 


- The principle allows the designing of the program such that any unauthorized access is not allowed and only the person who owns the program will be able to access it. 


- The services provided should be able to access only those products that need the services. 


- Web servers that are involved in responding the queries of the web users provide only accessing to the HTML files that will serve the purpose of the programs. 


- Computer programs should be made such that it provides secure features of logging into the program with proper authentication.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1928
Q:

What is different among String, StringBuffer, StringBuilder?

Answer

String class objects are immutable objects and they represents strings( sequence of characters)


StringBuffer class objects are mutable objects representing strings and they are Thread safe


StringBuild class objects are also mutable objects representing strings and they are not Thread safe

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 1928
Q:

Explain about Blackberry Operating System.

Answer

Research in Motion, a Canadian company provided a proprietary operating system for BlackBerry.

The operating system provides support for Java MIDP 1.0 and WAP 1.2.

The current version supports Novell Group Wise and Lotus Notes.

Third-party software can be developed using BlackBerry APIs as well, with certain restriction functionality must be signed by RIM digitally, so that it can be associated to a developer account. 

Report Error

View answer Workspace Report Error Discuss

0 1927